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_CANCEL_RECONSIDER dependencies on IGS_AD_PS_APLINSTHST_ALL

Line 329: CURSOR c_get_aplinsthist_dtls(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,

325: l_get_inst_dtls_rec c_get_inst_dtls%ROWTYPE;
326:
327: l_get_application_id igs_ad_appl_all.application_id%TYPE;
328:
329: CURSOR c_get_aplinsthist_dtls(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
332: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
333: SELECT hist.*

Line 330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,

326:
327: l_get_application_id igs_ad_appl_all.application_id%TYPE;
328:
329: CURSOR c_get_aplinsthist_dtls(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
332: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
333: SELECT hist.*
334: FROM igs_ad_ps_aplinsthst_all hist

Line 331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,

327: l_get_application_id igs_ad_appl_all.application_id%TYPE;
328:
329: CURSOR c_get_aplinsthist_dtls(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
332: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
333: SELECT hist.*
334: FROM igs_ad_ps_aplinsthst_all hist
335: WHERE person_id = cp_person_id

Line 332: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS

328:
329: CURSOR c_get_aplinsthist_dtls(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
332: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
333: SELECT hist.*
334: FROM igs_ad_ps_aplinsthst_all hist
335: WHERE person_id = cp_person_id
336: AND admission_appl_number = cp_admission_appl_number

Line 334: FROM igs_ad_ps_aplinsthst_all hist

330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
332: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
333: SELECT hist.*
334: FROM igs_ad_ps_aplinsthst_all hist
335: WHERE person_id = cp_person_id
336: AND admission_appl_number = cp_admission_appl_number
337: AND nominated_course_cd = cp_nominated_course_cd
338: AND sequence_number = cp_sequence_number;

Line 342: CURSOR c_get_hist_dt (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,

338: AND sequence_number = cp_sequence_number;
339:
340: l_get_aplinsthist_dtls_rec c_get_aplinsthist_dtls%ROWTYPE;
341:
342: CURSOR c_get_hist_dt (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
343: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
344: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
345: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
346: SELECT MAX(hist_start_dt) latest_record

Line 343: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,

339:
340: l_get_aplinsthist_dtls_rec c_get_aplinsthist_dtls%ROWTYPE;
341:
342: CURSOR c_get_hist_dt (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
343: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
344: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
345: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
346: SELECT MAX(hist_start_dt) latest_record
347: FROM igs_ad_ps_aplinsthst_all

Line 344: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,

340: l_get_aplinsthist_dtls_rec c_get_aplinsthist_dtls%ROWTYPE;
341:
342: CURSOR c_get_hist_dt (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
343: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
344: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
345: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
346: SELECT MAX(hist_start_dt) latest_record
347: FROM igs_ad_ps_aplinsthst_all
348: WHERE person_id = cp_person_id

Line 345: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS

341:
342: CURSOR c_get_hist_dt (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
343: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
344: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
345: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
346: SELECT MAX(hist_start_dt) latest_record
347: FROM igs_ad_ps_aplinsthst_all
348: WHERE person_id = cp_person_id
349: AND admission_appl_number = cp_admission_appl_number

Line 347: FROM igs_ad_ps_aplinsthst_all

343: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
344: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
345: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE) IS
346: SELECT MAX(hist_start_dt) latest_record
347: FROM igs_ad_ps_aplinsthst_all
348: WHERE person_id = cp_person_id
349: AND admission_appl_number = cp_admission_appl_number
350: AND nominated_course_cd = cp_nominated_course_cd
351: AND sequence_number = cp_sequence_number

Line 356: CURSOR c_get_pending_hist (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,

352: AND NVL(reconsider_flag,'N') = 'N';
353:
354: l_get_hist_dt DATE;
355:
356: CURSOR c_get_pending_hist (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
357: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,
360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS

Line 357: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,

353:
354: l_get_hist_dt DATE;
355:
356: CURSOR c_get_pending_hist (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
357: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,
360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS
361: SELECT hist.*

Line 358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,

354: l_get_hist_dt DATE;
355:
356: CURSOR c_get_pending_hist (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
357: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,
360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS
361: SELECT hist.*
362: FROM igs_ad_ps_aplinsthst_all hist

Line 359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,

355:
356: CURSOR c_get_pending_hist (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
357: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,
360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS
361: SELECT hist.*
362: FROM igs_ad_ps_aplinsthst_all hist
363: WHERE person_id = cp_person_id

Line 360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS

356: CURSOR c_get_pending_hist (cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
357: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,
360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS
361: SELECT hist.*
362: FROM igs_ad_ps_aplinsthst_all hist
363: WHERE person_id = cp_person_id
364: AND admission_appl_number = cp_admission_appl_number

Line 362: FROM igs_ad_ps_aplinsthst_all hist

358: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,
359: cp_sequence_number igs_ad_ps_aplinsthst_all.sequence_number%TYPE,
360: cp_hist_start_dt igs_ad_ps_aplinsthst_all.hist_start_dt%TYPE) IS
361: SELECT hist.*
362: FROM igs_ad_ps_aplinsthst_all hist
363: WHERE person_id = cp_person_id
364: AND admission_appl_number = cp_admission_appl_number
365: AND nominated_course_cd = cp_nominated_course_cd
366: AND sequence_number = cp_sequence_number

Line 389: CURSOR c_adm_cat(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,

385: AND step_group_type <> 'TRACK';
386:
387: l_apcs VARCHAR2(1);
388:
389: CURSOR c_adm_cat(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
390: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE) IS
391: SELECT admission_cat,s_admission_process_type
392: FROM igs_ad_appl_all
393: WHERE person_id = cp_person_id

Line 390: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE) IS

386:
387: l_apcs VARCHAR2(1);
388:
389: CURSOR c_adm_cat(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
390: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE) IS
391: SELECT admission_cat,s_admission_process_type
392: FROM igs_ad_appl_all
393: WHERE person_id = cp_person_id
394: AND admission_appl_number = cp_admission_appl_number;