[Home] [Help]
PACKAGE: APPS.IGR_IN_JTF_INTERACTIONS_PKG
Source
1 PACKAGE Igr_in_jtf_interactions_pkg AS
2 /* $Header: IGSRT05S.pls 120.0 2005/06/01 17:49:26 appldev noship $ */
3
4 /* This package contains global variables and common procedures pertaining to CRM Interaction History Population */
5 -- the api version
6 g_api_version CONSTANT NUMBER := 1.0;
7
8 -- fnd_api.g_ret_sts_success
9 g_ret_sts_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS; -- 'S'
10
11 -- fnd_api.g_ret_sts_error
12 g_ret_sts_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR; -- 'E'
13
14 -- global constants representing TRUE and FALSE.
15 g_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'
16 g_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'
17
18 g_user_id NUMBER;
19 g_resource_id NUMBER;
20 g_login_id NUMBER;
21 g_resp_appl_id NUMBER;
22 g_resp_id NUMBER;
23 g_def_outcome_id jtf_ih_outcomes_vl.outcome_id%TYPE;
24 g_def_outcome jtf_ih_outcomes_vl.short_description%TYPE;
25 g_def_result_id jtf_ih_results_vl.result_id%TYPE;
26 g_def_result jtf_ih_results_vl.short_description%TYPE;
27 g_def_reason_id jtf_ih_reasons_vl.reason_id%TYPE;
28 g_def_reason jtf_ih_reasons_vl.short_description%TYPE;
29 g_int_id NUMBER := NULL; -- Variable to store interaction id
30
31 PROCEDURE get_profile_values;
32 PROCEDURE start_interaction (p_person_id IN igs_pe_person_base_v.person_id%TYPE,
33 p_ret_status OUT NOCOPY VARCHAR2,
34 p_msg_data OUT NOCOPY VARCHAR2,
35 p_msg_count OUT NOCOPY NUMBER ,
36 p_int_id OUT NOCOPY NUMBER);
37 PROCEDURE start_int_and_act (
38 p_doc_ref IN VARCHAR2,
39 p_person_id IN igs_pe_person_base_v.person_id%TYPE,
40 p_sales_lead_id IN as_sales_leads.sales_lead_id%TYPE DEFAULT NULL,
41 p_item_id IN igr_i_a_pkgitm.package_item_id%TYPE DEFAULT NULL,
42 p_doc_id IN NUMBER,
43 p_action IN jtf_ih_actions_vl.action%TYPE DEFAULT NULL,
44 p_action_id IN jtf_ih_actions_vl.action_id%TYPE DEFAULT NULL,
45 p_action_item IN jtf_ih_action_items_vl.action_item%TYPE DEFAULT NULL,
46 p_action_item_id IN jtf_ih_action_items_vl.action_item_id%TYPE DEFAULT NULL,
47 p_ret_status OUT NOCOPY VARCHAR2,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 p_msg_count OUT NOCOPY NUMBER );
50
51 PROCEDURE add_activity(p_action IN VARCHAR2 DEFAULT NULL,
52 p_action_id IN NUMBER DEFAULT NULL,
53 p_Action_item IN VARCHAR2 DEFAULT NULL,
54 p_Action_item_id IN NUMBER DEFAULT NULL,
55 p_doc_source_object_name IN VARCHAR2 DEFAULT NULL,
56 p_doc_id IN NUMBER DEFAULT NULL,
57 p_doc_ref IN VARCHAR2 DEFAULT NULL,
58 p_outcome_id IN NUMBER DEFAULT NULL,
59 p_result_id IN NUMBER DEFAULT NULL,
60 p_reason_id IN NUMBER DEFAULT NULL,
61 p_cust_account_id IN NUMBER DEFAULT NULL,
62 p_int_id IN NUMBER DEFAULT NULL,
63 p_ret_status OUT NOCOPY VARCHAR2,
64 p_msg_data OUT NOCOPY VARCHAR2,
65 p_msg_count OUT NOCOPY NUMBER );
66
67 PROCEDURE update_activity(p_activity_id IN NUMBER,
68 p_action_id IN VARCHAR2,
69 p_Action_item_id IN VARCHAR2,
70 p_doc_source_object_name IN VARCHAR2,
71 p_outcome_id IN NUMBER,
72 p_result_id IN NUMBER,
73 p_reason_id IN NUMBER,
74 p_ret_status OUT NOCOPY VARCHAR2,
75 p_msg_data OUT NOCOPY VARCHAR2,
76 p_msg_count OUT NOCOPY NUMBER );
77
78 PROCEDURE end_interaction (p_ret_status OUT NOCOPY VARCHAR2,
79 p_msg_data OUT NOCOPY VARCHAR2,
80 p_msg_count OUT NOCOPY NUMBER );
81
82 END Igr_in_jtf_interactions_pkg;