APPS.IGR_GEN_001 dependencies on IGR_I_APPL

Line 90: v_person_id igr_i_appl_all.person_id%TYPE;

86: cst_acknowlege CONSTANT VARCHAR2(30) := 'OSS_ACKNOWLEGE';
87: cst_complete CONSTANT VARCHAR2(30) := 'OSS_COMPLETE';
88: cst_registered CONSTANT VARCHAR2(30) := 'OSS_REGISTERED';
89: cst_both CONSTANT VARCHAR2(5) := 'BOTH';
90: v_person_id igr_i_appl_all.person_id%TYPE;
91: v_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE;
92: v_process_ind igr_i_appl_all.override_process_ind%TYPE;
93: v_complete_status igr_i_status_v.enquiry_status%TYPE;
94: v_acknowledge_status igr_i_status_v.enquiry_status%TYPE;

Line 91: v_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE;

87: cst_complete CONSTANT VARCHAR2(30) := 'OSS_COMPLETE';
88: cst_registered CONSTANT VARCHAR2(30) := 'OSS_REGISTERED';
89: cst_both CONSTANT VARCHAR2(5) := 'BOTH';
90: v_person_id igr_i_appl_all.person_id%TYPE;
91: v_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE;
92: v_process_ind igr_i_appl_all.override_process_ind%TYPE;
93: v_complete_status igr_i_status_v.enquiry_status%TYPE;
94: v_acknowledge_status igr_i_status_v.enquiry_status%TYPE;
95: v_group_id igs_pe_persid_group.group_id%TYPE;

Line 92: v_process_ind igr_i_appl_all.override_process_ind%TYPE;

88: cst_registered CONSTANT VARCHAR2(30) := 'OSS_REGISTERED';
89: cst_both CONSTANT VARCHAR2(5) := 'BOTH';
90: v_person_id igr_i_appl_all.person_id%TYPE;
91: v_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE;
92: v_process_ind igr_i_appl_all.override_process_ind%TYPE;
93: v_complete_status igr_i_status_v.enquiry_status%TYPE;
94: v_acknowledge_status igr_i_status_v.enquiry_status%TYPE;
95: v_group_id igs_pe_persid_group.group_id%TYPE;
96: v_person_id_group_created VARCHAR2(1);

Line 106: l_s_enq_stat igr_i_appl_v.s_enquiry_status%TYPE;

102: e_resource_busy EXCEPTION;
103: l_ret_status VARCHAR2(3);
104: l_msg_data VARCHAR2(3000);
105: l_msg_count NUMBER;
106: l_s_enq_stat igr_i_appl_v.s_enquiry_status%TYPE;
107: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
108:
109: v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
110:

Line 123: FROM igr_i_appl eap,

119: --and Enquiry Entry status passed are valid for the Persons. Modified the following cursor as part of CRM recruitment
120: --changes. Bug: 2664699
121: CURSOR c_eap_es (cp_s_enquiry_status as_statuses_vl.status_code%TYPE) IS
122: SELECT eap.*
123: FROM igr_i_appl eap,
124: igr_i_status_v es
125: WHERE ((eap.enquiry_dt >= p_enquiry_dt_low OR p_enquiry_dt_low IS NULL) AND
126: (eap.enquiry_dt <= p_enquiry_dt_high OR p_enquiry_dt_high IS NULL)) AND
127: eap.enquiry_status = es.enquiry_status AND