APPS.IGR_GEN_001 dependencies on IGR_I_APPL_ALL

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);