[Home] [Help]
PACKAGE: APPS.PV_ASSIGN_UTIL_PVT
Source
1 PACKAGE PV_ASSIGN_UTIL_PVT AUTHID CURRENT_USER as
2 /* $Header: pvvautls.pls 120.1 2006/01/10 12:17:09 amaram noship $ */
3 -- Start of Comments
4
5 -- Package name : PV_ASSIGN_UTIL_PVT
6 -- Purpose :
7 -- History :
8 --
9 -- NOTE :
10 -- End of Comments
11 --
12
13 -- TYPE my_number_table IS TABLE OF NUMBER;
14
15 TYPE party_notify_rec_type is RECORD
16 (
17 PARTY_NOTIFICATION_ID NUMBER,
18 LAST_UPDATE_DATE DATE,
19 LAST_UPDATED_BY NUMBER,
20 CREATION_DATE DATE,
21 CREATED_BY NUMBER,
22 LAST_UPDATE_LOGIN NUMBER,
23 OBJECT_VERSION_NUMBER NUMBER,
24 REQUEST_ID NUMBER,
25 PROGRAM_APPLICATION_ID NUMBER,
26 PROGRAM_ID NUMBER,
27 PROGRAM_UPDATE_DATE DATE,
28 NOTIFICATION_ID NUMBER,
29 NOTIFICATION_TYPE VARCHAR2(30),
30 LEAD_ASSIGNMENT_ID NUMBER,
31 WF_ITEM_TYPE VARCHAR2(30),
32 WF_ITEM_KEY VARCHAR2(30),
33 USER_ID NUMBER,
34 USER_NAME VARCHAR2(30),
35 RESOURCE_ID NUMBER,
36 DECISION_MAKER_FLAG VARCHAR2(1),
37 RESOURCE_RESPONSE VARCHAR2(30),
38 RESPONSE_DATE DATE,
39 ATTRIBUTE_CATEGORY VARCHAR2(30),
40 ATTRIBUTE1 VARCHAR2(150),
41 ATTRIBUTE2 VARCHAR2(150),
42 ATTRIBUTE3 VARCHAR2(150),
43 ATTRIBUTE4 VARCHAR2(150),
44 ATTRIBUTE5 VARCHAR2(150),
45 ATTRIBUTE6 VARCHAR2(150),
46 ATTRIBUTE7 VARCHAR2(150),
47 ATTRIBUTE8 VARCHAR2(150),
48 ATTRIBUTE9 VARCHAR2(150),
49 ATTRIBUTE10 VARCHAR2(150),
50 ATTRIBUTE11 VARCHAR2(150),
51 ATTRIBUTE12 VARCHAR2(150),
52 ATTRIBUTE13 VARCHAR2(150),
53 ATTRIBUTE14 VARCHAR2(150),
54 ATTRIBUTE15 VARCHAR2(150)
55 );
56
57
58 TYPE assignment_rec_type is RECORD
59 (
60 LEAD_ASSIGNMENT_ID NUMBER,
61 LAST_UPDATE_DATE DATE,
62 LAST_UPDATED_BY NUMBER,
63 CREATION_DATE DATE,
64 CREATED_BY NUMBER,
65 LAST_UPDATE_LOGIN NUMBER,
66 OBJECT_VERSION_NUMBER NUMBER,
67 LEAD_ID NUMBER,
68 PARTNER_ID NUMBER,
69 PARTNER_ACCESS_CODE VARCHAR2 (30),
70 RELATED_PARTY_ID NUMBER,
71 RELATED_PARTY_ACCESS_CODE VARCHAR2 (30),
72 ASSIGN_SEQUENCE NUMBER,
73 STATUS_DATE DATE,
74 STATUS VARCHAR2 (20),
75 REASON_CODE VARCHAR2 (30),
76 SOURCE_TYPE VARCHAR2 (30),
77 WF_ITEM_TYPE VARCHAR2 (20),
78 WF_ITEM_KEY VARCHAR2 (20),
79 ERROR_TXT VARCHAR2 (200)
80 );
81
82
83 TYPE lead_workflow_rec_type is RECORD
84 (
85 LEAD_WORKFLOW_ID NUMBER(15),
86 LAST_UPDATE_DATE DATE,
87 LAST_UPDATED_BY NUMBER(15),
88 CREATION_DATE DATE,
89 CREATED_BY NUMBER(15),
90 LAST_UPDATE_LOGIN NUMBER(15),
91 OBJECT_VERSION_NUMBER NUMBER,
92 ENTITY VARCHAR2(30),
93 LEAD_ID NUMBER(15),
94 WF_ITEM_TYPE VARCHAR2(30),
95 WF_ITEM_KEY VARCHAR2(30),
96 WF_STATUS VARCHAR2(30),
97 MATCHED_DUE_DATE DATE,
98 OFFERED_DUE_DATE DATE,
99 BYPASS_CM_OK_FLAG VARCHAR2(30),
100 LATEST_ROUTING_FLAG VARCHAR2(1),
101 ROUTING_STATUS VARCHAR2(30),
102 ROUTING_TYPE VARCHAR2(30),
103 FAILURE_CODE VARCHAR2(30),
104 FAILURE_MESSAGE VARCHAR2(500)
105 );
106
107 type resource_details_rec_type is RECORD
108 (
109 NOTIFICATION_TYPE VARCHAR2(30),
110 DECISION_MAKER_FLAG VARCHAR2(1),
111 USER_ID NUMBER,
112 PERSON_ID NUMBER, -- per_people_x.person_id for EMPLOYEE, partner_cont_party_id for PARTY
113 PERSON_TYPE VARCHAR2(30), -- PARTY or EMPLOYEE
114 USER_NAME VARCHAR2(1000),
115 RESOURCE_ID NUMBER
116 );
117
118 type resource_details_tbl_type is TABLE OF RESOURCE_DETAILS_REC_TYPE;
119
120 PROCEDURE Create_party_notification(
121 P_Api_Version_Number IN NUMBER,
122 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125 P_party_notify_Rec IN PV_ASSIGN_UTIL_Pvt.party_notify_rec_type,
126 X_PARTY_NOTIFICATION_ID OUT NOCOPY 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 create_lead_workflow_row (
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_workflow_rec IN LEAD_WORKFLOW_REC_TYPE
139 ,x_itemkey OUT NOCOPY VARCHAR2
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2);
143
144
145 procedure create_lead_assignment_row (
146 p_api_version_number IN NUMBER
147 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150 ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
151 ,x_lead_assignment_id OUT NOCOPY NUMBER
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2);
155
156
157 procedure delete_lead_assignment_row (
158 p_api_version_number IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
160 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
161 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
162 ,p_lead_assignment_id IN NUMBER
163 ,x_return_status OUT NOCOPY VARCHAR2
164 ,x_msg_count OUT NOCOPY NUMBER
165 ,x_msg_data OUT NOCOPY VARCHAR2);
166
167
168 procedure get_partner_info (
169 p_api_version_number IN NUMBER,
170 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171 p_commit IN VARCHAR2 := FND_API.G_FALSE,
172 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173 p_mode IN VARCHAR2, -- VENDOR or EXTERNAL
174 p_partner_id IN NUMBER,
175 p_entity IN VARCHAR2,
176 p_entity_id IN NUMBER,
177 p_retrieve_mode IN VARCHAR2,
178 x_rs_details_tbl IN OUT NOCOPY resource_details_tbl_type,
179 x_vad_id IN OUT NOCOPY NUMBER,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2);
183
184 procedure GetWorkflowID (
185 p_api_version_number IN NUMBER
186 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
187 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
188 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
189 ,p_lead_id IN NUMBER
190 ,p_entity IN VARCHAR2
191 ,x_itemType OUT NOCOPY VARCHAR2
192 ,x_itemKey OUT NOCOPY VARCHAR2
193 ,x_routing_status OUT NOCOPY VARCHAR2
194 ,x_wf_status OUT NOCOPY VARCHAR2
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_msg_count OUT NOCOPY NUMBER
197 ,x_msg_data OUT NOCOPY VARCHAR2);
198
199 procedure UpdateAccess
200 ( p_api_version_number IN NUMBER,
201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204 p_itemtype IN VARCHAR2,
205 p_itemkey IN VARCHAR2,
206 p_current_username IN VARCHAR2,
207 p_lead_id IN NUMBER,
208 p_customer_id IN NUMBER,
209 p_address_id IN NUMBER,
210 p_resource_id IN NUMBER,
211 p_access_type IN NUMBER,
212 p_access_action IN NUMBER,
213 x_access_id OUT NOCOPY NUMBER,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2);
217
218 procedure Log_assignment_status (
219 p_api_version_number IN NUMBER
220 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
221 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
222 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223 ,p_assignment_rec IN ASSIGNMENT_REC_TYPE
224 ,x_return_status OUT NOCOPY VARCHAR2
225 ,x_msg_count OUT NOCOPY NUMBER
226 ,x_msg_data OUT NOCOPY VARCHAR2);
227
228 PROCEDURE removePreferedPartner (
229 p_api_version_number IN NUMBER
230 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
231 , p_commit IN VARCHAR2 := FND_API.G_FALSE
232 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
233 , p_lead_id IN NUMBER
234 , p_item_type IN VARCHAR2
235 , p_item_key IN VARCHAR2
236 , p_partner_id IN NUMBER
237 , x_return_status OUT NOCOPY VARCHAR2
238 , x_msg_count OUT NOCOPY NUMBER
239 , x_msg_data OUT NOCOPY VARCHAR2) ;
240
241
242 procedure checkforErrors (
243 p_api_version_number IN NUMBER
244 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
245 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
247 ,p_itemtype IN VARCHAR2
248 ,p_itemkey IN VARCHAR2
249 ,x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2);
252
253
254
255 End PV_ASSIGN_UTIL_PVT;