APPS.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_AD_APPL

Line 438: igs_ad_appl aa

434: -- Cursor to check the application date of the application
435: CURSOR c_appl_dt IS
436: SELECT appl_dt
437: FROM igs_ad_panel_dtls pd,
438: igs_ad_appl aa
439: WHERE pd.panel_dtls_id = new_references.panel_dtls_id
440: AND pd.admission_appl_number = aa.admission_appl_number
441: AND pd.person_id = aa.person_id;
442:

Line 443: l_appl_dt igs_ad_appl.appl_dt%TYPE;

439: WHERE pd.panel_dtls_id = new_references.panel_dtls_id
440: AND pd.admission_appl_number = aa.admission_appl_number
441: AND pd.person_id = aa.person_id;
442:
443: l_appl_dt igs_ad_appl.appl_dt%TYPE;
444:
445: -- Cursor to check final decision associated to panel code.
446: CURSOR c_chk_final_decision (cp_panel_dtls_id igs_ad_panel_dtls.panel_dtls_id%TYPE) IS
447: SELECT *

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

605: FETCH c_appl_dt INTO l_appl_dt;
606: CLOSE c_appl_dt;
607:
608: IF NVL(new_references.interview_date,sysdate) < l_appl_dt THEN
609: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR'); -- NAME cannot be less than Application Date
610: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_INTVW_DATE')); -- Message: Decision Date
611: igs_ge_msg_stack.add;
612: app_exception.raise_exception;
613: END IF;