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_EN_ELGBL_PROGRAM dependencies on IGS_EN_CPD_EXT

Line 37: g_enrollment_category igs_en_cpd_ext.enrolment_cat%TYPE;

33: Who When What
34: ******************************************************************/
35: -- Declare global variables
36: g_person_type igs_pe_usr_arg.person_type%TYPE;
37: g_enrollment_category igs_en_cpd_ext.enrolment_cat%TYPE;
38: g_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE;
39: g_method_type igs_en_cpd_ext.enr_method_type%TYPE;
40: g_system_person_type igs_pe_person_types.system_type%TYPE;
41:

Line 38: g_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE;

34: ******************************************************************/
35: -- Declare global variables
36: g_person_type igs_pe_usr_arg.person_type%TYPE;
37: g_enrollment_category igs_en_cpd_ext.enrolment_cat%TYPE;
38: g_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE;
39: g_method_type igs_en_cpd_ext.enr_method_type%TYPE;
40: g_system_person_type igs_pe_person_types.system_type%TYPE;
41:
42: FUNCTION eval_program_steps( p_person_id NUMBER,

Line 39: g_method_type igs_en_cpd_ext.enr_method_type%TYPE;

35: -- Declare global variables
36: g_person_type igs_pe_usr_arg.person_type%TYPE;
37: g_enrollment_category igs_en_cpd_ext.enrolment_cat%TYPE;
38: g_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE;
39: g_method_type igs_en_cpd_ext.enr_method_type%TYPE;
40: g_system_person_type igs_pe_person_types.system_type%TYPE;
41:
42: FUNCTION eval_program_steps( p_person_id NUMBER,
43: p_person_type VARCHAR2,

Line 75: TYPE l_program_steps_rec IS RECORD ( s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE,

71: ******************************************************************/
72:
73: -- Ref Cursor is used since the select statement is dependent on the type of the person parameter passed to the function
74: -- Record Type is defined so that the cursor Return Type is of this Record Type
75: TYPE l_program_steps_rec IS RECORD ( s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE,
76: notification_flag igs_en_cpd_ext.notification_flag%TYPE,
77: s_rule_call_cd igs_en_cpd_ext.s_rule_call_cd%TYPE,
78: rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE
79: );

Line 76: notification_flag igs_en_cpd_ext.notification_flag%TYPE,

72:
73: -- Ref Cursor is used since the select statement is dependent on the type of the person parameter passed to the function
74: -- Record Type is defined so that the cursor Return Type is of this Record Type
75: TYPE l_program_steps_rec IS RECORD ( s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE,
76: notification_flag igs_en_cpd_ext.notification_flag%TYPE,
77: s_rule_call_cd igs_en_cpd_ext.s_rule_call_cd%TYPE,
78: rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE
79: );
80: TYPE cur_ref_program_steps IS REF CURSOR RETURN l_program_steps_rec;

Line 77: s_rule_call_cd igs_en_cpd_ext.s_rule_call_cd%TYPE,

73: -- Ref Cursor is used since the select statement is dependent on the type of the person parameter passed to the function
74: -- Record Type is defined so that the cursor Return Type is of this Record Type
75: TYPE l_program_steps_rec IS RECORD ( s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE,
76: notification_flag igs_en_cpd_ext.notification_flag%TYPE,
77: s_rule_call_cd igs_en_cpd_ext.s_rule_call_cd%TYPE,
78: rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE
79: );
80: TYPE cur_ref_program_steps IS REF CURSOR RETURN l_program_steps_rec;
81: cur_program_steps cur_ref_program_steps;

Line 78: rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE

74: -- Record Type is defined so that the cursor Return Type is of this Record Type
75: TYPE l_program_steps_rec IS RECORD ( s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE,
76: notification_flag igs_en_cpd_ext.notification_flag%TYPE,
77: s_rule_call_cd igs_en_cpd_ext.s_rule_call_cd%TYPE,
78: rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE
79: );
80: TYPE cur_ref_program_steps IS REF CURSOR RETURN l_program_steps_rec;
81: cur_program_steps cur_ref_program_steps;
82: l_cur_program_steps cur_program_steps%ROWTYPE;

Line 93: l_cur_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

89: WHERE person_type_code = p_person_type;
90:
91: -- cursor rowtype variable
92: l_cur_person_types cur_person_types%ROWTYPE;
93: l_cur_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
94:
95: -- variables
96: l_deny_warn l_cur_program_steps.notification_flag%TYPE;
97: l_return_val BOOLEAN;

Line 129: FROM igs_en_cpd_ext eru,

125: OPEN cur_program_steps FOR SELECT eru.s_enrolment_step_type,
126: eru.notification_flag notification_flag,
127: eru.s_rule_call_cd,
128: eru.rul_sequence_number
129: FROM igs_en_cpd_ext eru,
130: igs_lookups_view lkup
131: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
132: eru.enrolment_cat = p_enrollment_category AND
133: (eru.s_student_comm_type = p_comm_type OR

Line 144: FROM igs_en_cpd_ext eru,

140: OPEN cur_program_steps FOR SELECT eru.s_enrolment_step_type,
141: DECODE(uact.deny_warn,'WARN','WARN',eru.notification_flag) notification_flag,
142: eru.s_rule_call_cd,
143: eru.rul_sequence_number
144: FROM igs_en_cpd_ext eru,
145: igs_pe_usr_aval_all uact,
146: igs_lookups_view lkup
147: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
148: eru.enrolment_cat = p_enrollment_category AND

Line 544: TYPE l_program_steps_rec IS RECORD (rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE);

540: ******************************************************************/
541:
542: -- Ref Cursor is used since the select statement is dependent on the type of the person parameter passed to the function
543: -- Record Type is defined so that the cursor Return Type is of this Record Type
544: TYPE l_program_steps_rec IS RECORD (rul_sequence_number igs_en_cpd_ext.rul_sequence_number%TYPE);
545: TYPE cur_ref_program_steps IS REF CURSOR RETURN l_program_steps_rec; -- Defining the Ref Cursor
546: cur_program_steps cur_ref_program_steps;
547: l_cur_program_steps cur_program_steps%ROWTYPE; -- cursor Row Type variable
548:

Line 745: FROM igs_en_cpd_ext eru,

741: END IF;
742:
743: IF g_system_person_type = 'STUDENT' THEN
744: OPEN cur_program_steps FOR SELECT eru.rul_sequence_number rul_sequence_number
745: FROM igs_en_cpd_ext eru,
746: igs_lookups_view lkup
747: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
748: eru.s_enrolment_step_type = 'UNIT_EXCL' AND
749: eru.enrolment_cat = g_enrollment_category AND

Line 758: FROM igs_en_cpd_ext eru,

754: lkup.step_group_type = 'PROGRAM'
755: ORDER BY eru.step_order_num;
756: ELSE
757: OPEN cur_program_steps FOR SELECT eru.rul_sequence_number rul_sequence_number
758: FROM igs_en_cpd_ext eru,
759: igs_pe_usr_aval_all uact,
760: igs_lookups_view lkup
761: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
762: lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND

Line 966: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe

962: WHERE uoo_id = p_uoo_id;
963:
964: CURSOR cur_min_cp_config IS
965: SELECT ecpd.config_min_cp_valdn, ecpd.enforce_date_alias
966: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe
967: WHERE ecpe.s_enrolment_step_type IN ( 'FATD_TYPE' , 'FMIN_CRDT' ) AND
968: ecpe.enrolment_cat = p_enrollment_category AND
969: ecpe.enr_method_type = p_method_type AND
970: (ecpe.s_student_comm_type = p_comm_type

Line 1025: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;

1021: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1022: l_dummy NUMBER;
1023: l_unit_incurred_cp NUMBER;
1024: -- Below local variable added as part of Enrl Elgbl and Validation Build. Bug#2616692
1025: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;
1026: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
1027: --dummy variable to pick up audit, billing, enrolled credit points
1028: --due to signature change by EN308 Billing credit hours Bug 3782329
1029: l_audit_cp IGS_PS_USEC_CPS.billing_credit_points%TYPE;

Line 1346: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe

1342:
1343: -- Below cursor added as part of Enrl Elgbl and Validation Build. Bug#2616692
1344: CURSOR cur_min_cp_config IS
1345: SELECT ecpd.config_min_cp_valdn, ecpd.enforce_date_alias
1346: FROM igs_en_cat_prc_dtl ecpd, igs_en_cpd_ext ecpe
1347: WHERE ecpe.s_enrolment_step_type IN ( 'FATD_TYPE' , 'FMIN_CRDT' ) AND
1348: ecpe.enrolment_cat = p_enrollment_category AND
1349: ecpe.enr_method_type = p_method_type AND
1350: (ecpe.s_student_comm_type = p_comm_type

Line 1613: FROM igs_en_cpd_ext

1609: CURSOR c_chk_min_cp_valdn( p_enrl_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE,
1610: p_enr_meth_type igs_en_method_type.enr_method_type%TYPE,
1611: p_s_stdnt_comm_type VARCHAR2) IS
1612: SELECT notification_flag
1613: FROM igs_en_cpd_ext
1614: WHERE enrolment_cat = p_enrl_cat
1615: AND enr_method_type = p_enr_meth_type
1616: AND s_enrolment_step_type = 'FMIN_CRDT'
1617: AND (s_student_comm_type = p_s_stdnt_comm_type OR

Line 1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1638: l_message fnd_new_messages.message_name%TYPE;
1639: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1640: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;
1641: l_ret_value BOOLEAN;