[Home] [Help]
PACKAGE: APPS.PV_ASSIGNMENT_PVT
Source
1 PACKAGE PV_ASSIGNMENT_PVT AUTHID CURRENT_USER as
2 /* $Header: pvasgnps.pls 120.0 2005/05/27 16:09:41 appldev noship $ */
3
4 type oppty_routing_log_rec_type is RECORD
5 (
6 oppty_routing_log_id NUMBER,
7 event VARCHAR2(15),
8 lead_id NUMBER,
9 lead_workflow_id NUMBER,
10 routing_type VARCHAR2(30),
11 latest_routing_flag VARCHAR2(1),
12 bypass_cm_flag VARCHAR2(1),
13 lead_assignment_id NUMBER,
14 event_date DATE,
15 vendor_user_id NUMBER,
16 pt_contact_user_id NUMBER,
17 user_response VARCHAR2(30),
18 reason_code VARCHAR2(30),
19 user_type VARCHAR2(6),
20 vendor_business_unit_id NUMBER
21 );
22
23 type attrib_values_rec_type is RECORD
24 (
25 org_type VARCHAR2(30),
26 am_org_name varchar2(100),
27 pt_org_party_id NUMBER,
28 lead_id NUMBER,
29 lead_number NUMBER,
30 entity_name VARCHAR2(240),
31 entity_amount VARCHAR2(300),
32 customer_id NUMBER,
33 address_id NUMBER,
34 customer_name VARCHAR2(360),
35 assignment_type VARCHAR2(30),
36 assignment_type_mean VARCHAR2(100),
37 bypass_cm_ok_flag VARCHAR2(1),
38 process_rule_id NUMBER,
39 process_name VARCHAR2(100)
40 );
41
42
43 type assignment_log_rec_type is RECORD
44 (
45 ASSIGNMENT_ID NUMBER,
46 LAST_UPDATE_DATE DATE,
47 LAST_UPDATED_BY NUMBER,
48 CREATION_DATE DATE,
49 CREATED_BY NUMBER,
50 LAST_UPDATE_LOGIN NUMBER,
51 OBJECT_VERSION_NUMBER NUMBER,
52 LEAD_ASSIGNMENT_ID NUMBER,
53 PARTNER_ID NUMBER,
54 ASSIGN_SEQUENCE NUMBER,
55 CM_ID NUMBER,
56 LEAD_ID NUMBER,
57 DURATION NUMBER,
58 FROM_LEAD_STATUS VARCHAR2(30),
59 TO_LEAD_STATUS VARCHAR2(30),
60 STATUS VARCHAR2(30),
61 STATUS_DATE DATE,
62 WF_ITEM_TYPE VARCHAR2(30),
63 WF_ITEM_KEY VARCHAR2(30),
64 WF_PT_USER VARCHAR2(30),
65 WF_CM_USER VARCHAR2(30),
66 WORKFLOW_ID NUMBER,
67 ERROR_TXT VARCHAR2(255),
68 TRANS_TYPE NUMBER(15),
69 STATUS_CHANGE_COMMENTS VARCHAR2(60)
70 );
71
72 -- ---------------------------------------------------------------------------------
73 -- Initialize record of table. This is not necessary prior to Oracle 10g.
74 -- ---------------------------------------------------------------------------------
75
76 type party_notify_rec_tbl_type is RECORD
77 (
78 WF_ITEM_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
79 WF_ITEM_KEY pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
80 LEAD_ASSIGNMENT_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
81 NOTIFICATION_TYPE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
82 USER_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
83 USER_NAME pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
84 RESOURCE_ID pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type(),
85 RESPONSE_DATE pv_assignment_pub.g_date_table_type := pv_assignment_pub.g_date_table_type(),
86 RESOURCE_RESPONSE pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type(),
87 DECISION_MAKER_FLAG pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type()
88 );
89
90
91 PROCEDURE bulk_cr_party_notification(
92 P_Api_Version_Number IN NUMBER,
93 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 P_party_notify_rec_tbl IN party_notify_rec_tbl_type,
97 X_Return_Status OUT NOCOPY VARCHAR2,
98 X_Msg_Count OUT NOCOPY NUMBER,
99 X_Msg_Data OUT NOCOPY VARCHAR2
100 );
101
102
103 PROCEDURE Create_assignment_log_row(
104 P_Api_Version_Number IN NUMBER,
105 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 P_assignment_log_rec IN assignment_log_rec_type,
109 X_assignment_id OUT NOCOPY NUMBER,
110 X_Return_Status OUT NOCOPY VARCHAR2,
111 X_Msg_Count OUT NOCOPY NUMBER,
112 X_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115
116 PROCEDURE update_party_response(
117 P_Api_Version_Number IN NUMBER,
118 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
119 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
120 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121 P_rowid IN ROWID,
122 p_lead_assignment_id IN NUMBER,
123 p_party_resource_id IN NUMBER,
124 p_response IN VARCHAR2,
125 p_reason_code IN VARCHAR2,
126 p_rank IN NUMBER,
127 X_Return_Status OUT NOCOPY VARCHAR2,
128 X_Msg_Count OUT NOCOPY NUMBER,
129 X_Msg_Data OUT NOCOPY VARCHAR2
130 );
131
132
133 PROCEDURE bulk_set_party_notify_id(
134 P_Api_Version_Number IN NUMBER,
135 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138 p_itemtype IN VARCHAR2,
139 p_itemkey IN VARCHAR2,
140 p_notify_type IN VARCHAR2,
141 X_Return_Status OUT NOCOPY VARCHAR2,
142 X_Msg_Count OUT NOCOPY NUMBER,
143 X_Msg_Data OUT NOCOPY VARCHAR2
144 );
145
146
147 procedure UpdateAssignment (
148 p_api_version_number IN NUMBER
149 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
150 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
151 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
152 ,p_action IN VARCHAR2
153 ,p_lead_assignment_id IN number
154 ,p_status_date IN DATE
155 ,p_status IN VARCHAR2
156 ,p_reason_code IN VARCHAR2
157 ,p_rank IN NUMBER
158 ,x_msg_count OUT NOCOPY NUMBER
159 ,x_msg_data OUT NOCOPY VARCHAR2
160 ,x_return_status OUT NOCOPY VARCHAR2);
161
162
163 procedure removeRejectedFromAccess (
164 p_api_version_number IN NUMBER
165 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
166 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
167 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
168 ,p_itemtype IN VARCHAR2
169 ,p_itemkey IN VARCHAR2
170 ,p_partner_id IN VARCHAR2
171 ,x_msg_count OUT NOCOPY NUMBER
172 ,x_msg_data OUT NOCOPY VARCHAR2
173 ,x_return_status OUT NOCOPY VARCHAR2);
174
175 procedure SetPartnerAttributes (
176 p_api_version_number IN NUMBER
177 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180 ,p_itemType IN VARCHAR2
181 ,p_itemKey IN VARCHAR2
182 ,p_partner_id IN NUMBER
183 ,p_partner_org IN VARCHAR2
184 ,x_msg_count OUT NOCOPY NUMBER
185 ,x_msg_data OUT NOCOPY VARCHAR2
186 ,x_return_status OUT NOCOPY VARCHAR2);
187
188 procedure setTimeout (
189 p_api_version_number IN NUMBER
190 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
192 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193 ,p_itemtype IN VARCHAR2
194 ,p_itemkey IN VARCHAR2
195 ,p_partner_id IN NUMBER
196 ,p_timeoutType IN VARCHAR2
197 ,x_msg_count OUT NOCOPY NUMBER
198 ,x_msg_data OUT NOCOPY VARCHAR2
199 ,x_return_status OUT NOCOPY VARCHAR2);
200
201 procedure set_offered_attributes (
202 p_api_version_number IN NUMBER
203 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
204 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
205 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
206 ,p_itemType IN VARCHAR2
207 ,p_itemKey IN VARCHAR2
208 ,p_partner_id IN NUMBER
209 ,x_msg_count OUT NOCOPY NUMBER
210 ,x_msg_data OUT NOCOPY VARCHAR2
211 ,x_return_status OUT NOCOPY VARCHAR2);
212
213 procedure update_routing_stage (
214 p_api_version_number IN NUMBER
215 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
218 ,p_itemtype IN VARCHAR2
219 ,p_itemkey IN VARCHAR2
220 ,p_routing_stage IN VARCHAR2
221 ,p_active_but_open_flag IN VARCHAR2
222 ,x_msg_count OUT NOCOPY NUMBER
223 ,x_msg_data OUT NOCOPY VARCHAR2
224 ,x_return_status OUT NOCOPY VARCHAR2);
225
226 procedure StartWorkflow (
227 p_api_version_number IN NUMBER,
228 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229 p_commit IN VARCHAR2 := FND_API.G_FALSE,
230 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
231 p_itemKey IN VARCHAR2,
232 p_itemType IN VARCHAR2,
233 p_creating_username IN VARCHAR2,
234 p_attrib_values_rec IN ATTRIB_VALUES_REC_TYPE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2);
238
239
240 procedure validateResponse (
241 p_api_version_number IN NUMBER
242 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
243 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
245 ,p_response_code IN VARCHAR2
246 ,p_routing_status IN VARCHAR2
247 ,p_decision_maker_flag IN VARCHAR2
248 ,p_notify_type IN VARCHAR2
249 ,x_msg_count OUT NOCOPY NUMBER
250 ,x_msg_data OUT NOCOPY VARCHAR2
251 ,x_return_status OUT NOCOPY VARCHAR2);
252
253 procedure set_current_routing_flag (
254 p_api_version_number IN NUMBER,
255 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256 p_commit IN VARCHAR2 := FND_API.G_FALSE,
257 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258 p_itemKey in varchar2,
259 p_entity IN VARCHAR2,
260 p_entity_id IN NUMBER,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2);
264
265 PROCEDURE send_notification(
266 P_Api_Version_Number IN NUMBER,
267 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
268 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
269 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270 p_itemtype IN VARCHAR2,
271 p_itemkey IN VARCHAR2,
272 p_activity_id IN NUMBER,
273 p_route_stage IN VARCHAR2,
274 p_partner_id IN NUMBER,
275 X_Return_Status OUT NOCOPY VARCHAR2,
276 X_Msg_Count OUT NOCOPY NUMBER,
277 X_Msg_Data OUT NOCOPY VARCHAR2);
278
279 procedure AbandonWorkflow (
280 p_api_version_number IN NUMBER,
281 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282 p_commit IN VARCHAR2 := FND_API.G_FALSE,
283 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284 p_creating_username IN VARCHAR2,
285 p_attrib_values_rec IN attrib_values_rec_type,
286 p_partner_org_name IN VARCHAR2,
287 p_action_reason IN VARCHAR2,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2);
291
292 PROCEDURE Create_Oppty_Routing_Log_Row
293 (
294 P_Api_Version_Number IN NUMBER,
295 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298 P_oppty_routing_log_rec IN oppty_routing_log_rec_type,
299 X_Return_Status OUT NOCOPY VARCHAR2,
300 X_Msg_Count OUT NOCOPY NUMBER,
301 X_Msg_Data OUT NOCOPY VARCHAR2
302 );
303
304 End PV_ASSIGNMENT_PVT;