APPS.IGS_AD_GEN_010 dependencies on IGS_AD_PS_APPL_INST

Line 294: igs_ad_ps_appl_inst acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */

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 */
295: igs_ad_ofr_resp_stat aors,
296: igs_ad_ofrdfrmt_stat aods
297: WHERE acaiv.person_id = cp_matched_id AND
298: aa.acad_cal_type = p_acad_cal_type AND

Line 317: IGS_AD_PS_APPL_INST acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */

313: aods.s_adm_offer_dfrmnt_status,
314: acaiv.course_cd,
315: ceprc.reference_cd
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

Line 424: -- Find the IGS_AD_PS_APPL_INST.

420: p_message_name := v_message_name;
421: RETURN FALSE;
422: END IF;
423: END IF;
424: -- Find the IGS_AD_PS_APPL_INST.
425: v_course_ins_found := FALSE;
426: FOR v_course_ins_rec_1 IN c_course_ins_1(
427: v_matched_id,
428: v_course_cd,

Line 444: -- No IGS_AD_PS_APPL_INST records found.

440: v_adm_offer_dfrmnt_status := v_course_ins_rec_1.s_adm_offer_dfrmnt_status;
441: END LOOP;
442: IF (v_course_ins_found = FALSE) THEN
443: IF (v_message_name IS NULL) THEN
444: -- No IGS_AD_PS_APPL_INST records found.
445: p_message_name := 'IGS_AD_CANNOT_FIND_ADMPRGAPPL';
446: RETURN FALSE;
447: ELSE
448: -- More than one adm_course_appl_instanc recores found.

Line 454: -- Find the IGS_AD_PS_APPL_INST

450: RETURN FALSE;
451: END IF;
452: END IF;
453: ELSE -- No TAC IGS_PS_COURSE code supplied
454: -- Find the IGS_AD_PS_APPL_INST
455: OPEN c_course_ins_2(
456: v_matched_id);
457: FETCH c_course_ins_2 INTO v_course_ins_rec_2;
458: IF (c_course_ins_2%NOTFOUND) THEN

Line 560: -- This module retrieves IGS_PS_UNIT details from IGS_AD_PS_APPL_INST

556: p_record_number IN NUMBER )
557: RETURN VARCHAR2 IS
558: gv_other_detail VARCHAR2(255);
559: BEGIN -- admp_get_unit_det
560: -- This module retrieves IGS_PS_UNIT details from IGS_AD_PS_APPL_INST
561: -- for use on letters.
562: DECLARE
563: v_out_string VARCHAR2(200) DEFAULT NULL;
564: v_comm_period VARCHAR2(21) DEFAULT NULL;