index

Package sb_faculty_rules

This package provides the support subprograms for the Faculty API.

Program units
p_register_entity  
p_validate  

p_register_entity 

Procedure p_register_entity(
      p_operation_type       NUMBER,
      p_pidm                 sibinst.sibinst_pidm%TYPE,
      p_term_code_eff        sibinst.sibinst_term_code_eff%TYPE,
      p_fcst_code            sibinst.sibinst_fcst_code%TYPE,
      p_fctg_code            sibinst.sibinst_fctg_code%TYPE,
      p_fstp_code            sibinst.sibinst_fstp_code%TYPE,
      p_fcnt_code            sibinst.sibinst_fcnt_code%TYPE,
      p_schd_ind             sibinst.sibinst_schd_ind%TYPE,
      p_advr_ind             sibinst.sibinst_advr_ind%TYPE,
      p_fcst_date            sibinst.sibinst_fcst_date%TYPE,
      p_wkld_code            sibinst.sibinst_wkld_code%TYPE,
      p_cntr_code            sibinst.sibinst_cntr_code%TYPE,
      p_appoint_date         sibinst.sibinst_appoint_date%TYPE,
      p_data_origin          sibinst.sibinst_data_origin%TYPE,
      p_user_id              sibinst.sibinst_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 personal identification number of the faculty member.  NUMBER(8) Required key
p_term_code_eff   Effective term of the faculty member. VARCHAR2(6) Required key
p_fcst_code   Faculty member status. VARCHAR2(2) Required
p_fctg_code   Faculty member category.  VARCHAR2(6) Required
p_fstp_code   Faculty member staff type, which is required for workload calculation.  VARCHAR2(4) Required
p_fcnt_code   Faculty member contract rule, which is required for workload calculation.  VARCHAR2(2) Required
p_schd_ind   Faculty member available for schedule indicator. VARCHAR2(1) Required
p_advr_ind   Faculty member available for advising indicator.  VARCHAR2(1) Required
p_fcst_date   Faculty member status date.  DATE Required
p_wkld_code   Faculty member workload rule code. VARCHAR2(6) Required
p_cntr_code   Faculty member contract rule code. VARCHAR2(6) Required
p_appoint_date   The date the appointment was awarded. DATE Required
p_data_origin   Source system that generated the data. VARCHAR2(30) Required
p_user_id   Oracle ID of the user who inserted or last updated the data.  VARCHAR2(30)
p_internal_record_id   Database ROWID.  VARCHAR2(18) Required

p_validate 

Procedure p_validate(
      p_pidm            sibinst.sibinst_pidm%TYPE,
      p_term_code_eff   sibinst.sibinst_term_code_eff%TYPE,
      p_fcst_code       sibinst.sibinst_fcst_code%TYPE,
      p_fctg_code       sibinst.sibinst_fctg_code%TYPE DEFAULT NULL,
      p_fstp_code       sibinst.sibinst_fstp_code%TYPE DEFAULT NULL,
      p_fcnt_code       sibinst.sibinst_fcnt_code%TYPE DEFAULT NULL,
      p_schd_ind        sibinst.sibinst_schd_ind%TYPE DEFAULT NULL,
      p_advr_ind        sibinst.sibinst_advr_ind%TYPE DEFAULT NULL,
      p_fcst_date       sibinst.sibinst_fcst_date%TYPE,
      p_wkld_code       sibinst.sibinst_wkld_code%TYPE DEFAULT NULL,
      p_cntr_code       sibinst.sibinst_cntr_code%TYPE DEFAULT NULL,
      p_appoint_date    sibinst.sibinst_appoint_date%TYPE DEFAULT NULL,
      p_data_origin     sibinst.sibinst_data_origin%TYPE DEFAULT NULL,
      p_user_id         sibinst.sibinst_user_id%TYPE DEFAULT gb_common.f_sct_user
   )

Validates all the data in the record

Parameters
p_pidm   Internal personal identification number of the faculty member.  NUMBER(8) Required key
p_term_code_eff   Effective term of the faculty member. VARCHAR2(6) Required key
p_fcst_code   Faculty member status. VARCHAR2(2)
p_fctg_code   Faculty member category.  VARCHAR2(6)
p_fstp_code   Faculty member staff type, which is required for workload calculation.  VARCHAR2(4)
p_fcnt_code   Faculty member contract rule, which is required for workload calculation.  VARCHAR2(2)
p_schd_ind   Faculty member available for schedule indicator. VARCHAR2(1)
p_advr_ind   Faculty member available for advising indicator.  VARCHAR2(1)
p_fcst_date   Faculty member status date.  DATE Required
p_wkld_code   Faculty member workload rule code. VARCHAR2(6)
p_cntr_code   Faculty member contract rule code. VARCHAR2(6)
p_appoint_date   The date the appointment was awarded. DATE
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_user_id   Oracle ID of the user who inserted or last updated the data.  VARCHAR2(30)