index

Package sb_phoneassignment_rules

This package provides support subprograms for the Phone Assignment API.

Program units
p_register_entity  
p_validate  

p_register_entity 

Procedure p_register_entity(
      p_operation_type         NUMBER,
      p_pidm                   slrpasg.slrpasg_pidm%TYPE,
      p_term_code              slrpasg.slrpasg_term_code%TYPE,
      p_prcd_code              slrpasg.slrpasg_prcd_code%TYPE,
      p_phone_account_number   slrpasg.slrpasg_phone_account_number%TYPE,
      p_phone_area             slrpasg.slrpasg_phone_area%TYPE,
      p_phone_ext              slrpasg.slrpasg_phone_ext%TYPE,
      p_phone_number           slrpasg.slrpasg_phone_number%TYPE,
      p_begin_date             slrpasg.slrpasg_begin_date%TYPE,
      p_end_date               slrpasg.slrpasg_end_date%TYPE,
      p_total_days             slrpasg.slrpasg_total_days%TYPE,
      p_total_months           slrpasg.slrpasg_total_months%TYPE,
      p_total_terms            slrpasg.slrpasg_total_terms%TYPE,
      p_pscd_code              slrpasg.slrpasg_pscd_code%TYPE,
      p_pscd_date              slrpasg.slrpasg_pscd_date%TYPE,
      p_onl_or_bat             slrpasg.slrpasg_onl_or_bat%TYPE,
      p_ar_ind                 slrpasg.slrpasg_ar_ind%TYPE,
      p_roll_ind               slrpasg.slrpasg_roll_ind%TYPE,
      p_assess_needed          slrpasg.slrpasg_assess_needed%TYPE,
      p_data_origin            slrpasg.slrpasg_data_origin%TYPE,
      p_user_id                slrpasg.slrpasg_user_id%TYPE DEFAULT gb_common.f_sct_user,
      p_internal_record_id     VARCHAR2
   )

Register the attribute/value pairs to the message cache.
This signature registers the all parameters.

Parameters
p_pidm   Internal identifier associated with the phone assignment. NUMBER(8) Required
p_term_code   Term associated with the phone assignment.  VARCHAR2(6) Required
p_prcd_code   Phone rate code associated with the phone assignment. VARCHAR2(4) Required
p_phone_account_number   Phone account number associated with the phone assignment.  VARCHAR2(20) Required
p_phone_area   Area code of the phone number associated with the phone assignment.  VARCHAR2(3) Required
p_phone_ext   Extension of the phone number associated with the phone assignment.  VARCHAR2(4) Required
p_phone_number   Phone number associated with the phone assignment.  VARCHAR2(7) Required
p_begin_date   First day of the phone assignment. DATE Required
p_end_date   Last day of the phone assignment.  DATE Required
p_total_days   Total number of days of the phone assignment.  NUMBER(9,5) Required
p_total_months   Total number of months of the phone assignment. NUMBER(7,5) Required
p_total_terms   Total number of terms of the phone assignment. NUMBER(7,5) Required
p_pscd_code   Phone plan status code of the meal assignment. VARCHAR2(2) Required
p_pscd_date   Date the phone plan status code was last updated. DATE Required
p_onl_or_bat   Specifies whether the phone assignment was created online or in batch using the batch scheduler. VARCHAR2(1) Required
p_ar_ind   Specifies whether the phone assignment charges have been processes. VARCHAR2(1) Required
p_roll_ind   Controls whether the phone assignment can be rolled using the roll forward process. VARCHAR2(1) Required
p_assess_needed   Specifies whether fee assessment is needed for the phone assignment.  VARCHAR2(1) Required
p_data_origin   Source system that generated the data. VARCHAR2(30) Required
p_user_id   The Oracle ID of the user who inserted or last updated the data. VARCHAR2(30) Required
p_internal_record_id   Database ROWID. VARCHAR2(18) Required

p_validate 

Procedure p_validate(
      p_pidm                   slrpasg.slrpasg_pidm%TYPE,
      p_term_code              slrpasg.slrpasg_term_code%TYPE,
      p_prcd_code              slrpasg.slrpasg_prcd_code%TYPE,
      p_phone_account_number   slrpasg.slrpasg_phone_account_number%TYPE
            DEFAULT NULL,
      p_phone_area             slrpasg.slrpasg_phone_area%TYPE DEFAULT NULL,
      p_phone_ext              slrpasg.slrpasg_phone_ext%TYPE DEFAULT NULL,
      p_phone_number           slrpasg.slrpasg_phone_number%TYPE,
      p_begin_date             slrpasg.slrpasg_begin_date%TYPE,
      p_end_date               slrpasg.slrpasg_end_date%TYPE,
      p_total_days             slrpasg.slrpasg_total_days%TYPE,
      p_total_months           slrpasg.slrpasg_total_months%TYPE,
      p_total_terms            slrpasg.slrpasg_total_terms%TYPE,
      p_pscd_code              slrpasg.slrpasg_pscd_code%TYPE,
      p_pscd_date              slrpasg.slrpasg_pscd_date%TYPE,
      p_onl_or_bat             slrpasg.slrpasg_onl_or_bat%TYPE,
      p_ar_ind                 slrpasg.slrpasg_ar_ind%TYPE,
      p_roll_ind               slrpasg.slrpasg_roll_ind%TYPE DEFAULT NULL,
      p_assess_needed          slrpasg.slrpasg_assess_needed%TYPE,
      p_data_origin            slrpasg.slrpasg_data_origin%TYPE DEFAULT NULL,
      p_user_id                slrpasg.slrpasg_user_id%TYPE DEFAULT gb_common.f_sct_user
   )

Validates all the data in the record.

Parameters
p_pidm   Internal identifier associated with the phone assignment. NUMBER(8) Required
p_term_code   Term associated with the phone assignment.  VARCHAR2(6) Required
p_prcd_code   Phone rate code associated with the phone assignment. VARCHAR2(4) Required
p_phone_account_number   Phone account number associated with the phone assignment.  VARCHAR2(20)
p_phone_area   Area code of the phone number associated with the phone assignment.  VARCHAR2(3)
p_phone_ext   Extension of the phone number associated with the phone assignment.  VARCHAR2(4)
p_phone_number   Phone number associated with the phone assignment.  VARCHAR2(7) Required
p_begin_date   First day of the phone assignment. DATE Required
p_end_date   Last day of the phone assignment.  DATE Required
p_total_days   Total number of days of the phone assignment.  NUMBER(9,5) Required
p_total_months   Total number of months of the phone assignment. NUMBER(7,5) Required
p_total_terms   Total number of terms of the phone assignment. NUMBER(7,5) Required
p_pscd_code   Phone plan status code of the meal assignment. VARCHAR2(2) Required
p_pscd_date   Date the phone plan status code was last updated. DATE Required
p_onl_or_bat   Specifies whether the phone assignment was created online or in batch using the batch scheduler. VARCHAR2(1) Required
p_ar_ind   Specifies whether the phone assignment charges have been processes. VARCHAR2(1) Required
p_roll_ind   Controls whether the phone assignment can be rolled using the roll forward process. VARCHAR2(1)
p_assess_needed   Specifies whether fee assessment is needed for the phone assignment.  VARCHAR2(1) Required
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_user_id   The Oracle ID of the user who inserted or last updated the data. VARCHAR2(30)