eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_CA_INST

Line 8: p_cal_type igs_ca_inst.cal_type%TYPE,

4: pkg_coreq_failed_uooids VARCHAR2(2000);
5: pkg_prereq_failed_uooids VARCHAR2(2000);
6: PROCEDURE validate_prog_pro(
7: p_person_id igs_en_su_attempt.person_id%TYPE,
8: p_cal_type igs_ca_inst.cal_type%TYPE,
9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
11: p_course_cd igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

Line 9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

5: pkg_prereq_failed_uooids VARCHAR2(2000);
6: PROCEDURE validate_prog_pro(
7: p_person_id igs_en_su_attempt.person_id%TYPE,
8: p_cal_type igs_ca_inst.cal_type%TYPE,
9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
11: p_course_cd igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
13: p_message_name OUT NOCOPY VARCHAR2,

Line 84: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

80: l_step_eval_result BOOLEAN;
81: l_message VARCHAR2(2000);
82: l_deny_warn VARCHAR2(10);
83: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
84: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
85: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
87: lv_message fnd_new_messages.message_name%TYPE;
88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

Line 85: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

81: l_message VARCHAR2(2000);
82: l_deny_warn VARCHAR2(10);
83: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
84: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
85: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
87: lv_message fnd_new_messages.message_name%TYPE;
88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
89: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

Line 86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

82: l_deny_warn VARCHAR2(10);
83: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
84: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
85: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
87: lv_message fnd_new_messages.message_name%TYPE;
88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
89: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
90: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

Line 88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

84: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
85: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
87: lv_message fnd_new_messages.message_name%TYPE;
88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
89: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
90: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: l_return_status VARCHAR2(10);
92: l_dummy VARCHAR2(200);

Line 89: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

85: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
87: lv_message fnd_new_messages.message_name%TYPE;
88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
89: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
90: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: l_return_status VARCHAR2(10);
92: l_dummy VARCHAR2(200);
93:

Line 90: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

86: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
87: lv_message fnd_new_messages.message_name%TYPE;
88: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
89: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
90: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
91: l_return_status VARCHAR2(10);
92: l_dummy VARCHAR2(200);
93:
94:

Line 182: p_cal_type IN igs_ca_inst.cal_type%TYPE,

178:
179:
180: PROCEDURE validate_unit_steps(
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_cal_type IN igs_ca_inst.cal_type%TYPE,
183: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
185: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
186: p_return_status OUT NOCOPY VARCHAR2,

Line 183: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

179:
180: PROCEDURE validate_unit_steps(
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_cal_type IN igs_ca_inst.cal_type%TYPE,
183: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
185: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
186: p_return_status OUT NOCOPY VARCHAR2,
187: p_message_name OUT NOCOPY VARCHAR2,

Line 446: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

442: );
443: END enroll_cart_unit;
444: PROCEDURE Validate_enroll_validate (
445: p_person_id IN igs_en_su_attempt.person_id%TYPE,
446: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
447: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
448: p_uoo_ids IN VARCHAR2,
449: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
450: p_message_name OUT NOCOPY VARCHAR2,

Line 447: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

443: END enroll_cart_unit;
444: PROCEDURE Validate_enroll_validate (
445: p_person_id IN igs_en_su_attempt.person_id%TYPE,
446: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
447: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
448: p_uoo_ids IN VARCHAR2,
449: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
450: p_message_name OUT NOCOPY VARCHAR2,
451: p_deny_warn OUT NOCOPY VARCHAR2,

Line 1016: l_acad_cal_type igs_ca_inst.cal_type%type;

1012: l_enr_ci_seq NUMBER(20);
1013: l_enr_cat VARCHAR2(20);
1014: l_enr_comm VARCHAR2(2000);
1015:
1016: l_acad_cal_type igs_ca_inst.cal_type%type;
1017: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
1018: l_acad_start_dt igs_ca_inst.start_dt%type;
1019: l_acad_end_dt igs_ca_inst.end_dt%type;
1020: l_alternate_code igs_ca_inst.alternate_code%type;

Line 1017: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;

1013: l_enr_cat VARCHAR2(20);
1014: l_enr_comm VARCHAR2(2000);
1015:
1016: l_acad_cal_type igs_ca_inst.cal_type%type;
1017: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
1018: l_acad_start_dt igs_ca_inst.start_dt%type;
1019: l_acad_end_dt igs_ca_inst.end_dt%type;
1020: l_alternate_code igs_ca_inst.alternate_code%type;
1021: l_acad_message varchar2(100);

Line 1018: l_acad_start_dt igs_ca_inst.start_dt%type;

1014: l_enr_comm VARCHAR2(2000);
1015:
1016: l_acad_cal_type igs_ca_inst.cal_type%type;
1017: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
1018: l_acad_start_dt igs_ca_inst.start_dt%type;
1019: l_acad_end_dt igs_ca_inst.end_dt%type;
1020: l_alternate_code igs_ca_inst.alternate_code%type;
1021: l_acad_message varchar2(100);
1022:

Line 1019: l_acad_end_dt igs_ca_inst.end_dt%type;

1015:
1016: l_acad_cal_type igs_ca_inst.cal_type%type;
1017: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
1018: l_acad_start_dt igs_ca_inst.start_dt%type;
1019: l_acad_end_dt igs_ca_inst.end_dt%type;
1020: l_alternate_code igs_ca_inst.alternate_code%type;
1021: l_acad_message varchar2(100);
1022:
1023: -- Added as part of Enrollment Eligibility and validations

Line 1020: l_alternate_code igs_ca_inst.alternate_code%type;

1016: l_acad_cal_type igs_ca_inst.cal_type%type;
1017: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
1018: l_acad_start_dt igs_ca_inst.start_dt%type;
1019: l_acad_end_dt igs_ca_inst.end_dt%type;
1020: l_alternate_code igs_ca_inst.alternate_code%type;
1021: l_acad_message varchar2(100);
1022:
1023: -- Added as part of Enrollment Eligibility and validations
1024: l_eftsu_total igs_en_su_attempt.override_eftsu%type;

Line 1800: CURSOR cur_cal_desc IS SELECT description FROM igs_ca_inst WHERE cal_type = p_load_cal_type

1796: FROM DUAL;
1797:
1798: CURSOR cur_user_name IS SELECT user_name FROM fnd_user WHERE user_id = fnd_global.user_id;
1799:
1800: CURSOR cur_cal_desc IS SELECT description FROM igs_ca_inst WHERE cal_type = p_load_cal_type
1801: AND sequence_number = p_load_sequence_number;
1802:
1803: l_cur_seq_val cur_seq_val%ROWTYPE;
1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T := wf_parameter_list_t();

Line 1807: l_cal_desc IGS_CA_INST.DESCRIPTION%TYPE;

1803: l_cur_seq_val cur_seq_val%ROWTYPE;
1804: l_wf_parameter_list_t WF_PARAMETER_LIST_T := wf_parameter_list_t();
1805: l_wf_installed fnd_lookups.lookup_code%TYPE;
1806: l_wf_role VARCHAR2(100);
1807: l_cal_desc IGS_CA_INST.DESCRIPTION%TYPE;
1808:
1809: BEGIN
1810: -- get the profile value that is set for checking if workflow is installed
1811: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

Line 2118: l_acad_cal_type igs_ca_inst.cal_type%type;

2114: l_enr_incurred_cp NUMBER DEFAULT 0;
2115: l_over_incurred_cp NUMBER DEFAULT 0;
2116: l_current_cp NUMBER DEFAULT 0;
2117: l_dummy NUMBER;
2118: l_acad_cal_type igs_ca_inst.cal_type%type;
2119: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
2120: l_acad_start_dt igs_ca_inst.start_dt%type;
2121: l_acad_end_dt igs_ca_inst.end_dt%type;
2122: l_alternate_code igs_ca_inst.alternate_code%type;

Line 2119: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;

2115: l_over_incurred_cp NUMBER DEFAULT 0;
2116: l_current_cp NUMBER DEFAULT 0;
2117: l_dummy NUMBER;
2118: l_acad_cal_type igs_ca_inst.cal_type%type;
2119: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
2120: l_acad_start_dt igs_ca_inst.start_dt%type;
2121: l_acad_end_dt igs_ca_inst.end_dt%type;
2122: l_alternate_code igs_ca_inst.alternate_code%type;
2123: l_acad_message varchar2(100);

Line 2120: l_acad_start_dt igs_ca_inst.start_dt%type;

2116: l_current_cp NUMBER DEFAULT 0;
2117: l_dummy NUMBER;
2118: l_acad_cal_type igs_ca_inst.cal_type%type;
2119: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
2120: l_acad_start_dt igs_ca_inst.start_dt%type;
2121: l_acad_end_dt igs_ca_inst.end_dt%type;
2122: l_alternate_code igs_ca_inst.alternate_code%type;
2123: l_acad_message varchar2(100);
2124: l_message VARCHAR2(1200);

Line 2121: l_acad_end_dt igs_ca_inst.end_dt%type;

2117: l_dummy NUMBER;
2118: l_acad_cal_type igs_ca_inst.cal_type%type;
2119: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
2120: l_acad_start_dt igs_ca_inst.start_dt%type;
2121: l_acad_end_dt igs_ca_inst.end_dt%type;
2122: l_alternate_code igs_ca_inst.alternate_code%type;
2123: l_acad_message varchar2(100);
2124: l_message VARCHAR2(1200);
2125: l_return_status VARCHAR2(10);

Line 2122: l_alternate_code igs_ca_inst.alternate_code%type;

2118: l_acad_cal_type igs_ca_inst.cal_type%type;
2119: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
2120: l_acad_start_dt igs_ca_inst.start_dt%type;
2121: l_acad_end_dt igs_ca_inst.end_dt%type;
2122: l_alternate_code igs_ca_inst.alternate_code%type;
2123: l_acad_message varchar2(100);
2124: l_message VARCHAR2(1200);
2125: l_return_status VARCHAR2(10);
2126: l_dummy1 VARCHAR2(200);

Line 2690: l_acad_start_dt igs_ca_inst.start_dt%type;

2686: l_total_credit_points NUMBER;
2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2690: l_acad_start_dt igs_ca_inst.start_dt%type;
2691: l_acad_end_dt igs_ca_inst.end_dt%type;
2692: l_alternate_code igs_ca_inst.alternate_code%type;
2693:
2694:

Line 2691: l_acad_end_dt igs_ca_inst.end_dt%type;

2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2690: l_acad_start_dt igs_ca_inst.start_dt%type;
2691: l_acad_end_dt igs_ca_inst.end_dt%type;
2692: l_alternate_code igs_ca_inst.alternate_code%type;
2693:
2694:
2695: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 2692: l_alternate_code igs_ca_inst.alternate_code%type;

2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2690: l_acad_start_dt igs_ca_inst.start_dt%type;
2691: l_acad_end_dt igs_ca_inst.end_dt%type;
2692: l_alternate_code igs_ca_inst.alternate_code%type;
2693:
2694:
2695: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2696: SELECT version_number

Line 3630: l_acad_cal_type igs_ca_inst.cal_type%type;

3626: l_enr_cat VARCHAR2(20);
3627: l_enr_comm VARCHAR2(2000);
3628:
3629: l_dummy NUMBER;
3630: l_acad_cal_type igs_ca_inst.cal_type%type;
3631: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
3632: l_acad_start_dt igs_ca_inst.start_dt%type;
3633: l_acad_end_dt igs_ca_inst.end_dt%type;
3634: l_alternate_code igs_ca_inst.alternate_code%type;

Line 3631: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;

3627: l_enr_comm VARCHAR2(2000);
3628:
3629: l_dummy NUMBER;
3630: l_acad_cal_type igs_ca_inst.cal_type%type;
3631: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
3632: l_acad_start_dt igs_ca_inst.start_dt%type;
3633: l_acad_end_dt igs_ca_inst.end_dt%type;
3634: l_alternate_code igs_ca_inst.alternate_code%type;
3635: l_acad_message varchar2(100);

Line 3632: l_acad_start_dt igs_ca_inst.start_dt%type;

3628:
3629: l_dummy NUMBER;
3630: l_acad_cal_type igs_ca_inst.cal_type%type;
3631: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
3632: l_acad_start_dt igs_ca_inst.start_dt%type;
3633: l_acad_end_dt igs_ca_inst.end_dt%type;
3634: l_alternate_code igs_ca_inst.alternate_code%type;
3635: l_acad_message varchar2(100);
3636: l_message VARCHAR2(1200);

Line 3633: l_acad_end_dt igs_ca_inst.end_dt%type;

3629: l_dummy NUMBER;
3630: l_acad_cal_type igs_ca_inst.cal_type%type;
3631: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
3632: l_acad_start_dt igs_ca_inst.start_dt%type;
3633: l_acad_end_dt igs_ca_inst.end_dt%type;
3634: l_alternate_code igs_ca_inst.alternate_code%type;
3635: l_acad_message varchar2(100);
3636: l_message VARCHAR2(1200);
3637: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;

Line 3634: l_alternate_code igs_ca_inst.alternate_code%type;

3630: l_acad_cal_type igs_ca_inst.cal_type%type;
3631: l_acad_ci_sequence_number igs_ca_inst.sequence_number%type;
3632: l_acad_start_dt igs_ca_inst.start_dt%type;
3633: l_acad_end_dt igs_ca_inst.end_dt%type;
3634: l_alternate_code igs_ca_inst.alternate_code%type;
3635: l_acad_message varchar2(100);
3636: l_message VARCHAR2(1200);
3637: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3638: l_return_status VARCHAR2(10);

Line 4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;

4144:
4145: l_enr_method_type igs_en_cpd_ext.enr_method_type%TYPE;
4146: l_cur_per_typ cur_per_typ%ROWTYPE;
4147: lv_person_type igs_pe_person_types.person_type_code%TYPE;
4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;
4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;

Line 4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;

4147: lv_person_type igs_pe_person_types.person_type_code%TYPE;
4148: l_alternate_code igs_ca_inst.alternate_code%TYPE;
4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

Line 4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;

Line 4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;

4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;
4162: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;

Line 4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;

4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;
4162: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4163: l_stud_audit_lim igs_en_cpd_ext.stud_audit_lim%TYPE;