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_TI_COMP dependencies on IGS_AD_APLINS_ADMREQ

Line 560: FROM igs_ad_aplins_admreq aa,

556: p_course_cd IN igs_ad_ps_appl_inst.course_cd%TYPE,
557: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
558: ) IS
559: SELECT aa.tracking_id
560: FROM igs_ad_aplins_admreq aa,
561: igs_tr_item ti,
562: igs_tr_status ts
563: WHERE aa.person_id = p_person_id
564: AND aa.admission_appl_number = p_admission_appl_number

Line 573: p_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE

569: AND ts.s_tracking_status = 'ACTIVE' ; -- the tracking status should be mapped to system tracking status of 'ACTIVE' ( rghosh, bug#2919317)
570:
571: -- Get all the Tracking Steps of Each Tracking Item.
572: CURSOR cur_tr_stp(
573: p_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE
574: ) IS
575: SELECT tracking_step_id, s_tracking_step_type, recipient_id
576: FROM igs_tr_step ts
577: WHERE ts.tracking_id = p_tracking_id

Line 726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,

722: --Check whether there is any tracking associated for the person and Application Number
723: CURSOR cur_trk_exists(
724: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
725: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,
727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS
728: SELECT 1
729: FROM igs_ad_aplins_admreq aa,
730: igs_tr_item ti,

Line 727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS

723: CURSOR cur_trk_exists(
724: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
725: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,
727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS
728: SELECT 1
729: FROM igs_ad_aplins_admreq aa,
730: igs_tr_item ti,
731: igs_tr_status ts

Line 729: FROM igs_ad_aplins_admreq aa,

725: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE ,
726: p_course_cd IN igs_ad_aplins_admreq.course_cd%TYPE ,
727: p_sequence_number IN igs_ad_aplins_admreq.sequence_number%TYPE ) IS
728: SELECT 1
729: FROM igs_ad_aplins_admreq aa,
730: igs_tr_item ti,
731: igs_tr_status ts
732: WHERE aa.person_id = p_person_id
733: AND aa.admission_appl_number = p_admission_appl_number