[Home] [Help]
PACKAGE: APPS.AS_SALES_LEADS_PKG
Source
1 PACKAGE AS_SALES_LEADS_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtslms.pls 115.20 2003/09/05 21:50:29 ckapoor ship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEADS_PKG
5 -- Purpose : Sales leads table handlers
6 -- NOTE :
7 -- History : 06/05/2000 FFANG Generated by Table Handler Generater.
8 -- 06/06/2000 FFANG Modified according to data schema
9 -- changes.
10 -- 06/20/2000 FFANG Correct sales__lead_line_id to
11 -- sales_lead_line_id
12 -- 06/21/2000 FFANG Modified according schema changes
13 --
14 -- End of Comments
15
16 PROCEDURE Sales_Lead_Insert_Row(
17 px_SALES_LEAD_ID IN OUT NOCOPY NUMBER,
18 p_LAST_UPDATE_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_CREATION_DATE DATE,
21 p_CREATED_BY NUMBER,
22 p_LAST_UPDATE_LOGIN NUMBER,
23 p_REQUEST_ID NUMBER,
24 p_PROGRAM_APPLICATION_ID NUMBER,
25 p_PROGRAM_ID NUMBER,
26 p_PROGRAM_UPDATE_DATE DATE,
27 p_LEAD_NUMBER VARCHAR2,
28 p_STATUS_CODE VARCHAR2,
29 p_CUSTOMER_ID NUMBER,
30 p_ADDRESS_ID NUMBER,
31 p_SOURCE_PROMOTION_ID NUMBER,
32 p_INITIATING_CONTACT_ID NUMBER,
33 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
34 p_CONTACT_ROLE_CODE VARCHAR2,
35 p_CHANNEL_CODE VARCHAR2,
36 p_BUDGET_AMOUNT NUMBER,
37 p_CURRENCY_CODE VARCHAR2,
38 p_DECISION_TIMEFRAME_CODE VARCHAR2,
39 p_CLOSE_REASON VARCHAR2,
40 p_LEAD_RANK_ID NUMBER,
41 p_LEAD_RANK_CODE VARCHAR2,
42 p_PARENT_PROJECT VARCHAR2,
43 p_DESCRIPTION VARCHAR2,
44 p_ATTRIBUTE_CATEGORY VARCHAR2,
45 p_ATTRIBUTE1 VARCHAR2,
46 p_ATTRIBUTE2 VARCHAR2,
47 p_ATTRIBUTE3 VARCHAR2,
48 p_ATTRIBUTE4 VARCHAR2,
49 p_ATTRIBUTE5 VARCHAR2,
50 p_ATTRIBUTE6 VARCHAR2,
51 p_ATTRIBUTE7 VARCHAR2,
52 p_ATTRIBUTE8 VARCHAR2,
53 p_ATTRIBUTE9 VARCHAR2,
54 p_ATTRIBUTE10 VARCHAR2,
55 p_ATTRIBUTE11 VARCHAR2,
56 p_ATTRIBUTE12 VARCHAR2,
57 p_ATTRIBUTE13 VARCHAR2,
58 p_ATTRIBUTE14 VARCHAR2,
59 p_ATTRIBUTE15 VARCHAR2,
60 p_ASSIGN_TO_PERSON_ID NUMBER,
61 p_ASSIGN_TO_SALESFORCE_ID NUMBER,
62 p_ASSIGN_SALES_GROUP_ID NUMBER,
63 p_ASSIGN_DATE DATE,
64 p_BUDGET_STATUS_CODE VARCHAR2,
65 p_ACCEPT_FLAG VARCHAR2,
66 p_VEHICLE_RESPONSE_CODE VARCHAR2,
67 p_TOTAL_SCORE NUMBER,
68 p_SCORECARD_ID NUMBER,
69 p_KEEP_FLAG VARCHAR2,
70 p_URGENT_FLAG VARCHAR2,
71 p_IMPORT_FLAG VARCHAR2,
72 p_REJECT_REASON_CODE VARCHAR2,
73 p_DELETED_FLAG VARCHAR2,
74 p_OFFER_ID NUMBER,
75 p_QUALIFIED_FLAG VARCHAR2,
76 p_ORIG_SYSTEM_CODE VARCHAR2,
77 -- p_SECURITY_GROUP_ID NUMBER,
78 p_INC_PARTNER_PARTY_ID NUMBER,
79 p_INC_PARTNER_RESOURCE_ID NUMBER,
80 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
81 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
82 p_PRM_SALES_LEAD_TYPE VARCHAR2,
83 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
84 p_PRM_ASSIGNMENT_TYPE VARCHAR2,
85 p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
86 p_PRIMARY_CONTACT_PARTY_ID NUMBER,
87 -- bug 2098158
88 p_PRIMARY_CNT_PERSON_PARTY_ID NUMBER,
89 p_PRIMARY_CONTACT_PHONE_ID NUMBER,
90
91 -- new columns for CAPRI lead referral
92
93 p_REFERRED_BY NUMBER,
94 p_REFERRAL_TYPE VARCHAR2,
95 p_REFERRAL_STATUS VARCHAR2,
96 p_REF_DECLINE_REASON VARCHAR2,
97 p_REF_COMM_LTR_STATUS VARCHAR2,
98 p_REF_ORDER_NUMBER NUMBER,
99 p_REF_ORDER_AMT NUMBER,
100 p_REF_COMM_AMT NUMBER,
101 -- bug No.2341515, 2368075
102 p_LEAD_DATE DATE ,
103 p_SOURCE_SYSTEM VARCHAR2,
104 p_COUNTRY VARCHAR2,
105 -- 11.5.9
106 p_TOTAL_AMOUNT NUMBER,
107 p_EXPIRATION_DATE DATE,
108 p_LEAD_RANK_IND VARCHAR2,
109 p_LEAD_ENGINE_RUN_DATE DATE,
110 p_CURRENT_REROUTES NUMBER
111
112 -- new columns for appsperf CRMAP denorm project bug 2928041
113
114 , p_STATUS_OPEN_FLAG VARCHAR2,
115 p_LEAD_RANK_SCORE NUMBER
116
117 -- 11.5.10 - ckapoor : new columns
118
119 , p_MARKETING_SCORE NUMBER
120 , p_INTERACTION_SCORE NUMBER
121 , p_SOURCE_PRIMARY_REFERENCE VARCHAR2
122 , p_SOURCE_SECONDARY_REFERENCE VARCHAR2
123 , p_SALES_METHODOLOGY_ID NUMBER
124 , p_SALES_STAGE_ID NUMBER
125
126 );
127
128
129 PROCEDURE Sales_Lead_Update_Row(
130 p_SALES_LEAD_ID NUMBER,
131 p_LAST_UPDATE_DATE DATE,
132 p_LAST_UPDATED_BY NUMBER,
133 p_CREATION_DATE DATE,
134 p_CREATED_BY NUMBER,
135 p_LAST_UPDATE_LOGIN NUMBER,
136 p_REQUEST_ID NUMBER,
137 p_PROGRAM_APPLICATION_ID NUMBER,
138 p_PROGRAM_ID NUMBER,
139 p_PROGRAM_UPDATE_DATE DATE,
140 p_LEAD_NUMBER VARCHAR2,
141 p_STATUS_CODE VARCHAR2,
142 p_CUSTOMER_ID NUMBER,
143 p_ADDRESS_ID NUMBER,
144 p_SOURCE_PROMOTION_ID NUMBER,
145 p_INITIATING_CONTACT_ID NUMBER,
146 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
147 p_CONTACT_ROLE_CODE VARCHAR2,
148 p_CHANNEL_CODE VARCHAR2,
149 p_BUDGET_AMOUNT NUMBER,
150 p_CURRENCY_CODE VARCHAR2,
151 p_DECISION_TIMEFRAME_CODE VARCHAR2,
152 p_CLOSE_REASON VARCHAR2,
153 p_LEAD_RANK_ID NUMBER,
154 p_LEAD_RANK_CODE VARCHAR2,
155 p_PARENT_PROJECT VARCHAR2,
156 p_DESCRIPTION VARCHAR2,
157 p_ATTRIBUTE_CATEGORY VARCHAR2,
158 p_ATTRIBUTE1 VARCHAR2,
159 p_ATTRIBUTE2 VARCHAR2,
160 p_ATTRIBUTE3 VARCHAR2,
161 p_ATTRIBUTE4 VARCHAR2,
162 p_ATTRIBUTE5 VARCHAR2,
163 p_ATTRIBUTE6 VARCHAR2,
164 p_ATTRIBUTE7 VARCHAR2,
165 p_ATTRIBUTE8 VARCHAR2,
166 p_ATTRIBUTE9 VARCHAR2,
167 p_ATTRIBUTE10 VARCHAR2,
168 p_ATTRIBUTE11 VARCHAR2,
169 p_ATTRIBUTE12 VARCHAR2,
170 p_ATTRIBUTE13 VARCHAR2,
171 p_ATTRIBUTE14 VARCHAR2,
172 p_ATTRIBUTE15 VARCHAR2,
173 p_ASSIGN_TO_PERSON_ID NUMBER,
174 p_ASSIGN_TO_SALESFORCE_ID NUMBER,
175 p_ASSIGN_SALES_GROUP_ID NUMBER,
176 p_ASSIGN_DATE DATE,
177 p_BUDGET_STATUS_CODE VARCHAR2,
178 p_ACCEPT_FLAG VARCHAR2,
179 p_VEHICLE_RESPONSE_CODE VARCHAR2,
180 p_TOTAL_SCORE NUMBER,
181 p_SCORECARD_ID NUMBER,
182 p_KEEP_FLAG VARCHAR2,
183 p_URGENT_FLAG VARCHAR2,
184 p_IMPORT_FLAG VARCHAR2,
185 p_REJECT_REASON_CODE VARCHAR2,
186 p_DELETED_FLAG VARCHAR2,
187 p_OFFER_ID NUMBER,
188 p_QUALIFIED_FLAG VARCHAR2,
189 p_ORIG_SYSTEM_CODE VARCHAR2,
190 -- p_SECURITY_GROUP_ID NUMBER,
191 p_INC_PARTNER_PARTY_ID NUMBER,
192 p_INC_PARTNER_RESOURCE_ID NUMBER,
193 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
194 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
195 p_PRM_SALES_LEAD_TYPE VARCHAR2,
196 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
197 p_PRM_ASSIGNMENT_TYPE VARCHAR2,
198 p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
199 p_PRIMARY_CONTACT_PARTY_ID NUMBER,
200 -- bug 2098158
201 p_PRIMARY_CNT_PERSON_PARTY_ID NUMBER,
202 p_PRIMARY_CONTACT_PHONE_ID NUMBER,
203
204 -- new columns for CAPRI lead referral
205
206 p_REFERRED_BY NUMBER,
207 p_REFERRAL_TYPE VARCHAR2,
208 p_REFERRAL_STATUS VARCHAR2,
209 p_REF_DECLINE_REASON VARCHAR2,
210 p_REF_COMM_LTR_STATUS VARCHAR2,
211 p_REF_ORDER_NUMBER NUMBER,
212 p_REF_ORDER_AMT NUMBER,
213 p_REF_COMM_AMT NUMBER,
214 -- bug No.2341515, 2368075
215 p_LEAD_DATE DATE ,
216 p_SOURCE_SYSTEM VARCHAR2,
217 p_COUNTRY VARCHAR2,
218 -- 11.5.9
219 p_TOTAL_AMOUNT NUMBER,
220 p_EXPIRATION_DATE DATE,
221 p_LEAD_RANK_IND VARCHAR2,
222 p_LEAD_ENGINE_RUN_DATE DATE,
223 p_CURRENT_REROUTES NUMBER
224
225 -- new columns for appsperf CRMAP denorm project bug 2928041
226
227 , p_STATUS_OPEN_FLAG VARCHAR2,
228 p_LEAD_RANK_SCORE NUMBER
229
230 -- 11.5.10 - ckapoor : new columns
231
232 , p_MARKETING_SCORE NUMBER
233 , p_INTERACTION_SCORE NUMBER
234 , p_SOURCE_PRIMARY_REFERENCE VARCHAR2
235 , p_SOURCE_SECONDARY_REFERENCE VARCHAR2
236 , p_SALES_METHODOLOGY_ID NUMBER
237 , p_SALES_STAGE_ID NUMBER
238
239
240
241
242
243 );
244
245
246 PROCEDURE Sales_Lead_Lock_Row(
247 p_SALES_LEAD_ID NUMBER,
248 p_LAST_UPDATE_DATE DATE,
249 p_LAST_UPDATED_BY NUMBER,
250 p_CREATION_DATE DATE,
251 p_CREATED_BY NUMBER,
252 p_LAST_UPDATE_LOGIN NUMBER,
253 p_REQUEST_ID NUMBER,
254 p_PROGRAM_APPLICATION_ID NUMBER,
255 p_PROGRAM_ID NUMBER,
256 p_PROGRAM_UPDATE_DATE DATE,
257 p_LEAD_NUMBER VARCHAR2,
258 p_STATUS_CODE VARCHAR2,
259 p_CUSTOMER_ID NUMBER,
260 p_ADDRESS_ID NUMBER,
261 p_SOURCE_PROMOTION_ID NUMBER,
262 p_INITIATING_CONTACT_ID NUMBER,
263 p_ORIG_SYSTEM_REFERENCE VARCHAR2,
264 p_CONTACT_ROLE_CODE VARCHAR2,
265 p_CHANNEL_CODE VARCHAR2,
266 p_BUDGET_AMOUNT NUMBER,
267 p_CURRENCY_CODE VARCHAR2,
268 p_DECISION_TIMEFRAME_CODE VARCHAR2,
269 p_CLOSE_REASON VARCHAR2,
270 p_LEAD_RANK_ID NUMBER,
271 p_LEAD_RANK_CODE VARCHAR2,
272 p_PARENT_PROJECT VARCHAR2,
273 p_DESCRIPTION VARCHAR2,
274 p_ATTRIBUTE_CATEGORY VARCHAR2,
275 p_ATTRIBUTE1 VARCHAR2,
276 p_ATTRIBUTE2 VARCHAR2,
277 p_ATTRIBUTE3 VARCHAR2,
278 p_ATTRIBUTE4 VARCHAR2,
279 p_ATTRIBUTE5 VARCHAR2,
280 p_ATTRIBUTE6 VARCHAR2,
281 p_ATTRIBUTE7 VARCHAR2,
282 p_ATTRIBUTE8 VARCHAR2,
283 p_ATTRIBUTE9 VARCHAR2,
284 p_ATTRIBUTE10 VARCHAR2,
285 p_ATTRIBUTE11 VARCHAR2,
286 p_ATTRIBUTE12 VARCHAR2,
287 p_ATTRIBUTE13 VARCHAR2,
288 p_ATTRIBUTE14 VARCHAR2,
289 p_ATTRIBUTE15 VARCHAR2,
290 p_ASSIGN_TO_PERSON_ID NUMBER,
291 p_ASSIGN_TO_SALESFORCE_ID NUMBER,
292 p_ASSIGN_SALES_GROUP_ID NUMBER,
293 p_ASSIGN_DATE DATE,
294 p_BUDGET_STATUS_CODE VARCHAR2,
295 p_ACCEPT_FLAG VARCHAR2,
296 p_VEHICLE_RESPONSE_CODE VARCHAR2,
297 p_TOTAL_SCORE NUMBER,
298 p_SCORECARD_ID NUMBER,
299 p_KEEP_FLAG VARCHAR2,
300 p_URGENT_FLAG VARCHAR2,
301 p_IMPORT_FLAG VARCHAR2,
302 p_REJECT_REASON_CODE VARCHAR2,
303 p_DELETED_FLAG VARCHAR2,
304 p_OFFER_ID NUMBER,
305 p_QUALIFIED_FLAG VARCHAR2,
306 p_ORIG_SYSTEM_CODE VARCHAR2,
307 -- p_SECURITY_GROUP_ID NUMBER,
308 p_INC_PARTNER_PARTY_ID NUMBER,
309 p_INC_PARTNER_RESOURCE_ID NUMBER,
310 p_PRM_EXEC_SPONSOR_FLAG VARCHAR2,
311 p_PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2,
312 p_PRM_SALES_LEAD_TYPE VARCHAR2,
313 p_PRM_IND_CLASSIFICATION_CODE VARCHAR2,
314 p_PRM_ASSIGNMENT_TYPE VARCHAR2,
315 p_AUTO_ASSIGNMENT_TYPE VARCHAR2,
316 p_PRIMARY_CONTACT_PARTY_ID NUMBER,
317 -- bug 2098158
318 p_PRIMARY_CNT_PERSON_PARTY_ID NUMBER,
319 p_PRIMARY_CONTACT_PHONE_ID NUMBER,
320 -- new columns for CAPRI lead referral
321
322 p_REFERRED_BY NUMBER,
323 p_REFERRAL_TYPE VARCHAR2,
324 p_REFERRAL_STATUS VARCHAR2,
325 p_REF_DECLINE_REASON VARCHAR2,
326 p_REF_COMM_LTR_STATUS VARCHAR2,
327 p_REF_ORDER_NUMBER NUMBER,
328 p_REF_ORDER_AMT NUMBER,
329 p_REF_COMM_AMT NUMBER,
330 -- bug No.2341515, 2368075
331 p_LEAD_DATE DATE ,
332 p_SOURCE_SYSTEM VARCHAR2,
333 p_COUNTRY VARCHAR2,
334 -- 11.5.9
335 p_TOTAL_AMOUNT NUMBER,
336 p_EXPIRATION_DATE DATE,
337 p_LEAD_RANK_IND VARCHAR2,
338 p_LEAD_ENGINE_RUN_DATE DATE,
339 p_CURRENT_REROUTES NUMBER
340
341 -- new columns for appsperf CRMAP denorm project bug 2928041
342
343 , p_STATUS_OPEN_FLAG VARCHAR2,
344 p_LEAD_RANK_SCORE NUMBER
345
346 -- 11.5.10 - ckapoor : new columns
347
348 , p_MARKETING_SCORE NUMBER
349 , p_INTERACTION_SCORE NUMBER
350 , p_SOURCE_PRIMARY_REFERENCE VARCHAR2
351 , p_SOURCE_SECONDARY_REFERENCE VARCHAR2
352 , p_SALES_METHODOLOGY_ID NUMBER
353 , p_SALES_STAGE_ID NUMBER
354
355
356
357
358 );
359
360
361
362 End AS_SALES_LEADS_PKG;