APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_AD_APPL

Line 549: igs_Ad_appl appl

545:
546: CURSOR c_apcs_step_exist IS
547: SELECT 'X'
548: FROM igs_ad_prcs_cat_step apcs ,
549: igs_Ad_appl appl
550: WHERE appl.person_id = new_references.person_id
551: AND appl.admission_appl_number = new_references.admission_appl_number
552: AND apcs.admission_cat = appl.admission_cat
553: AND apcs.s_admission_process_type = appl.s_admission_process_type

Line 667: FROM igs_ad_appl aa

663:
664: -- Cursor to check the application date of the application
665: CURSOR c_appl_dt IS
666: SELECT appl_dt
667: FROM igs_ad_appl aa
668: WHERE aa.person_id = new_references.person_id
669: AND aa.admission_appl_number = new_references.admission_appl_number;
670:
671: l_appl_dt igs_ad_appl.appl_dt%TYPE;

Line 671: l_appl_dt igs_ad_appl.appl_dt%TYPE;

667: FROM igs_ad_appl aa
668: WHERE aa.person_id = new_references.person_id
669: AND aa.admission_appl_number = new_references.admission_appl_number;
670:
671: l_appl_dt igs_ad_appl.appl_dt%TYPE;
672:
673: BEGIN
674: IF NVL(p_inserting,FALSE) THEN
675: -- A Person added to a panel must have the system person type of Interviewer. Else raise an error message.

Line 833: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR'); -- NAME cannot be less than Application Date

829: FETCH c_appl_dt INTO l_appl_dt;
830: CLOSE c_appl_dt;
831:
832: IF NVL(new_references.interview_date,sysdate) < l_appl_dt THEN
833: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR'); -- NAME cannot be less than Application Date
834: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_INTVW_DATE')); -- Message: Decision Date
835: igs_ge_msg_stack.add;
836: app_exception.raise_exception;
837: END IF;