APPS.IGR_VAL_EAP dependencies on IGR_I_STATUS_V

Line 24: FROM IGR_I_STATUS_V es

20: DECLARE
21: cst_complete CONSTANT VARCHAR2(20) := 'OSS_COMPLETE';
22: CURSOR c_es IS
23: SELECT es.s_enquiry_status
24: FROM IGR_I_STATUS_V es
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'

Line 26: v_status IGR_I_STATUS_V.s_enquiry_status%TYPE;

22: CURSOR c_es IS
23: SELECT es.s_enquiry_status
24: FROM IGR_I_STATUS_V es
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

Line 49: --2. Get the system status of the IGR_I_STATUS_V.

45: p_enquiry_appl_number IS NULL OR
46: p_enquiry_status IS NULL THEN
47: RETURN TRUE;
48: END IF;
49: --2. Get the system status of the IGR_I_STATUS_V.
50: OPEN c_es;
51: FETCH c_es INTO v_status;
52: IF c_es%NOTFOUND THEN
53: CLOSE c_es;

Line 329: FROM IGR_I_STATUS_V es

325: DECLARE
326: v_es_rec VARCHAR2(1);
327: CURSOR c_es IS
328: SELECT 'X'
329: FROM IGR_I_STATUS_V es
330: WHERE es.enquiry_status = p_enquiry_status and
331: es.s_enquiry_status = 'OSS_REGISTERED';
332: BEGIN
333: p_message_name := null;

Line 378: v_old_status IGR_I_STATUS_V.enquiry_status%TYPE DEFAULT NULL;

374: -- system status of ACKNOWLEGE or COMPLETE
375: -- * Cannot be set to a system status of ACKNOWLEGE from a
376: -- system status of COMPLETE
377: DECLARE
378: v_old_status IGR_I_STATUS_V.enquiry_status%TYPE DEFAULT NULL;
379: v_new_status IGR_I_STATUS_V.enquiry_status%TYPE DEFAULT NULL;
380: v_eapmpi_found VARCHAR2(1) DEFAULT NULL;
381: cst_complete CONSTANT VARCHAR2(15) := 'OSS_COMPLETE';
382: cst_acknowlege CONSTANT VARCHAR2(15) := 'OSS_ACKNOWLEGE';

Line 379: v_new_status IGR_I_STATUS_V.enquiry_status%TYPE DEFAULT NULL;

375: -- * Cannot be set to a system status of ACKNOWLEGE from a
376: -- system status of COMPLETE
377: DECLARE
378: v_old_status IGR_I_STATUS_V.enquiry_status%TYPE DEFAULT NULL;
379: v_new_status IGR_I_STATUS_V.enquiry_status%TYPE DEFAULT NULL;
380: v_eapmpi_found VARCHAR2(1) DEFAULT NULL;
381: cst_complete CONSTANT VARCHAR2(15) := 'OSS_COMPLETE';
382: cst_acknowlege CONSTANT VARCHAR2(15) := 'OSS_ACKNOWLEGE';
383: cst_registered CONSTANT VARCHAR2(15) := 'OSS_REGISTERED';

Line 386: FROM IGR_I_STATUS_V es

382: cst_acknowlege CONSTANT VARCHAR2(15) := 'OSS_ACKNOWLEGE';
383: cst_registered CONSTANT VARCHAR2(15) := 'OSS_REGISTERED';
384: CURSOR c_es (cp_enquiry_status IGR_I_APPL.enquiry_status%TYPE) IS
385: SELECT es.s_enquiry_status
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