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_GEN_015 dependencies on IGS_PE_PERSON_TYPES

Line 116: l_person_type igs_pe_person_types.person_type_code%TYPE;

112: (
113: p_eligibility_step_type IN VARCHAR2
114: ) RETURN BOOLEAN AS
115:
116: l_person_type igs_pe_person_types.person_type_code%TYPE;
117:
118: CURSOR cur_person_types (cp_person_type igs_pe_person_types.person_type_code%TYPE)IS
119: SELECT system_type
120: FROM igs_pe_person_types

Line 118: CURSOR cur_person_types (cp_person_type igs_pe_person_types.person_type_code%TYPE)IS

114: ) RETURN BOOLEAN AS
115:
116: l_person_type igs_pe_person_types.person_type_code%TYPE;
117:
118: CURSOR cur_person_types (cp_person_type igs_pe_person_types.person_type_code%TYPE)IS
119: SELECT system_type
120: FROM igs_pe_person_types
121: WHERE person_type_code = cp_person_type;
122:

Line 120: FROM igs_pe_person_types

116: l_person_type igs_pe_person_types.person_type_code%TYPE;
117:
118: CURSOR cur_person_types (cp_person_type igs_pe_person_types.person_type_code%TYPE)IS
119: SELECT system_type
120: FROM igs_pe_person_types
121: WHERE person_type_code = cp_person_type;
122:
123: l_cur_person_types cur_person_types%ROWTYPE;
124: l_system_person_type igs_pe_person_types.system_type%TYPE;

Line 124: l_system_person_type igs_pe_person_types.system_type%TYPE;

120: FROM igs_pe_person_types
121: WHERE person_type_code = cp_person_type;
122:
123: l_cur_person_types cur_person_types%ROWTYPE;
124: l_system_person_type igs_pe_person_types.system_type%TYPE;
125:
126: CURSOR c_step_overridden (cp_validation igs_pe_usr_aval.validation%TYPE,
127: cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
128: SELECT override_ind

Line 127: cp_person_type igs_pe_person_types.person_type_code%TYPE) IS

123: l_cur_person_types cur_person_types%ROWTYPE;
124: l_system_person_type igs_pe_person_types.system_type%TYPE;
125:
126: CURSOR c_step_overridden (cp_validation igs_pe_usr_aval.validation%TYPE,
127: cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
128: SELECT override_ind
129: FROM igs_pe_usr_aval
130: WHERE validation = cp_validation
131: AND override_ind = 'Y'

Line 782: l_person_type igs_pe_person_types.person_type_code%TYPE;

778: l_acad_start_dt igs_ca_inst.start_dt%TYPE;
779: l_acad_end_dt igs_ca_inst.end_dt%TYPE;
780: l_alternate_code igs_ca_inst.alternate_code%TYPE;
781: l_message VARCHAR2(100);
782: l_person_type igs_pe_person_types.person_type_code%TYPE;
783: l_notification_flag VARCHAR2(10);
784: l_ret_status VARCHAR2(10);
785:
786: l_cross_listed_row c_cross_listed%ROWTYPE;

Line 2012: FROM igs_pe_person_types

2008: AND transaction_type <> 'WITHDRAWN';
2009:
2010: CURSOR cur_sys_pers_type IS
2011: SELECT system_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 ,

Line 2039: l_system_type igs_pe_person_types.system_type%TYPE;

2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2042: lv_message fnd_new_messages.message_name%TYPE;
2043: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

Line 2315: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS

2311: AND REQUEST_TYPE = 'AUDIT_PERM'
2312: AND transaction_type <> 'WITHDRAWN';
2313:
2314:
2315: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
2316: SELECT system_type
2317: FROM igs_pe_person_types
2318: WHERE person_type_code = cp_person_type;
2319:

Line 2317: FROM igs_pe_person_types

2313:
2314:
2315: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
2316: SELECT system_type
2317: FROM igs_pe_person_types
2318: WHERE person_type_code = cp_person_type;
2319:
2320:
2321: CURSOR c_stud_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,

Line 2342: cp_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE,

2338: (eru.s_student_comm_type = cp_commencement_type OR eru.s_student_comm_type = 'ALL')
2339: ORDER BY eru.step_order_num;
2340:
2341: CURSOR c_staff_step_def(cp_step IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE,
2342: cp_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE,
2343: cp_enrollment_Category IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE,
2344: cp_enr_method IGS_EN_CAT_PRC_DTL.ENR_METHOD_TYPE%TYPE,
2345: cp_commencement_type IGS_EN_CAT_PRC_DTL.S_STUDENT_COMM_TYPE%TYPE
2346: ) IS

Line 2370: v_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE;

2366: v_ap_allowed igs_ps_unit_ofr_opt.AUDITABLE_IND%TYPE;
2367: v_ap_required igs_ps_unit_ofr_opt.AUDIT_PERMISSION_IND%TYPE;
2368: v_staff_step_def_rec c_staff_step_def%ROWTYPE;
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:

Line 2566: l_person_type igs_pe_person_types.person_type_code%TYPE;

2562: AND course_cd = cp_course_cd
2563: AND uoo_id = cp_uoo_id;
2564:
2565: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
2566: l_person_type igs_pe_person_types.person_type_code%TYPE;
2567: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
2568: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
2569: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
2570: l_acad_cal_type igs_ca_inst.cal_type%TYPE;