DBA Data[Home] [Help]

APPS.IGS_AD_GEN_002 dependencies on IGS_AD_PS_APLINSTHST

Line 4222: FROM IGS_AD_PS_APLINSTHST ahist

4218: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
4219: cp_old_update_on DATE)
4220: IS
4221: SELECT 'x'
4222: FROM IGS_AD_PS_APLINSTHST ahist
4223: WHERE person_id = cp_person_id
4224: AND admission_appl_number = cp_admission_appl_number
4225: AND nominated_course_cd = cp_nominated_course_cd
4226: AND sequence_number = cp_sequence_number

Line 4240: hist_rec IGS_AD_PS_APLINSTHST%ROWTYPE;

4236: admission_appl_number = cp_admission_appl_number and
4237: nominated_course_cd = cp_nominated_course_cd;
4238:
4239:
4240: hist_rec IGS_AD_PS_APLINSTHST%ROWTYPE;
4241:
4242: l_dummy VARCHAR2(1);
4243: lv_rowid VARCHAR2(25);
4244:

Line 4438: IGS_AD_PS_APLINSTHST_Pkg.Insert_Row (

4434: END IF;
4435:
4436: -- call History TBH
4437: lv_rowid := NULL;
4438: IGS_AD_PS_APLINSTHST_Pkg.Insert_Row (
4439: X_Mode => 'R',
4440: X_RowId => lv_rowid,
4441: X_Person_Id => hist_rec.person_id,
4442: X_Admission_Appl_Number => hist_rec.admission_appl_number,