DBA Data[Home] [Help]

APPS.IGR_IN_JTF_INTERACTIONS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 73: PROCEDURE start_interaction (p_person_id IN igs_pe_person_base_v.person_id%TYPE,

69: CLOSE default_reason;
70:
71: END get_profile_values;
72:
73: PROCEDURE start_interaction (p_person_id IN igs_pe_person_base_v.person_id%TYPE,
74: p_ret_status OUT NOCOPY VARCHAR2,
75: p_msg_data OUT NOCOPY VARCHAR2,
76: p_msg_count OUT NOCOPY NUMBER,
77: p_int_id OUT NOCOPY NUMBER) IS

Line 133: p_person_id IN igs_pe_person_base_v.person_id%TYPE,

129: END start_interaction;
130:
131: PROCEDURE start_int_and_act (
132: p_doc_ref IN VARCHAR2,
133: p_person_id IN igs_pe_person_base_v.person_id%TYPE,
134: p_sales_lead_id IN as_sales_leads.sales_lead_id%TYPE ,
135: p_item_id IN igr_i_a_pkgitm.package_item_id%TYPE ,
136: p_doc_id IN NUMBER,
137: p_action IN jtf_ih_actions_vl.action%TYPE,

Line 147: CURSOR c_person_number(p_person_id igs_pe_person_base_v.person_id%TYPE) IS

143: p_msg_count OUT NOCOPY NUMBER ) IS
144: /* This procedure starts and interaction and starts an activity */
145:
146:
147: CURSOR c_person_number(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
148: SELECT person_number
149: FROM igs_pe_person_base_v
150: WHERE person_id = p_person_id;
151:

Line 149: FROM igs_pe_person_base_v

145:
146:
147: CURSOR c_person_number(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
148: SELECT person_number
149: FROM igs_pe_person_base_v
150: WHERE person_id = p_person_id;
151:
152: person_number_rec c_person_number%ROWTYPE;
153: p_int_id NUMBER;