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_CO_PROCESS dependencies on IGS_AD_PANEL_DTLS

Line 884: p_person_id igs_ad_panel_dtls.person_id%TYPE,

880: FROM DUAL;
881:
882: --Cursor to get the reply date
883: CURSOR c_intr_reply_date (
884: p_person_id igs_ad_panel_dtls.person_id%TYPE,
885: p_adm_appl_number igs_ad_panel_dtls.admission_appl_number%TYPE,
886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,
887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS

Line 885: p_adm_appl_number igs_ad_panel_dtls.admission_appl_number%TYPE,

881:
882: --Cursor to get the reply date
883: CURSOR c_intr_reply_date (
884: p_person_id igs_ad_panel_dtls.person_id%TYPE,
885: p_adm_appl_number igs_ad_panel_dtls.admission_appl_number%TYPE,
886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,
887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS
889: SELECT NVL(MAX(ipl.INTERVIEW_DATE),MAX(ipm.INTERVIEW_DATE)) - NVL(TO_NUMBER(p_reply_days),0)

Line 886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,

882: --Cursor to get the reply date
883: CURSOR c_intr_reply_date (
884: p_person_id igs_ad_panel_dtls.person_id%TYPE,
885: p_adm_appl_number igs_ad_panel_dtls.admission_appl_number%TYPE,
886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,
887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS
889: SELECT NVL(MAX(ipl.INTERVIEW_DATE),MAX(ipm.INTERVIEW_DATE)) - NVL(TO_NUMBER(p_reply_days),0)
890: FROM igs_ad_panel_dtls ipl ,

Line 887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,

883: CURSOR c_intr_reply_date (
884: p_person_id igs_ad_panel_dtls.person_id%TYPE,
885: p_adm_appl_number igs_ad_panel_dtls.admission_appl_number%TYPE,
886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,
887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS
889: SELECT NVL(MAX(ipl.INTERVIEW_DATE),MAX(ipm.INTERVIEW_DATE)) - NVL(TO_NUMBER(p_reply_days),0)
890: FROM igs_ad_panel_dtls ipl ,
891: igs_ad_pnmembr_dtls ipm

Line 888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS

884: p_person_id igs_ad_panel_dtls.person_id%TYPE,
885: p_adm_appl_number igs_ad_panel_dtls.admission_appl_number%TYPE,
886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,
887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS
889: SELECT NVL(MAX(ipl.INTERVIEW_DATE),MAX(ipm.INTERVIEW_DATE)) - NVL(TO_NUMBER(p_reply_days),0)
890: FROM igs_ad_panel_dtls ipl ,
891: igs_ad_pnmembr_dtls ipm
892: WHERE ipl.panel_dtls_id = ipm.panel_dtls_id AND

Line 890: FROM igs_ad_panel_dtls ipl ,

886: p_nominated_course_cd igs_ad_panel_dtls.nominated_course_cd%TYPE,
887: p_appl_sequence_number igs_ad_panel_dtls.sequence_number%TYPE,
888: p_panel_code igs_ad_panel_dtls.panel_code%TYPE)IS
889: SELECT NVL(MAX(ipl.INTERVIEW_DATE),MAX(ipm.INTERVIEW_DATE)) - NVL(TO_NUMBER(p_reply_days),0)
890: FROM igs_ad_panel_dtls ipl ,
891: igs_ad_pnmembr_dtls ipm
892: WHERE ipl.panel_dtls_id = ipm.panel_dtls_id AND
893: ipl.person_id = p_person_id AND
894: ipl.admission_appl_number =p_adm_appl_number AND