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_TRANSFER_APIS dependencies on IGS_AD_PS_APPL

Line 3119: CURSOR c_act ( cp_person_id IN IGS_AD_PS_APPL.person_id%TYPE,

3115:
3116:
3117: -- smaddali added the following cursors for bug#4085979
3118: -- Fetch the relevant admissions course transfer record.
3119: CURSOR c_act ( cp_person_id IN IGS_AD_PS_APPL.person_id%TYPE,
3120: cp_course_cd IN IGS_AD_PS_APPL.nominated_course_cd%TYPE,
3121: cp_transfer_course_cd IN IGS_AD_PS_APPL.transfer_course_cd%TYPE) IS
3122: SELECT transfer_course_cd
3123: FROM IGS_AD_PS_APPL

Line 3120: cp_course_cd IN IGS_AD_PS_APPL.nominated_course_cd%TYPE,

3116:
3117: -- smaddali added the following cursors for bug#4085979
3118: -- Fetch the relevant admissions course transfer record.
3119: CURSOR c_act ( cp_person_id IN IGS_AD_PS_APPL.person_id%TYPE,
3120: cp_course_cd IN IGS_AD_PS_APPL.nominated_course_cd%TYPE,
3121: cp_transfer_course_cd IN IGS_AD_PS_APPL.transfer_course_cd%TYPE) IS
3122: SELECT transfer_course_cd
3123: FROM IGS_AD_PS_APPL
3124: WHERE person_id = cp_person_id

Line 3121: cp_transfer_course_cd IN IGS_AD_PS_APPL.transfer_course_cd%TYPE) IS

3117: -- smaddali added the following cursors for bug#4085979
3118: -- Fetch the relevant admissions course transfer record.
3119: CURSOR c_act ( cp_person_id IN IGS_AD_PS_APPL.person_id%TYPE,
3120: cp_course_cd IN IGS_AD_PS_APPL.nominated_course_cd%TYPE,
3121: cp_transfer_course_cd IN IGS_AD_PS_APPL.transfer_course_cd%TYPE) IS
3122: SELECT transfer_course_cd
3123: FROM IGS_AD_PS_APPL
3124: WHERE person_id = cp_person_id
3125: AND nominated_course_cd = cp_course_cd

Line 3123: FROM IGS_AD_PS_APPL

3119: CURSOR c_act ( cp_person_id IN IGS_AD_PS_APPL.person_id%TYPE,
3120: cp_course_cd IN IGS_AD_PS_APPL.nominated_course_cd%TYPE,
3121: cp_transfer_course_cd IN IGS_AD_PS_APPL.transfer_course_cd%TYPE) IS
3122: SELECT transfer_course_cd
3123: FROM IGS_AD_PS_APPL
3124: WHERE person_id = cp_person_id
3125: AND nominated_course_cd = cp_course_cd
3126: AND transfer_course_cd = cp_transfer_course_cd;
3127:

Line 3140: l_adm_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;

3136: AND transfer_course_cd = c_transfer_course_cd
3137: AND status_flag <> 'C';
3138: l_trans_exists_rec c_trans_exists%ROWTYPE;
3139:
3140: l_adm_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
3141: l_adm_transfer BOOLEAN;
3142: l_key_program IGS_EN_SPA_TERMS.key_program_flag%TYPE;
3143: BEGIN
3144: SAVEPOINT TRANSFER_PRGM;