index

Package sb_studypath_rules

Support subprograms for the Study Path API (sb_studypath).

Program units
p_register_entity   Registers the attribute value pairs to the message cache for delete operations.
p_register_entity   Registers the attribute/value pairs to the message cache for create and update operations.
p_validate   Validates all data in the record.

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id gb_common.internal_record_id_type)

Registers the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only for delete operations.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_register_entity 

Procedure p_register_entity(p_operation_type     NUMBER,
                            p_pidm               sgrstsp.sgrstsp_pidm%TYPE,
                            p_term_code_eff      sgrstsp.sgrstsp_term_code_eff%TYPE,
                            p_key_seqno          sgrstsp.sgrstsp_key_seqno%TYPE,
                            p_stsp_code          sgrstsp.sgrstsp_stsp_code%TYPE,
                            p_data_origin        sgrstsp.sgrstsp_data_origin%TYPE,
                            p_user_id            sgrstsp.sgrstsp_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_full_part_ind      sgrstsp.sgrstsp_full_part_ind%TYPE,
                            p_sess_code          sgrstsp.sgrstsp_sess_code%TYPE,
                            p_resd_code          sgrstsp.sgrstsp_resd_code%TYPE,
                            p_orsn_code          sgrstsp.sgrstsp_orsn_code%TYPE,
                            p_prac_code          sgrstsp.sgrstsp_prac_code%TYPE,
                            p_capl_code          sgrstsp.sgrstsp_capl_code%TYPE,
                            p_edlv_code          sgrstsp.sgrstsp_edlv_code%TYPE,
                            p_incm_code          sgrstsp.sgrstsp_incm_code%TYPE,
                            p_emex_code          sgrstsp.sgrstsp_emex_code%TYPE,
                            p_aprn_code          sgrstsp.sgrstsp_aprn_code%TYPE,
                            p_trcn_code          sgrstsp.sgrstsp_trcn_code%TYPE,
                            p_gain_code          sgrstsp.sgrstsp_gain_code%TYPE,
                            p_voed_code          sgrstsp.sgrstsp_voed_code%TYPE,
                            p_blck_code          sgrstsp.sgrstsp_blck_code%TYPE,
                            p_egol_code          sgrstsp.sgrstsp_egol_code%TYPE,
                            p_bskl_code          sgrstsp.sgrstsp_bskl_code%TYPE,
                            p_astd_code          sgrstsp.sgrstsp_astd_code%TYPE,
                            p_prev_code          sgrstsp.sgrstsp_prev_code%TYPE,
                            p_cast_code          sgrstsp.sgrstsp_cast_code%TYPE,
                            p_internal_record_id gb_common.internal_record_id_type)

Registers the attribute/value pairs to the message cache for create and update operations.
 
