[Home] [Help]
PACKAGE: APPS.PV_OPPORTUNITY_VHUK
Source
1 PACKAGE PV_OPPORTUNITY_VHUK AUTHID CURRENT_USER as
2 /* $Header: pvxvopts.pls 120.0 2005/05/27 16:10:01 appldev noship $ */
3
4 -- Start of Comments
5
6 -- Package name : PV_OPPORTUNITY_VHUK
7 -- Purpose : 1. Send out email notification to CM when an opportunity is created by Partner / VAD
8 -- 2. When an Opportunity is created or updated retrieve the partner related information
9 -- associated with the campaign from AMS table and copy into
10 -- AS_LEAD_ASSIGNMENTS table to keep track of the associated partner with the Campaign.
11 -- History :
12 --
13 -- NOTE :
14 -- End of Comments
15 --
16
17 g_wf_itemtype_notify CONSTANT VARCHAR2(30) := 'PVOPTYHK';
18 g_wf_pcs_notify_cm CONSTANT varchar2(30) := 'PV_NOTIFY_CM_DEF_PCS';
19 g_wf_pcs_notify_party CONSTANT VARCHAR2(30) := 'PV_NOTIFY_PARTY_PCS';
20
21 g_wf_status_open CONSTANT VARCHAR2(20) := 'OPEN';
22 g_wf_status_closed CONSTANT VARCHAR2(20) := 'CLOSED';
23
24 g_r_status_active CONSTANT VARCHAR2(20) := 'ACTIVE';
25 g_r_status_unassigned CONSTANT VARCHAR2(20) := 'UNASSIGNED';
26
27 g_r_notify_cm_type CONSTANT VARCHAR2(20) := 'PTCR_FYI';
28 g_r_notify_all_type CONSTANT VARCHAR2(20) := 'STCHG_FYI';
29
30 g_la_status_pt_created CONSTANT varchar2(20) := 'PT_CREATED';
31
32 g_wf_attr_notify_role CONSTANT VARCHAR2(40) := 'PV_NOTIFY_CM_NEW_OPPTY_ROLE';
33 g_wf_attr_opp_number CONSTANT varchar2(30) := 'PV_OPP_NUMBER_ATTR';
34 g_wf_attr_opp_name CONSTANT varchar2(30) := 'PV_OPP_NAME_ATTR';
35 g_wf_attr_opp_amt CONSTANT varchar2(30) := 'PV_OPP_AMT_ATTR';
36 g_wf_attr_vendor_org_name CONSTANT varchar2(30) := 'PV_VENDOR_ORG_NAME_ATTR';
37 g_wf_attr_customer_name CONSTANT varchar2(30) := 'PV_CUSTOMER_NAME_ATTR';
38 g_wf_attr_partner_id CONSTANT varchar2(30) := 'PV_PARTNER_ID_ATTR';
39 g_wf_attr_partner_name CONSTANT varchar2(30) := 'PV_PARTNER_NAME_ATTR';
40 g_wf_attr_lead_id CONSTANT varchar2(30) := 'PV_LEAD_ID_ATTR';
41
42 g_wf_attr_cm_notify_role CONSTANT VARCHAR2(20) := 'PV_NOTIFY_CM_ROLE';
43 g_wf_attr_am_notify_role CONSTANT VARCHAR2(20) := 'PV_NOTIFY_AM_ROLE';
44 g_wf_attr_pt_notify_role CONSTANT VARCHAR2(20) := 'PV_NOTIFY_PT_ROLE';
45 g_wf_attr_ot_notify_role CONSTANT VARCHAR2(20) := 'PV_NOTIFY_OTHER_ROLE';
46
47
48 g_wf_attr_from_status CONSTANT varchar2(30) := 'PV_FROM_STATUS_ATTR';
49 g_wf_attr_to_status CONSTANT varchar2(30) := 'PV_TO_STATUS_ATTR';
50 g_wf_attr_send_url CONSTANT varchar2(30) := 'PV_CM_RESPOND_URL_ATTR';
51
52
53
54 g_entity VARCHAR2(20) := 'OPPORTUNITY';
55
56 procedure Create_Opportunity_Post (
57 p_api_version_number IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_commit IN VARCHAR2 := FND_API.G_FALSE,
60 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61 p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
62 p_salesforce_id IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67 procedure Update_Opportunity_Pre (
68 p_api_version_number IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70 p_commit IN VARCHAR2 := FND_API.G_FALSE,
71 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72 p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
73 p_salesforce_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2);
77
78 procedure Notify_CM_On_Create_Oppty (
79 p_api_version_number IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
84 p_salesforce_id IN NUMBER,
85 p_relationship_type IN VARCHAR2,
86 p_party_relation_id IN NUMBER,
87 p_user_name IN VARCHAR2,
88 p_party_name IN VARCHAR2,
89 p_partner_type IN VARCHAR2,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2);
93
94 procedure Send_Email_By_Workflow (
95 p_api_version_number IN NUMBER,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99 p_user_name_tbl IN JTF_VARCHAR2_TABLE_100,
100 p_user_type_tbl IN JTF_VARCHAR2_TABLE_100,
101 p_username IN VARCHAR2,
102 p_opp_amt IN VARCHAR2,
103 p_opp_name IN VARCHAR2,
104 p_customer_name IN VARCHAR2,
105 p_lead_number IN NUMBER,
106 p_from_status IN VARCHAR2,
107 p_to_status IN VARCHAR2,
108 p_vendor_org_name IN VARCHAR2,
109 p_partner_names IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2);
113
114 procedure StartWorkflow
115 (
116 p_api_version_number IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 p_itemKey IN VARCHAR2,
121 p_itemType IN VARCHAR2,
122 p_partner_id IN NUMBER,
123 p_partner_name IN VARCHAR2,
124 p_lead_id IN NUMBER,
125 p_opp_name IN VARCHAR2,
126 p_lead_number IN NUMBER,
127 p_customer_id IN NUMBER,
128 p_address_id IN NUMBER,
129 p_customer_name IN VARCHAR2,
130 p_creating_username IN VARCHAR2,
131 p_bypass_cm_ok_flag IN VARCHAR2,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 PROCEDURE Notify_Party_On_Update_Oppty
138 (
139 p_api_version_number IN NUMBER,
140 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141 p_commit IN VARCHAR2 := FND_API.G_FALSE,
142 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143 p_oppty_header_rec IN AS_OPPORTUNITY_PUB.header_rec_type,
144 p_salesforce_id IN NUMBER,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150
151
152 PROCEDURE Party_Msg_Send_Wf
153 ( itemtype in varchar2,
154 itemkey in varchar2,
155 actid in number,
156 funcmode in varchar2,
157 resultout in OUT NOCOPY varchar2
158 );
159
160 Procedure Set_Oppty_Amt_Wf
161 ( itemtype in varchar2,
162 itemkey in varchar2,
163 actid in number,
164 funcmode in varchar2,
165 resultout in OUT NOCOPY varchar2
166 );
167
168
169 procedure get_user_info
170 ( p_salesforce_id IN VARCHAR2,
171 p_channel_code IN VARCHAR2,
172 x_party_rel_id OUT NOCOPY NUMBER,
173 x_relationship_type OUT NOCOPY VARCHAR2,
174 x_user_name OUT NOCOPY VARCHAR2,
175 x_party_name OUT NOCOPY VARCHAR2,
176 x_party_type OUT NOCOPY VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2
180 );
181
182 procedure NOTIFY_ON_UPDATE_OPPTY_JBES (
183 p_api_version_number IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_lead_id IN NUMBER,
188 p_status IN VARCHAR2,
189 p_lead_name IN VARCHAR2,
190 p_customer_id IN NUMBER,
191 p_total_amount IN NUMBER,
192 p_salesforce_id IN NUMBER,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2);
196
197 End PV_OPPORTUNITY_VHUK;