APPS.IGR_IN_JTF_INTERACTIONS_PKG dependencies on JTF_IH_ACTIONS_VL

Line 137: p_action IN jtf_ih_actions_vl.action%TYPE,

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,
138: p_action_id IN jtf_ih_actions_vl.action_id%TYPE,
139: p_action_item IN jtf_ih_action_items_vl.action_item%TYPE,
140: p_action_item_id IN jtf_ih_action_items_vl.action_item_id%TYPE,
141: p_ret_status OUT NOCOPY VARCHAR2,

Line 138: p_action_id IN jtf_ih_actions_vl.action_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,
138: p_action_id IN jtf_ih_actions_vl.action_id%TYPE,
139: p_action_item IN jtf_ih_action_items_vl.action_item%TYPE,
140: p_action_item_id IN jtf_ih_action_items_vl.action_item_id%TYPE,
141: p_ret_status OUT NOCOPY VARCHAR2,
142: p_msg_data OUT NOCOPY VARCHAR2,

Line 222: FROM jtf_ih_actions_vl

218: p_msg_count OUT NOCOPY NUMBER ) IS
219:
220: CURSOR activity_action is
221: SELECT action_id
222: FROM jtf_ih_actions_vl
223: WHERE action = p_action;
224:
225: CURSOR activity_action_item is
226: SELECT action_item_id

Line 244: -- Get the action_id and action_item_id from jtf_ih_actions_vl and jtf_ih_Action_items_vl

240: l_activity_rec.interaction_id := p_int_id;
241: l_activity_rec.outcome_id := Igr_in_jtf_interactions_pkg.g_def_outcome_id;
242: l_activity_rec.result_id := Igr_in_jtf_interactions_pkg.g_def_result_id;
243: l_activity_rec.reason_id := Igr_in_jtf_interactions_pkg.g_def_reason_id;
244: -- Get the action_id and action_item_id from jtf_ih_actions_vl and jtf_ih_Action_items_vl
245: IF p_action_id IS NULL THEN
246: OPEN activity_action;
247: FETCH activity_action into l_activity_rec.action_id;
248: CLOSE activity_action;