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.

[Home] [Help]

APPS.IGS_EN_GEN_015 dependencies on IGS_EN_CPD_EXT

Line 2016: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,

2012: FROM igs_pe_person_types
2013: WHERE person_type_code = p_person_type;
2014:
2015: TYPE step_rec IS RECORD(
2016: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,
2017: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,
2018: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
2019: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,
2020: step_group_type igs_lookups_view.step_group_type%TYPE);

Line 2017: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,

2013: WHERE person_type_code = p_person_type;
2014:
2015: TYPE step_rec IS RECORD(
2016: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,
2017: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,
2018: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
2019: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,
2020: step_group_type igs_lookups_view.step_group_type%TYPE);
2021:

Line 2018: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,

2014:
2015: TYPE step_rec IS RECORD(
2016: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,
2017: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,
2018: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
2019: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,
2020: step_group_type igs_lookups_view.step_group_type%TYPE);
2021:
2022: TYPE cur_step_def IS REF CURSOR;

Line 2019: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,

2015: TYPE step_rec IS RECORD(
2016: s_enrolment_step_type igs_en_cpd_ext.s_enrolment_step_type%TYPE ,
2017: enrolment_cat igs_en_cpd_ext.enrolment_cat%TYPE,
2018: s_student_comm_type igs_en_cpd_ext.s_student_comm_type%TYPE,
2019: enr_method_type igs_en_cpd_ext.enr_method_type%TYPE,
2020: step_group_type igs_lookups_view.step_group_type%TYPE);
2021:
2022: TYPE cur_step_def IS REF CURSOR;
2023:

Line 2046: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
2044: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
2045: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2046: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
2047: l_message VARCHAR2(2000);
2048: l_return_status VARCHAR2(10);
2049: l_dummy VARCHAR2(200);
2050: PROCEDURE l_call_audit_proc AS

Line 2158: FROM igs_en_cpd_ext eru, igs_lookups_view lkv

2154:
2155: -- if the user log on is a student
2156: IF l_system_type = 'STUDENT' THEN
2157: l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type
2158: FROM igs_en_cpd_ext eru, igs_lookups_view lkv
2159: WHERE eru.s_enrolment_step_type = ''SPL_PERM'' AND
2160: eru.s_enrolment_step_type =lkv.lookup_code AND
2161: lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type =
2162: ''UNIT'' AND eru.enrolment_cat = :1 AND eru.enr_method_type = :2

Line 2172: FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv

2168: --IF l_system_type = 'SS_ENROLL_STAFF' THEN -- if the log on user is self service enrollment staff
2169: -- removed the check so as to prepare the query for person type other than STUDENT and SS_ENROLL_STAFF also
2170:
2171: l_step_def_query := 'SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type
2172: FROM igs_en_cpd_ext eru, igs_pe_usr_aval_all uact, igs_lookups_view lkv
2173: WHERE eru.s_enrolment_step_type = ''SPL_PERM'' AND
2174: eru.s_enrolment_step_type =lkv.lookup_code AND
2175: lkv.lookup_type = ''ENROLMENT_STEP_TYPE_EXT'' AND lkv.step_group_type = ''UNIT'' AND
2176: eru.s_enrolment_step_type = uact.validation(+) AND

Line 2329: igs_en_cpd_ext eru,

2325: ) IS
2326: SELECT
2327: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
2328: FROM
2329: igs_en_cpd_ext eru,
2330: igs_lookups_view lkv
2331: WHERE
2332: eru.s_enrolment_step_type = cp_step AND
2333: eru.s_enrolment_step_type =lkv.lookup_code AND

Line 2350: igs_en_cpd_ext eru,

2346: ) IS
2347: SELECT
2348: eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkv.step_group_type --modified by nishikant
2349: FROM
2350: igs_en_cpd_ext eru,
2351: igs_pe_usr_aval_all uact,
2352: igs_lookups_view lkv
2353: WHERE
2354: eru.s_enrolment_step_type = cp_step AND

Line 2373: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;

2369: v_stud_step_def_rec c_stud_step_def%ROWTYPE;
2370: v_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE;
2371: v_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
2372: v_audit_perm_rec c_audit_perm_exists%ROWTYPE;
2373: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
2374:
2375: BEGIN
2376: p_message_name := NULL;
2377: -- check whether Audit special permission functionality is allowed for the given unit section