APPS.IGR_VAL_EAP dependencies on IGR_I_A_PKGITM_V

Line 19: -- IGR_I_A_PKGITM_V records exist with mailed_dt set to NULL.

15: RETURN BOOLEAN IS
16: BEGIN -- admp_val_eap_es_comp
17: -- Validate IGR_I_APPL.enquiry_status:
18: -- * Must be set to system status of 'COMPLETE' if no child
19: -- IGR_I_A_PKGITM_V records exist with mailed_dt set to NULL.
20: DECLARE
21: cst_complete CONSTANT VARCHAR2(20) := 'OSS_COMPLETE';
22: CURSOR c_es IS
23: SELECT es.s_enquiry_status

Line 29: FROM IGR_I_A_PKGITM_V eapmpi

25: WHERE es.enquiry_status = p_enquiry_status;
26: v_status IGR_I_STATUS_V.s_enquiry_status%TYPE;
27: CURSOR c_epi IS
28: SELECT 'x'
29: FROM IGR_I_A_PKGITM_V eapmpi
30: WHERE eapmpi.person_id = p_person_id AND
31: eapmpi.enquiry_appl_number = p_enquiry_appl_number;
32: CURSOR c_eapmpi IS
33: SELECT 'x'

Line 34: FROM IGR_I_A_PKGITM_V eapmpi

30: WHERE eapmpi.person_id = p_person_id AND
31: eapmpi.enquiry_appl_number = p_enquiry_appl_number;
32: CURSOR c_eapmpi IS
33: SELECT 'x'
34: FROM IGR_I_A_PKGITM_V eapmpi
35: WHERE eapmpi.person_id = p_person_id AND
36: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND
37: eapmpi.mailed_dt IS NULL;
38: v_eapmpi_exists VARCHAR2(1);

Line 68: -- child IGR_I_A_PKGITM_V records exist where mailed_dt is null.

64: END IF;
65: CLOSE c_epi;
66: END IF; -- v_status
67: --4. Validate that status must be set to system status of 'COMPLETE' if no
68: -- child IGR_I_A_PKGITM_V records exist where mailed_dt is null.
69: IF v_status <> cst_complete THEN
70: OPEN c_eapmpi;
71: FETCH c_eapmpi INTO v_eapmpi_exists;
72: IF c_eapmpi%NOTFOUND THEN

Line 372: -- IGR_I_A_PKGITM_V exists with mailed_dt set to NULL

368: RETURN BOOLEAN IS
369: BEGIN -- admp_val_eap_status
370: -- Validate IGR_I_APPL.enquiry_status
371: -- * Cannot be set to a system status of COMPLETE if child
372: -- IGR_I_A_PKGITM_V exists with mailed_dt set to NULL
373: -- * Cannot be set to a system status of REGISTERED from a
374: -- system status of ACKNOWLEGE or COMPLETE
375: -- * Cannot be set to a system status of ACKNOWLEGE from a
376: -- system status of COMPLETE

Line 390: FROM IGR_I_A_PKGITM_V eapmpi

386: FROM IGR_I_STATUS_V es
387: WHERE es.enquiry_status = cp_enquiry_status;
388: CURSOR c_eapmpi IS
389: SELECT 'x'
390: FROM IGR_I_A_PKGITM_V eapmpi
391: WHERE eapmpi.person_id = p_person_id AND
392: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND
393: eapmpi.mailed_dt IS NULL;
394: BEGIN

Line 428: -- IGR_I_A_PKGITM_V records exist where mailed_dt is null

424: RETURN FALSE;
425: END IF;
426: END IF;
427: -- Validate that status cannot be set to system status of 'COMPLETE' if child
428: -- IGR_I_A_PKGITM_V records exist where mailed_dt is null
429: IF v_new_status = cst_complete THEN
430: OPEN c_eapmpi;
431: FETCH c_eapmpi INTO v_eapmpi_found;
432: IF c_eapmpi%FOUND THEN