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_004 dependencies on IGS_AD_PS_APPL_INST

Line 219: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL Bug: 3150054

215: aa.acad_cal_type,
216: acaiv.location_cd,
217: acaiv.attendance_mode,
218: acaiv.attendance_type
219: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL Bug: 3150054
220: igs_ad_appl aa
221: WHERE acaiv.admission_appl_number = aa.admission_appl_number AND
222: acaiv.person_id = aa.person_id AND
223: acaiv.person_id = p_person_id AND

Line 279: v_commencement_period IGS_AD_PS_APPL_INST_APLSUMR_V.commencement_period%TYPE;

275: RETURN VARCHAR2 IS
276: BEGIN -- admp_get_comm_perd
277: -- This module retrieves the commencement period
278: DECLARE
279: v_commencement_period IGS_AD_PS_APPL_INST_APLSUMR_V.commencement_period%TYPE;
280: CURSOR c_aasv IS --modified the cursor to use base tables instead of IGS_AD_PS_APPL_INST_APLSUMR_V. Bug: 3150054
281: SELECT SUBSTR(IGS_AD_GEN_002.admp_get_acai_acadcd(
282: aav.person_id,
283: aav.admission_appl_number,

Line 280: CURSOR c_aasv IS --modified the cursor to use base tables instead of IGS_AD_PS_APPL_INST_APLSUMR_V. Bug: 3150054

276: BEGIN -- admp_get_comm_perd
277: -- This module retrieves the commencement period
278: DECLARE
279: v_commencement_period IGS_AD_PS_APPL_INST_APLSUMR_V.commencement_period%TYPE;
280: CURSOR c_aasv IS --modified the cursor to use base tables instead of IGS_AD_PS_APPL_INST_APLSUMR_V. Bug: 3150054
281: SELECT SUBSTR(IGS_AD_GEN_002.admp_get_acai_acadcd(
282: aav.person_id,
283: aav.admission_appl_number,
284: aav.acad_cal_type,

Line 287: FROM igs_ad_ps_appl_inst acai,

283: aav.admission_appl_number,
284: aav.acad_cal_type,
285: NVL(acai.adm_cal_type, aav.adm_cal_type),
286: NVL(acai.adm_ci_sequence_number, aav.adm_ci_sequence_number)),1,10) || '/' || ci.alternate_code commencement_period
287: FROM igs_ad_ps_appl_inst acai,
288: igs_ad_appl aav,
289: igs_ca_inst ci
290: WHERE aav.person_id = acai.person_id AND
291: aav.admission_appl_number = acai.admission_appl_number AND

Line 330: -- This module retrieves course details from IGS_AD_PS_APPL_INST

326: p_record_number IN NUMBER ,
327: p_extra_context OUT NOCOPY VARCHAR2 )
328: RETURN VARCHAR2 IS
329: BEGIN -- admp_get_course_det
330: -- This module retrieves course details from IGS_AD_PS_APPL_INST
331: -- for use on letters.
332: DECLARE
333: v_out_string VARCHAR2(106) DEFAULT NULL;
334: v_alt_acad_cal IGS_CA_INST.alternate_code%TYPE;

Line 347: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054

343: aav.acad_cal_type,
344: aav.acad_ci_sequence_number,
345: acaiv.sequence_number,
346: ci1.alternate_code || '/' || ci2.alternate_code commencement_period
347: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054
348: igs_ad_appl aav,
349: igs_ca_inst ci1,
350: igs_ca_inst ci2,
351: igs_ps_ver cv

Line 422: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;

418: p_acai_sequence_number IN NUMBER )
419: RETURN VARCHAR2 IS
420: BEGIN
421: DECLARE
422: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;
423: v_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE;
424: v_reference_cd IGS_PS_REF_CD.reference_cd%TYPE;
425: CURSOR c_acai IS
426: SELECT acai.course_cd,

Line 423: v_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE;

419: RETURN VARCHAR2 IS
420: BEGIN
421: DECLARE
422: v_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE;
423: v_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE;
424: v_reference_cd IGS_PS_REF_CD.reference_cd%TYPE;
425: CURSOR c_acai IS
426: SELECT acai.course_cd,
427: acai.crv_version_number

Line 428: FROM IGS_AD_PS_APPL_INST acai

424: v_reference_cd IGS_PS_REF_CD.reference_cd%TYPE;
425: CURSOR c_acai IS
426: SELECT acai.course_cd,
427: acai.crv_version_number
428: FROM IGS_AD_PS_APPL_INST acai
429: WHERE acai.person_id = p_person_id AND
430: acai.admission_appl_number = p_admission_appl_number AND
431: acai.nominated_course_cd = p_nominated_course_cd AND
432: acai.sequence_number = p_acai_sequence_number;

Line 434: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,

430: acai.admission_appl_number = p_admission_appl_number AND
431: acai.nominated_course_cd = p_nominated_course_cd AND
432: acai.sequence_number = p_acai_sequence_number;
433: CURSOR c_crc_rct (
434: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
435: cp_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE) IS
436: SELECT crc.reference_cd
437: FROM IGS_PS_REF_CD crc,
438: IGS_GE_REF_CD_TYPE rct

Line 435: cp_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE) IS

431: acai.nominated_course_cd = p_nominated_course_cd AND
432: acai.sequence_number = p_acai_sequence_number;
433: CURSOR c_crc_rct (
434: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
435: cp_crv_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE) IS
436: SELECT crc.reference_cd
437: FROM IGS_PS_REF_CD crc,
438: IGS_GE_REF_CD_TYPE rct
439: WHERE rct.s_reference_cd_type = 'OTHER' AND

Line 529: v_out_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;

525: v_check VARCHAR2(1);
526: v_message_name VARCHAR2(30) default null;
527: v_out_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE;
528: v_out_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE;
529: v_out_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
530: v_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE;
531: v_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE;
532: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
533: v_parent VARCHAR2(5);

Line 532: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;

528: v_out_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE;
529: v_out_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
530: v_admission_appl_number IGS_AD_PS_APPL.admission_appl_number%TYPE;
531: v_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE;
532: v_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE;
533: v_parent VARCHAR2(5);
534: BEGIN -- Initialise output parameters
535: p_referee_exists := FALSE;
536: p_scholarship_exists := FALSE;