APPS.IGR_IMP_003 dependencies on IGS_PE_TYP_INSTANCES

Line 107: lv_new_person_type_code igs_pe_typ_instances.person_type_code%TYPE;

103: lv_msg_data VARCHAR2(4000);
104: lv_return_status VARCHAR2(1);
105: lv_msg_count NUMBER;
106:
107: lv_new_person_type_code igs_pe_typ_instances.person_type_code%TYPE;
108: lv_new_funnel_status igs_pe_typ_instances.funnel_status%TYPE;
109:
110: cst_PROSPECT CONSTANT varchar2(50) DEFAULT 'PROSPECT';
111: cst_IDENTIFIED CONSTANT varchar2(50) DEFAULT '100-IDENTIFIED';

Line 108: lv_new_funnel_status igs_pe_typ_instances.funnel_status%TYPE;

104: lv_return_status VARCHAR2(1);
105: lv_msg_count NUMBER;
106:
107: lv_new_person_type_code igs_pe_typ_instances.person_type_code%TYPE;
108: lv_new_funnel_status igs_pe_typ_instances.funnel_status%TYPE;
109:
110: cst_PROSPECT CONSTANT varchar2(50) DEFAULT 'PROSPECT';
111: cst_IDENTIFIED CONSTANT varchar2(50) DEFAULT '100-IDENTIFIED';
112: cst_INQUIRED CONSTANT varchar2(50) DEFAULT '300-INQUIRED';

Line 131: c_prospect_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE) IS

127: --------------------End variable Declarations-------------------------------
128:
129: ----------------Cursor Declarations-----------------------------------------
130: CURSOR
131: c_prospect_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE) IS
132: SELECT
133: pti.rowid,pti.*
134: FROM
135: igs_pe_typ_instances_all pti,

Line 135: igs_pe_typ_instances_all pti,

131: c_prospect_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE) IS
132: SELECT
133: pti.rowid,pti.*
134: FROM
135: igs_pe_typ_instances_all pti,
136: igs_pe_person_types pt
137: WHERE
138: pti.person_id = cp_person_id
139: AND pti.person_type_code = pt.person_type_code

Line 148: p_old_person_type_code igs_pe_typ_instances.person_type_code%TYPE,

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: /*************************************************************
152: Created By :Sykrishn

Line 149: p_new_person_type_code OUT NOCOPY igs_pe_typ_instances.person_type_code%TYPE,

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: /*************************************************************
152: Created By :Sykrishn
153: Date Created By :06-SEP-2001

Line 150: p_new_funnel_status OUT NOCOPY igs_pe_typ_instances.funnel_status%TYPE) AS

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: /*************************************************************
152: Created By :Sykrishn
153: Date Created By :06-SEP-2001
154: Purpose : To find new person type and the new funnel status

Line 167: lv_person_type_code igs_pe_typ_instances.person_type_code%TYPE ;

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 ;
168: lv_funnel_status igs_pe_typ_instances.funnel_status%TYPE ;
169: lb_int_found BOOLEAN ;
170: lb_int_ctl_found BOOLEAN ;
171:

Line 168: lv_funnel_status igs_pe_typ_instances.funnel_status%TYPE ;

164: ***************************************************************/
165:
166: ----------------------Variable Declarations-----------------------------------------
167: lv_person_type_code igs_pe_typ_instances.person_type_code%TYPE ;
168: lv_funnel_status igs_pe_typ_instances.funnel_status%TYPE ;
169: lb_int_found BOOLEAN ;
170: lb_int_ctl_found BOOLEAN ;
171:
172: cst_PROSPECT CONSTANT varchar2(50) DEFAULT 'PROSPECT';