APPS.IGR_PERSON_TYPE_PKG dependencies on IGS_PE_TYP_INSTANCES

Line 18: l_funnel_status igs_pe_typ_instances_all.funnel_status%TYPE;

14: cst_funnel_status CONSTANT varchar2(25):= '100-IDENTIFIED';
15:
16: lv_type_instance_id NUMBER(15);
17: l_person_type_code igs_pe_person_types.person_type_code%TYPE;
18: l_funnel_status igs_pe_typ_instances_all.funnel_status%TYPE;
19:
20: lv_sysdate DATE;
21: l_org_id NUMBER(15);
22: lv_rowid2 VARCHAR2(30);

Line 63: -- igs_pe_typ_instances_pkg if we are creating other than 'OTHER'

59: -- pass the person type as system defined value of 'PROSPECT'
60: -- and funnel status as '100-IDENTIFIED'
61:
62: -- Other person type will be automatically deleted inside the
63: -- igs_pe_typ_instances_pkg if we are creating other than 'OTHER'
64: -- person type which is active
65: igs_pe_typ_instances_pkg.insert_row
66: (
67: X_MODE => 'R',

Line 65: igs_pe_typ_instances_pkg.insert_row

61:
62: -- Other person type will be automatically deleted inside the
63: -- igs_pe_typ_instances_pkg if we are creating other than 'OTHER'
64: -- person type which is active
65: igs_pe_typ_instances_pkg.insert_row
66: (
67: X_MODE => 'R',
68: X_RowId => lv_rowid2,
69: X_TYPE_INSTANCE_ID => lv_type_instance_id,

Line 95: CURSOR c_persontype_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE)

91:
92: FUNCTION checkactiveXPersontype(p_person_id IN NUMBER, p_person_type IN VARCHAR2)
93: RETURN BOOLEAN AS
94: l_exists VARCHAR2(1);
95: CURSOR c_persontype_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE)
96: IS
97: SELECT 'X'
98: FROM
99: igs_pe_typ_instances_all pti, igs_pe_person_types pt

Line 99: igs_pe_typ_instances_all pti, igs_pe_person_types pt

95: CURSOR c_persontype_exist (cp_person_id igs_pe_typ_instances.person_id%TYPE)
96: IS
97: SELECT 'X'
98: FROM
99: igs_pe_typ_instances_all pti, igs_pe_person_types pt
100: WHERE
101: pti.person_id = cp_person_id
102: AND pti.person_type_code = pt.person_type_code
103: AND pt.system_type = p_person_type