This signature registers all parameters.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required
p_pidm   Unique internal ID for individual who has records in the system. NUMBER(8) Required Key
p_term_code_eff   This is the term the student record is effective. VARCHAR2(24) Required Key
p_key_seqno   This is the sequence number of  the Study Path. NUMBER(2) Required Key
p_stsp_code   Students study path status for the effective term. VARCHAR2(16) Required
p_data_origin   Source system that generated the data. VARCHAR2(120) Required
p_user_id   The most recent user to update a record. VARCHAR2(120) Required
p_full_part_ind   This field identifies whether the student is a full or part-time student. VARCHAR2(4)
p_sess_code   Session student is attending for the effective term. VARCHAR2(4)
p_resd_code   Residency status of the student for the effective term. VARCHAR2(4)
p_orsn_code   Orientation session assigned to the student for the Effective term. VARCHAR2(4)
p_prac_code   Practical training experience of the student for the  effective term. VARCHAR2(8)
p_capl_code   This field identifies career plan of the student for the effective term. VARCHAR2(8)
p_edlv_code   A two position alphanumeric field which indicate the highest level of the education that the student completed. VARCHAR2(12)
p_incm_code   A two position alphanumeric field which indicate the income range of the student. VARCHAR2(8)
p_emex_code   General Student Employment Expectation Code. VARCHAR2(8)
p_aprn_code   General Student Apprenticeship Code. VARCHAR2(8)
p_trcn_code   General Student Transfer Center Code. VARCHAR2(8)
p_gain_code   Employment and training code of the student for the effective term. VARCHAR2(8)
p_voed_code   General Student Vocation Education Status Code. VARCHAR2(8)
p_blck_code   Block Schedule Code. VARCHAR2(40)
p_egol_code   Educational Goal code. VARCHAR2(8)
p_bskl_code   Student Basic Skills Code. VARCHAR2(8)
p_astd_code   Academic standing override for a student for the effective term. VARCHAR2(8)
p_prev_code   General Student record Progress Evaluation code. VARCHAR2(8)
p_cast_code   General Student record Combined Academic Standing code. VARCHAR2(8)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_pidm          sgrstsp.sgrstsp_pidm%TYPE,
                     p_term_code_eff sgrstsp.sgrstsp_term_code_eff%TYPE,
                     p_key_seqno     sgrstsp.sgrstsp_key_seqno%TYPE,
                     p_stsp_code     sgrstsp.sgrstsp_stsp_code%TYPE,
                     p_data_origin   sgrstsp.sgrstsp_data_origin%TYPE,
                     p_user_id       sgrstsp.sgrstsp_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_full_part_ind sgrstsp.sgrstsp_full_part_ind%TYPE DEFAULT NULL,
                     p_sess_code     sgrstsp.sgrstsp_sess_code%TYPE DEFAULT NULL,
                     p_resd_code     sgrstsp.sgrstsp_resd_code%TYPE DEFAULT NULL,
                     p_orsn_code     sgrstsp.sgrstsp_orsn_code%TYPE DEFAULT NULL,
                     p_prac_code     sgrstsp.sgrstsp_prac_code%TYPE DEFAULT NULL,
                     p_capl_code     sgrstsp.sgrstsp_capl_code%TYPE DEFAULT NULL,
                     p_edlv_code     sgrstsp.sgrstsp_edlv_code%TYPE DEFAULT NULL,
                     p_incm_code     sgrstsp.sgrstsp_incm_code%TYPE DEFAULT NULL,
                     p_emex_code     sgrstsp.sgrstsp_emex_code%TYPE DEFAULT NULL,
                     p_aprn_code     sgrstsp.sgrstsp_aprn_code%TYPE DEFAULT NULL,
                     p_trcn_code     sgrstsp.sgrstsp_trcn_code%TYPE DEFAULT NULL,
                     p_gain_code     sgrstsp.sgrstsp_gain_code%TYPE DEFAULT NULL,
                     p_voed_code     sgrstsp.sgrstsp_voed_code%TYPE DEFAULT NULL,
                     p_blck_code     sgrstsp.sgrstsp_blck_code%TYPE DEFAULT NULL,
                     p_egol_code     sgrstsp.sgrstsp_egol_code%TYPE DEFAULT NULL,
                     p_bskl_code     sgrstsp.sgrstsp_bskl_code%TYPE DEFAULT NULL,
                     p_astd_code     sgrstsp.sgrstsp_astd_code%TYPE DEFAULT NULL,
                     p_prev_code     sgrstsp.sgrstsp_prev_code%TYPE DEFAULT NULL,
                     p_cast_code     sgrstsp.sgrstsp_cast_code%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_pidm   Unique internal ID for individual who has records in the system. NUMBER(8) Required Key
p_term_code_eff   This is the term the student record is effective. VARCHAR2(24) Required Key
p_key_seqno   This is the sequence number of  the Study Path. NUMBER(2) Required Key
p_stsp_code   Students study path status for the effective term. VARCHAR2(16) Required
p_data_origin   Source system that generated the data. VARCHAR2(120) Required
p_user_id   The most recent user to update a record. VARCHAR2(120) Required
p_full_part_ind   This field identifies whether the student is a full or part-time student. VARCHAR2(4)
p_sess_code   Session student is attending for the effective term. VARCHAR2(4)
p_resd_code   Residency status of the student for the effective term. VARCHAR2(4)
p_orsn_code   Orientation session assigned to the student for the Effective term. VARCHAR2(4)
p_prac_code   Practical training experience of the student for the  effective term. VARCHAR2(8)
p_capl_code   This field identifies career plan of the student for the effective term. VARCHAR2(8)
p_edlv_code   A two position alphanumeric field which indicate the highest level of the education that the student completed. VARCHAR2(12)
p_incm_code   A two position alphanumeric field which indicate the income range of the student. VARCHAR2(8)
p_emex_code   General Student Employment Expectation Code. VARCHAR2(8)
p_aprn_code   General Student Apprenticeship Code. VARCHAR2(8)
p_trcn_code   General Student Transfer Center Code. VARCHAR2(8)
p_gain_code   Employment and training code of the student for the effective term. VARCHAR2(8)
p_voed_code   General Student Vocation Education Status Code. VARCHAR2(8)
p_blck_code   Block Schedule Code. VARCHAR2(40)
p_egol_code   Educational Goal code. VARCHAR2(8)
p_bskl_code   Student Basic Skills Code. VARCHAR2(8)
p_astd_code   Academic standing override for a student for the effective term. VARCHAR2(8)
p_prev_code   General Student record Progress Evaluation code. VARCHAR2(8)
p_cast_code   General Student record Combined Academic Standing code. VARCHAR2(8)