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_AD_GEN_010 dependencies on IGS_PS_ENT_PT_REF_CD

Line 71: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;

67: BEGIN -- admp_get_tac_ceprc
68: -- This module gets course offering option details from the
69: -- course entry point reference code table.
70: DECLARE
71: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;

Line 72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;

68: -- This module gets course offering option details from the
69: -- course entry point reference code table.
70: DECLARE
71: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;

Line 73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;

69: -- course entry point reference code table.
70: DECLARE
71: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;

Line 74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;

70: DECLARE
71: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
78: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;

Line 75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;

71: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
78: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;
79: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;

Line 76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;

72: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
78: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;
79: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;
80: v_us_version_number IGS_EN_UNIT_SET.version_number%TYPE;

Line 77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;

73: v_cal_type IGS_PS_ENT_PT_REF_CD.cal_type%TYPE;
74: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
75: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
76: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
77: v_coo_id IGS_PS_ENT_PT_REF_CD.coo_id%TYPE;
78: v_ref_cd_type IGS_GE_REF_CD_TYPE.reference_cd_type%TYPE;
79: v_unit_set_cd IGS_EN_UNIT_SET.unit_set_cd%TYPE;
80: v_us_version_number IGS_EN_UNIT_SET.version_number%TYPE;
81: v_message_name varchar2(30);

Line 94: FROM IGS_PS_ENT_PT_REF_CD ceprc,

90: ceprc.coo_id,
91: rct.s_reference_cd_type,
92: ceprc.unit_set_cd,
93: ceprc.us_version_number
94: FROM IGS_PS_ENT_PT_REF_CD ceprc,
95: IGS_GE_REF_CD_TYPE rct,
96: IGS_PS_VER crv,
97: IGS_PS_STAT cs
98: WHERE rct.s_reference_cd_type = 'OTHER' AND

Line 230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;

226: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
227: v_message_name varchar2(30);
228: v_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
229: v_given_names IGS_PE_PERSON.given_names%TYPE;
230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;

Line 231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;

227: v_message_name varchar2(30);
228: v_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
229: v_given_names IGS_PE_PERSON.given_names%TYPE;
230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

Line 232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;

228: v_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
229: v_given_names IGS_PE_PERSON.given_names%TYPE;
230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
236: v_adm_offer_dfrmnt_status

Line 233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;

229: v_given_names IGS_PE_PERSON.given_names%TYPE;
230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
236: v_adm_offer_dfrmnt_status
237: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;

Line 234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;

230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;
233: v_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE;
234: v_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE;
235: v_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
236: v_adm_offer_dfrmnt_status
237: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
238: v_enrol_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

Line 261: FROM IGS_PS_ENT_PT_REF_CD ceprc,

257: ceprc.version_number,
258: ceprc.location_cd,
259: ceprc.attendance_mode,
260: ceprc.attendance_type
261: FROM IGS_PS_ENT_PT_REF_CD ceprc,
262: IGS_GE_REF_CD_TYPE rct,
263: IGS_PS_VER crv,
264: IGS_PS_STAT cs
265: WHERE rct.s_reference_cd_type = 'OTHER' AND

Line 286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,

282: uss.s_unit_set_status = cst_active))
283: ORDER BY rct.s_reference_cd_type DESC;
284: CURSOR c_course_ins_1(
285: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,
288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,
289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,
290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS

Line 287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,

283: ORDER BY rct.s_reference_cd_type DESC;
284: CURSOR c_course_ins_1(
285: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,
288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,
289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,
290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS
291: SELECT aors.s_adm_offer_resp_status,

Line 288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,

284: CURSOR c_course_ins_1(
285: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,
288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,
289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,
290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS
291: SELECT aors.s_adm_offer_resp_status,
292: aods.s_adm_offer_dfrmnt_status

Line 289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,

285: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,
288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,
289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,
290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS
291: SELECT aors.s_adm_offer_resp_status,
292: aods.s_adm_offer_dfrmnt_status
293: FROM igs_ad_appl aa,

Line 290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS

286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,
288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,
289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,
290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS
291: SELECT aors.s_adm_offer_resp_status,
292: aods.s_adm_offer_dfrmnt_status
293: FROM igs_ad_appl aa,
294: igs_ad_ps_appl_inst acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */

Line 320: IGS_PS_ENT_PT_REF_CD ceprc,

316: FROM igs_ad_appl aa,
317: IGS_AD_PS_APPL_INST acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */
318: IGS_AD_OFR_RESP_STAT aors,
319: IGS_AD_OFRDFRMT_STAT aods,
320: IGS_PS_ENT_PT_REF_CD ceprc,
321: IGS_GE_REF_CD_TYPE rct
322: WHERE acaiv.person_id = cp_matched_id AND
323: aa.acad_cal_type = p_acad_cal_type AND
324: aa.acad_ci_sequence_number = p_acad_ci_sequence_number AND

Line 339: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS

335: aa.admission_appl_number = acaiv.admission_appl_number
336: ORDER BY rct.s_reference_cd_type DESC;
337: v_course_ins_rec_2 c_course_ins_2%ROWTYPE;
338: CURSOR c_govt_value(
339: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS
340: SELECT govt_attendance_type
341: FROM IGS_EN_ATD_TYPE
342: WHERE attendance_type = v_attendance_type;
343: CURSOR c_attn_mode(

Line 344: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,

340: SELECT govt_attendance_type
341: FROM IGS_EN_ATD_TYPE
342: WHERE attendance_type = v_attendance_type;
343: CURSOR c_attn_mode(
344: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
345: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
346: SELECT am.govt_attendance_mode
347: FROM IGS_EN_STDNT_PS_ATT sca,
348: IGS_EN_ATD_MODE am