APPS.IGR_IMP_003 dependencies on IGS_AD_INTERFACE

Line 83: p_source_type_id igs_ad_interface.source_type_id%TYPE,

79:
80:
81: /***********************Start Create person inquiry *********************************/
82: PROCEDURE create_person_inquiry ( p_inquiry_dtls_rec IN c_inquiry_dtls%ROWTYPE,
83: p_source_type_id igs_ad_interface.source_type_id%TYPE,
84: p_status OUT NOCOPY VARCHAR2
85: ) AS
86: /*************************************************************
87: Created By :Syam.Krishnan

Line 147: p_source_type_id igs_ad_interface.source_type_id%TYPE,

143:
144:
145: --------------------Local Procedure for Finding Funnel Status and Person Type------------------
146: PROCEDURE find_ptype_funnel_status (p_inquiry_dtls_rec c_inquiry_dtls%ROWTYPE ,
147: p_source_type_id igs_ad_interface.source_type_id%TYPE,
148: p_old_person_type_code igs_pe_typ_instances.person_type_code%TYPE,
149: p_new_person_type_code OUT NOCOPY igs_pe_typ_instances.person_type_code%TYPE,
150: p_new_funnel_status OUT NOCOPY igs_pe_typ_instances.funnel_status%TYPE) AS
151: /*************************************************************

Line 163: from IGS_AD_INTERFACE_CTL as part of Enh Bug: 2604395

159: (reverse chronological order - newest change first)
160: Change History
161: Who When What
162: rboddu 09-OCT-2002 Removed the logic of fetching person_type_code and funnel_status
163: from IGS_AD_INTERFACE_CTL as part of Enh Bug: 2604395
164: ***************************************************************/
165:
166: ----------------------Variable Declarations-----------------------------------------
167: lv_person_type_code igs_pe_typ_instances.person_type_code%TYPE ;

Line 178: /* Cursor to get the person_type and funnel_status from igs_ad_interface */

174: cst_applicant CONSTANT VARCHAR2(50) DEFAULT 'APPLICANT';
175: ----------------------End Variable Declarations-----------------------------------------
176:
177: -----------------Cursor Declarations----------------------------------------------------
178: /* Cursor to get the person_type and funnel_status from igs_ad_interface */
179: CURSOR c_interface (cp_interface_id igs_ad_interface.interface_id%TYPE) IS
180: SELECT
181: person_type_code ,
182: funnel_status

Line 179: CURSOR c_interface (cp_interface_id igs_ad_interface.interface_id%TYPE) IS

175: ----------------------End Variable Declarations-----------------------------------------
176:
177: -----------------Cursor Declarations----------------------------------------------------
178: /* Cursor to get the person_type and funnel_status from igs_ad_interface */
179: CURSOR c_interface (cp_interface_id igs_ad_interface.interface_id%TYPE) IS
180: SELECT
181: person_type_code ,
182: funnel_status
183: FROM

Line 184: igs_ad_interface

180: SELECT
181: person_type_code ,
182: funnel_status
183: FROM
184: igs_ad_interface
185: WHERE
186: interface_id = cp_interface_id;
187:
188: CURSOR c_pe_src_types (cp_source_type_id igs_ad_interface.source_type_id%TYPE) IS

Line 188: CURSOR c_pe_src_types (cp_source_type_id igs_ad_interface.source_type_id%TYPE) IS

184: igs_ad_interface
185: WHERE
186: interface_id = cp_interface_id;
187:
188: CURSOR c_pe_src_types (cp_source_type_id igs_ad_interface.source_type_id%TYPE) IS
189: SELECT
190: person_type_code ,
191: funnel_status
192: FROM