1 PACKAGE AS_OPPORTUNITY_PUB as
2 /* $Header: asxpopps.pls 120.5 2006/07/26 11:12:15 mohali ship $ */
3 /*#
4 * This is a public interface for all the opportunity related functions.
5 * These APIs provide a number of procedures for Opportunity and its sub-entities
6 * including Opportunity Contacts, Product Lines, Sales Credits, Competitor
7 * Products, Decision Factors and Opportunity Obstacles.
8 *
9 * <p>
10 *<B>Standard IN parameters:</B> The following list describes the standard IN parameters
11 * which are common to all APIs provided by Oracle Sales products.
12 * <ul><li>p_api_version: The p_api_version parameter has no default value. Therefore, all API
13 * callers must pass it in their calls. This parameter is used by the API to
14 * compare the version numbers of incoming calls to its current version number,
15 * and to return an unexpected error if they are incompatible. Pass 2.0 unless
16 * otherwise indicated in the API parameter list.</li>
17 * <li>p_init_msg_list: Default = FND_API.G_FALSE. The p_init_msg_list
18 * parameter allows API callers to request the API to do the initialization of
19 * the message list on their behalf.</li>
20 * <li>p_commit: Default = FND_API.G_FALSE. The p_commit parameter is used by API
21 * callers to ask the API to do a commit on their behalf after performing its
22 * function.</li>
23 * <li>p_validation_level: Default = FND_API.G_VALID_LEVEL_FULL. This parameter
24 * should always be set to FND_API.G_VALID_LEVEL_FULL to ensure that valid data
25 * is saved in the database.</li>
26 * <li>p_check_access_flag: Standard parameter for opportunity and access APIs only.
27 * The p_check_access_flag parameter allows API callers to request that the API
28 * does the application security check on their behalf. We strongly recommend that
29 * you always pass "Y" to the opportunity and access APIs to ensure that the application
30 * data is processed with security control.</li>
31 * <li>p_admin_flag: Standard parameter for opportunity and access APIs only.
32 * This p_admin_flag parameter tells the API if the logged in user is an administrator.</li>
33 * <li>p_admin_group_id: Standard parameter for opportunity and access APIs only.
34 * This parameter passes the administrator sales group ID of the logged in user if the
35 * user is an administrator.</li>
36 * <li>p_identity_salesforce_id: Standard parameter for opportunity and access APIs
37 * only. This parameter passes the resource identifier of the logged in user.</li>
38 * <li>p_profile_tbl: This parameter is not used currently.</li></ul></p>
39 *
40 * <p>
41 * <B>Standard OUT parameters:</B> The following list describes standard OUT parameters
42 * which are common to all public APIs provided by Oracle Sales products.
43 * <ul><li>x_return_status: Indicates the return status of the API. The values returned
44 * are one of the following:
45 * <ul><li> FND_API.G_RET_STS_SUCCESS- indicates that the API call
46 * was successful. </li>
47 * <li>FND_API.G_RET_STS_ERROR- indicates that there was a validation error
48 * or a missing data error.</li>
49 * <li>FND_API.G_RET_STS_UNEXP_ ERROR- indicates that the calling
50 * program encountered an unexpected or unhandled error.</li></ul></li>
51 * <li>x_msg_count: Holds the number of messages in the message list. Refer to the FND_MSG_PUB
52 * API documentation for more information about how to retrieve messages from the message
53 * stack.</li>
54 * <li>x_msg_data: Error message returned by the API. If the number of messages returned is
55 * more than one, this parameter will be null and the messages must be extracted
56 * from the message stack.</li></ul></p>
57 *
58 * Note: <I>All standard OUT parameters are required parameter specifications.</I>
59 *
60 * @rep:scope public
61 * @rep:product AS
62 * @rep:displayname Opportunity Public APIs
63 * @rep:lifecycle active
64 * @rep:category BUSINESS_ENTITY AS_OPPORTUNITY
65 */
66
67 -- Start of Comments
68 --
69 -- NAME
70 -- AS_OPPORTUNITY_PUB
71 --
72 --
73
74 --
75 -- Opportunity Header Type
76 --
77
78 TYPE header_rec_type IS RECORD
79 ( last_update_date Date := FND_API.G_MISS_DATE,
80 last_updated_by Number := FND_API.G_MISS_NUM,
81 creation_Date Date := FND_API.G_MISS_DATE,
82 created_by Number := FND_API.G_MISS_NUM,
83 last_update_login Number := FND_API.G_MISS_NUM,
84 request_id NUMBER := FND_API.G_MISS_NUM,
85 program_application_id NUMBER := FND_API.G_MISS_NUM,
86 program_id NUMBER := FND_API.G_MISS_NUM,
87 program_update_date DATE := FND_API.G_MISS_DATE,
88 lead_id NUMBER := FND_API.G_MISS_NUM,
89 lead_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
90 orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
91 lead_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92 lead_source VARCHAR2(80) := FND_API.G_MISS_CHAR,
93 description VARCHAR2(240) := FND_API.G_MISS_CHAR,
94 source_promotion_id NUMBER := FND_API.G_MISS_NUM,
95 source_promotion_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
96 customer_id NUMBER := FND_API.G_MISS_NUM,
97 customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
98 customer_name_phonetic VARCHAR2(360) := FND_API.G_MISS_CHAR,
99 address_id NUMBER := FND_API.G_MISS_NUM,
100 address VARCHAR2(240) := FND_API.G_MISS_CHAR,
101 address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
102 address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
103 address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
104 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
105 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
106 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
107 province VARCHAR2(60) := FND_API.G_MISS_CHAR,
108 sales_stage_id NUMBER := FND_API.G_MISS_NUM,
109 sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
110 win_probability NUMBER := FND_API.G_MISS_NUM,
111 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
112 status VARCHAR2(240) := FND_API.G_MISS_CHAR,
113 total_amount NUMBER := FND_API.G_MISS_NUM,
114 converted_total_amount NUMBER := FND_API.G_MISS_NUM,
115 channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
116 channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
117 decision_date DATE := FND_API.G_MISS_DATE,
118 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
119 to_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
120 close_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
121 close_reason VARCHAR2(80) := FND_API.G_MISS_CHAR,
122 close_competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
123 close_competitor_id NUMBER := FND_API.G_MISS_NUM,
124 close_competitor VARCHAR2(360) := FND_API.G_MISS_CHAR,
125 close_comment VARCHAR2(240) := FND_API.G_MISS_CHAR,
126 end_user_customer_id NUMBER := FND_API.G_MISS_NUM,
127 end_user_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
128 end_user_address_id NUMBER := FND_API.G_MISS_NUM,
129 owner_salesforce_id NUMBER := FND_API.G_MISS_NUM,
130 owner_sales_group_id NUMBER := FND_API.G_MISS_NUM,
131 -- owner_assign_date DATE := FND_API.G_MISS_DATE,
132 parent_project VARCHAR2(80) := FND_API.G_MISS_CHAR,
133 parent_project_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
134 updateable_flag VARCHAR2(1) := 'N',
135 price_list_id Number := FND_API.G_MISS_NUM,
136 initiating_contact_id Number := FND_API.G_MISS_NUM,
137 rank Varchar2(30) := FND_API.G_MISS_CHAR,
138 member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
139 member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
140 Deleted_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
141 Auto_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
142 PRM_Assignment_Type VARCHAR2(30) := FND_API.G_MISS_CHAR,
143 Customer_budget NUMBER := FND_API.G_MISS_NUM,
144 Methodology_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
145 Sales_Methodology_Id NUMBER := FND_API.G_MISS_NUM,
146 Original_Lead_Id NUMBER := FND_API.G_MISS_NUM,
147 Decision_Timeframe_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
148 Incumbent_partner_Resource_Id NUMBER := FND_API.G_MISS_NUM,
149 Incumbent_partner_Party_Id NUMBER := FND_API.G_MISS_NUM,
150 Offer_Id NUMBER := FND_API.G_MISS_NUM,
151 Vehicle_Response_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152 Budget_Status_Code VARCHAR2(30) := FND_API.G_MISS_CHAR,
153 FOLLOWUP_DATE DATE := FND_API.G_MISS_DATE,
154 NO_OPP_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
155 DELETE_ALLOWED_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
156 PRM_EXEC_SPONSOR_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
157 PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
158 PRM_IND_CLASSIFICATION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
159 PRM_LEAD_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
160 ORG_ID NUMBER := FND_API.G_MISS_NUM,
161 freeze_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
162 attribute_category VARCHAR2(30),
163 attribute1 VARCHAR2(150),
164 attribute2 VARCHAR2(150),
165 attribute3 VARCHAR2(150),
166 attribute4 VARCHAR2(150),
167 attribute5 VARCHAR2(150),
168 attribute6 VARCHAR2(150),
169 attribute7 VARCHAR2(150),
170 attribute8 VARCHAR2(150),
171 attribute9 VARCHAR2(150),
172 attribute10 VARCHAR2(150),
173 attribute11 VARCHAR2(150),
174 attribute12 VARCHAR2(150),
175 attribute13 VARCHAR2(150),
176 attribute14 VARCHAR2(150),
177 attribute15 VARCHAR2(150),
178 PRM_REFERRAL_CODE VARCHAR2(50) := FND_API.G_MISS_CHAR,
179 TOTAL_REVENUE_OPP_FORECAST_AMT NUMBER := FND_API.G_MISS_NUM -- Added for ASNB
180 );
181
182 G_MISS_HEADER_REC header_rec_type;
183 TYPE header_tbl_type IS TABLE OF header_rec_type
184 INDEX BY BINARY_INTEGER;
185 G_MISS_HEADER_TBL header_tbl_type;
186
187
188
189 --
190 -- Opportunity Line Record Type
191 --
192
193 TYPE line_rec_type IS RECORD
194 ( last_update_date Date := FND_API.G_MISS_DATE,
195 last_updated_by Number := FND_API.G_MISS_NUM,
196 creation_Date Date := FND_API.G_MISS_DATE,
197 created_by Number := FND_API.G_MISS_NUM,
198 last_update_login Number := FND_API.G_MISS_NUM,
199 request_id NUMBER := FND_API.G_MISS_NUM,
200 program_application_id NUMBER := FND_API.G_MISS_NUM,
201 program_id NUMBER := FND_API.G_MISS_NUM,
202 program_update_date DATE := FND_API.G_MISS_DATE,
203 lead_id NUMBER := FND_API.G_MISS_NUM,
204 lead_line_id NUMBER := FND_API.G_MISS_NUM,
205 original_lead_line_id NUMBER := FND_API.G_MISS_NUM,
206 interest_type_id NUMBER := FND_API.G_MISS_NUM,
207 interest_type VARCHAR2(80) := FND_API.G_MISS_CHAR,
208 interest_status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
209 primary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
210 primary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
211 secondary_interest_code_id NUMBER := FND_API.G_MISS_NUM,
212 secondary_interest_code VARCHAR2(100) := FND_API.G_MISS_CHAR,
213 inventory_item_id NUMBER := FND_API.G_MISS_NUM,
214 inventory_item_conc_segs VARCHAR2(2000) := FND_API.G_MISS_CHAR,
215 organization_id NUMBER := FND_API.G_MISS_NUM,
216 uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
217 uom VARCHAR2(25) := FND_API.G_MISS_CHAR,
218 quantity NUMBER := FND_API.G_MISS_NUM,
219 ship_date DATE := FND_API.G_MISS_DATE,
220 total_amount NUMBER := FND_API.G_MISS_NUM,
221 sales_stage_id NUMBER := FND_API.G_MISS_NUM,
222 sales_stage VARCHAR2(60) := FND_API.G_MISS_CHAR,
223 win_probability NUMBER := FND_API.G_MISS_NUM,
224 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
225 status VARCHAR2(80) := FND_API.G_MISS_CHAR,
226 decision_date DATE := FND_API.G_MISS_DATE,
227 channel_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
228 channel VARCHAR2(80) := FND_API.G_MISS_CHAR,
229 unit_price Number := FND_API.G_MISS_NUM,
230 price Number := FND_API.G_MISS_NUM,
231 price_volume_margin Number := FND_API.G_MISS_NUM,
232 quoted_line_flag Varchar(1) := FND_API.G_MISS_CHAR,
233 member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
234 member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
235 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
236 owner_scredit_percent NUMBER := FND_API.G_MISS_NUM,
237 Source_Promotion_Id NUMBER := FND_API.G_MISS_NUM,
238 forecast_date DATE := FND_API.G_MISS_DATE,
239 rolling_forecast_flag Varchar(1) := FND_API.G_MISS_CHAR,
240 Offer_Id NUMBER := FND_API.G_MISS_NUM,
241 ORG_ID NUMBER := FND_API.G_MISS_NUM,
242 product_category_id NUMBER := FND_API.G_MISS_NUM,
243 product_cat_set_id NUMBER := FND_API.G_MISS_NUM,
244 attribute_category VARCHAR2(30),
245 attribute1 VARCHAR2(150),
246 attribute2 VARCHAR2(150),
247 attribute3 VARCHAR2(150),
248 attribute4 VARCHAR2(150),
249 attribute5 VARCHAR2(150),
250 attribute6 VARCHAR2(150),
251 attribute7 VARCHAR2(150),
252 attribute8 VARCHAR2(150),
253 attribute9 VARCHAR2(150),
254 attribute10 VARCHAR2(150),
255 attribute11 VARCHAR2(150),
256 attribute12 VARCHAR2(150),
257 attribute13 VARCHAR2(150),
258 attribute14 VARCHAR2(150),
259 attribute15 VARCHAR2(150),
260 opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
261 opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
262 opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM
263 );
264
265 G_MISS_LINE_REC line_rec_type;
266 TYPE line_tbl_type IS TABLE OF line_rec_type
267 INDEX BY BINARY_INTEGER;
268 G_MISS_LINE_TBL line_tbl_type;
269
270 TYPE line_out_rec_type IS RECORD
271 (
272 lead_line_id NUMBER,
273 return_status VARCHAR2(1)
274 );
275 TYPE line_out_tbl_type IS TABLE OF line_out_rec_type
276 INDEX BY BINARY_INTEGER;
277
278
279 --
280 -- Sales Credit Record Type
281 --
282
283 TYPE sales_credit_rec_type IS RECORD
284 ( last_update_date Date := FND_API.G_MISS_DATE,
285 last_updated_by Number := FND_API.G_MISS_NUM,
286 creation_Date Date := FND_API.G_MISS_DATE,
287 created_by Number := FND_API.G_MISS_NUM,
288 last_update_login Number := FND_API.G_MISS_NUM,
289 request_id NUMBER := FND_API.G_MISS_NUM,
290 program_application_id NUMBER := FND_API.G_MISS_NUM,
291 program_id NUMBER := FND_API.G_MISS_NUM,
292 program_update_date DATE := FND_API.G_MISS_DATE,
293 sales_credit_id NUMBER := FND_API.G_MISS_NUM,
294 original_sales_credit_id NUMBER := FND_API.G_MISS_NUM,
295 lead_id NUMBER := FND_API.G_MISS_NUM,
296 lead_line_id NUMBER := FND_API.G_MISS_NUM,
297 salesforce_id NUMBER := FND_API.G_MISS_NUM,
298 person_id NUMBER := FND_API.G_MISS_NUM,
299 employee_last_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
300 employee_first_name VARCHAR2(20) := FND_API.G_MISS_CHAR,
301 salesgroup_id NUMBER := FND_API.G_MISS_NUM,
302 salesgroup_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
303 partner_customer_id NUMBER := FND_API.G_MISS_NUM,
304 partner_customer_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
305 partner_city VARCHAR2(60) := FND_API.G_MISS_CHAR,
306 partner_address_id NUMBER := FND_API.G_MISS_NUM,
307 revenue_amount NUMBER := FND_API.G_MISS_NUM,
308 revenue_percent NUMBER := FND_API.G_MISS_NUM,
309 quota_credit_amount NUMBER := FND_API.G_MISS_NUM,
310 quota_credit_percent NUMBER := FND_API.G_MISS_NUM,
311 revenue_derived_col NUMBER := FND_API.G_MISS_NUM,
312 quota_derived_col NUMBER := FND_API.G_MISS_NUM,
313 member_access VARCHAR2(1) := FND_API.G_MISS_CHAR,
314 member_role VARCHAR2(1) := FND_API.G_MISS_CHAR,
315 MANAGER_REVIEW_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
316 MANAGER_REVIEW_DATE DATE := FND_API.G_MISS_DATE,
317 line_tbl_index NUMBER := NULL,
318 delete_flag VARCHAR2(10) := FND_API.G_FALSE,
319 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
320 credit_type_id NUMBER := FND_API.G_MISS_NUM,
321 credit_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
322 credit_amount NUMBER := FND_API.G_MISS_NUM,
323 credit_percent NUMBER := FND_API.G_MISS_NUM,
324 ORG_ID NUMBER := FND_API.G_MISS_NUM,
325 attribute_category VARCHAR2(30),
326 attribute1 VARCHAR2(150),
327 attribute2 VARCHAR2(150),
328 attribute3 VARCHAR2(150),
329 attribute4 VARCHAR2(150),
330 attribute5 VARCHAR2(150),
331 attribute6 VARCHAR2(150),
332 attribute7 VARCHAR2(150),
333 attribute8 VARCHAR2(150),
334 attribute9 VARCHAR2(150),
335 attribute10 VARCHAR2(150),
336 attribute11 VARCHAR2(150),
337 attribute12 VARCHAR2(150),
338 attribute13 VARCHAR2(150),
339 attribute14 VARCHAR2(150),
340 attribute15 VARCHAR2(150),
341 opp_worst_forecast_amount NUMBER := FND_API.G_MISS_NUM,
342 opp_forecast_amount NUMBER := FND_API.G_MISS_NUM,
343 opp_best_forecast_amount NUMBER := FND_API.G_MISS_NUM,
344 defaulted_from_owner_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for ASNB
345 );
346
347 G_MISS_SALES_CREDIT_REC sales_credit_rec_type;
348 TYPE sales_credit_tbl_type IS TABLE OF sales_credit_rec_type
349 INDEX BY BINARY_INTEGER;
350 G_MISS_SALES_CREDIT_TBL sales_credit_tbl_type;
351
352 TYPE sales_credit_out_rec_type IS RECORD
353 (
354 sales_credit_id NUMBER,
355 return_status VARCHAR2(1)
356 );
357 TYPE sales_credit_out_tbl_type IS TABLE OF sales_credit_out_rec_type
358 INDEX BY BINARY_INTEGER;
359
360
361 G_PERCENT_COLUMN CONSTANT NUMBER := 1;
362 G_AMOUNT_COLUMN CONSTANT NUMBER := 2;
363
364 --
365 -- Obstacle Record Type
366 --
367
368 TYPE obstacle_rec_type IS RECORD
369 ( last_update_date Date := FND_API.G_MISS_DATE,
370 last_updated_by Number := FND_API.G_MISS_NUM,
371 creation_Date Date := FND_API.G_MISS_DATE,
372 created_by Number := FND_API.G_MISS_NUM,
373 last_update_login Number := FND_API.G_MISS_NUM,
374 request_id NUMBER := FND_API.G_MISS_NUM,
375 program_application_id NUMBER := FND_API.G_MISS_NUM,
376 program_id NUMBER := FND_API.G_MISS_NUM,
377 program_update_date DATE := FND_API.G_MISS_DATE,
378 lead_obstacle_id NUMBER := FND_API.G_MISS_NUM,
379 lead_id NUMBER := FND_API.G_MISS_NUM,
380 obstacle_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
381 obstacle VARCHAR2(80) := FND_API.G_MISS_CHAR,
382 obstacle_status VARCHAR2(80) := FND_API.G_MISS_CHAR,
383 comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
384 member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
385 member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
386 ORG_ID NUMBER := FND_API.G_MISS_NUM,
387 attribute_category VARCHAR2(30),
388 attribute1 VARCHAR2(150),
389 attribute2 VARCHAR2(150),
390 attribute3 VARCHAR2(150),
391 attribute4 VARCHAR2(150),
392 attribute5 VARCHAR2(150),
393 attribute6 VARCHAR2(150),
394 attribute7 VARCHAR2(150),
395 attribute8 VARCHAR2(150),
396 attribute9 VARCHAR2(150),
397 attribute10 VARCHAR2(150),
398 attribute11 VARCHAR2(150),
399 attribute12 VARCHAR2(150),
400 attribute13 VARCHAR2(150),
401 attribute14 VARCHAR2(150),
402 attribute15 VARCHAR2(150)
403 );
404
405 G_MISS_OBSTACLE_REC obstacle_rec_type;
406 TYPE obstacle_tbl_type IS TABLE OF obstacle_rec_type
407 INDEX BY BINARY_INTEGER;
408 G_MISS_OBSTACLE_TBL obstacle_tbl_type;
409
410 TYPE obstacle_out_rec_type IS RECORD
411 (
412 lead_obstacle_id NUMBER,
413 return_status VARCHAR2(1)
414 );
415 TYPE obstacle_out_tbl_type IS TABLE OF obstacle_out_rec_type
416 INDEX BY BINARY_INTEGER;
417
418 --
419 -- Competitor Record Type
420 --
421
422 TYPE competitor_rec_type IS RECORD
423 ( last_update_date Date := FND_API.G_MISS_DATE,
424 last_updated_by Number := FND_API.G_MISS_NUM,
425 creation_Date Date := FND_API.G_MISS_DATE,
426 created_by Number := FND_API.G_MISS_NUM,
427 last_update_login Number := FND_API.G_MISS_NUM,
428 request_id NUMBER := FND_API.G_MISS_NUM,
429 program_application_id NUMBER := FND_API.G_MISS_NUM,
430 program_id NUMBER := FND_API.G_MISS_NUM,
431 program_update_date DATE := FND_API.G_MISS_DATE,
432 lead_competitor_id NUMBER := FND_API.G_MISS_NUM,
433 competitor_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
434 competitor_id NUMBER := FND_API.G_MISS_NUM,
435 relationship_party_id NUMBER := FND_API.G_MISS_NUM,
436 lead_id NUMBER := FND_API.G_MISS_NUM,
437 competitor VARCHAR2(80) := FND_API.G_MISS_CHAR,
438 competitor_meaning VARCHAR2(240) := FND_API.G_MISS_CHAR,
439 competitor_rank NUMBER := FND_API.G_MISS_NUM,
440 win_loss_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
441 products VARCHAR2(80) := FND_API.G_MISS_CHAR,
442 comments VARCHAR2(240) := FND_API.G_MISS_CHAR,
443 member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
444 member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
445 ORG_ID NUMBER := FND_API.G_MISS_NUM,
446 attribute_category VARCHAR2(30),
447 attribute1 VARCHAR2(150),
448 attribute2 VARCHAR2(150),
449 attribute3 VARCHAR2(150),
450 attribute4 VARCHAR2(150),
451 attribute5 VARCHAR2(150),
452 attribute6 VARCHAR2(150),
453 attribute7 VARCHAR2(150),
454 attribute8 VARCHAR2(150),
455 attribute9 VARCHAR2(150),
456 attribute10 VARCHAR2(150),
457 attribute11 VARCHAR2(150),
458 attribute12 VARCHAR2(150),
459 attribute13 VARCHAR2(150),
460 attribute14 VARCHAR2(150),
461 attribute15 VARCHAR2(150)
462 );
463
464 G_MISS_COMPETITOR_REC competitor_rec_type;
465 TYPE competitor_tbl_type IS TABLE OF competitor_rec_type
466 INDEX BY BINARY_INTEGER;
467 G_MISS_COMPETITOR_TBL competitor_tbl_type;
468
469 TYPE competitor_out_rec_type IS RECORD
470 (
471 lead_competitor_id NUMBER,
472 return_status VARCHAR2(1)
473 );
474 TYPE competitor_out_tbl_type IS TABLE OF competitor_out_rec_type
475 INDEX BY BINARY_INTEGER;
476
477 --
478 -- Order Record Type
479 --
480
481 TYPE order_rec_type IS RECORD
482 ( last_update_date Date := FND_API.G_MISS_DATE,
483 last_updated_by Number := FND_API.G_MISS_NUM,
484 creation_Date Date := FND_API.G_MISS_DATE,
485 created_by Number := FND_API.G_MISS_NUM,
486 last_update_login Number := FND_API.G_MISS_NUM,
487 request_id NUMBER := FND_API.G_MISS_NUM,
488 program_application_id NUMBER := FND_API.G_MISS_NUM,
489 program_id NUMBER := FND_API.G_MISS_NUM,
490 program_update_date DATE := FND_API.G_MISS_DATE,
491 lead_order_id NUMBER := FND_API.G_MISS_NUM,
492 lead_id NUMBER := FND_API.G_MISS_NUM,
493 order_number NUMBER := FND_API.G_MISS_NUM,
494 order_header_id NUMBER := FND_API.G_MISS_NUM,
495 date_ordered Date := FND_API.G_MISS_DATE,
496 order_type_id Number := FND_API.G_MISS_NUM,
497 order_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
498 currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
499 order_amount NUMBER := FND_API.G_MISS_NUM,
500 member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
501 member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
502 ORG_ID NUMBER := FND_API.G_MISS_NUM,
503 attribute_category VARCHAR2(30),
504 attribute1 VARCHAR2(150),
505 attribute2 VARCHAR2(150),
506 attribute3 VARCHAR2(150),
507 attribute4 VARCHAR2(150),
508 attribute5 VARCHAR2(150),
509 attribute6 VARCHAR2(150),
510 attribute7 VARCHAR2(150),
511 attribute8 VARCHAR2(150),
512 attribute9 VARCHAR2(150),
513 attribute10 VARCHAR2(150),
514 attribute11 VARCHAR2(150),
515 attribute12 VARCHAR2(150),
516 attribute13 VARCHAR2(150),
517 attribute14 VARCHAR2(150),
518 attribute15 VARCHAR2(150)
519 );
520
521 G_MISS_ORDER_REC order_rec_type;
522 TYPE order_tbl_type IS TABLE OF order_rec_type
523 INDEX BY BINARY_INTEGER;
524 G_MISS_ORDER_TBL order_tbl_type;
525
526 TYPE order_out_rec_type IS RECORD
527 (
528 lead_order_id NUMBER,
529 return_status VARCHAR2(1)
530 );
531 TYPE order_out_tbl_type IS TABLE OF order_out_rec_type
532 INDEX BY BINARY_INTEGER;
533
534 --
535 -- Contact Record Type
536 --
537
538 TYPE contact_rec_type IS RECORD
539 ( last_update_date Date := FND_API.G_MISS_DATE,
540 last_updated_by Number := FND_API.G_MISS_NUM,
541 creation_Date Date := FND_API.G_MISS_DATE,
542 created_by Number := FND_API.G_MISS_NUM,
543 last_update_login Number := FND_API.G_MISS_NUM,
544 request_id NUMBER := FND_API.G_MISS_NUM,
545 program_application_id NUMBER := FND_API.G_MISS_NUM,
546 program_id NUMBER := FND_API.G_MISS_NUM,
547 program_update_date DATE := FND_API.G_MISS_DATE,
548 lead_contact_id NUMBER := FND_API.G_MISS_NUM,
549 lead_id NUMBER := FND_API.G_MISS_NUM,
550 customer_id NUMBER := FND_API.G_MISS_NUM,
551 address_id NUMBER := FND_API.G_MISS_NUM,
552 phone_id NUMBER := FND_API.G_MISS_NUM,
553 first_name VARCHAR2(40) := FND_API.G_MISS_CHAR,
554 last_name VARCHAR2(50) := FND_API.G_MISS_CHAR,
555 contact_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
556 orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
557 contact_id NUMBER := FND_API.G_MISS_NUM,
558 enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
559 rank_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
560 rank VARCHAR2(80) := FND_API.G_MISS_CHAR,
561 member_access VARCHAR2(30) := FND_API.G_MISS_CHAR,
562 member_role VARCHAR2(30) := FND_API.G_MISS_CHAR,
563 contact_party_id NUMBER := FND_API.G_MISS_NUM,
564 primary_contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
565 role VARCHAR2(30) := FND_API.G_MISS_CHAR,
566 ORG_ID NUMBER := FND_API.G_MISS_NUM,
567 attribute_category VARCHAR2(30),
568 attribute1 VARCHAR2(150),
569 attribute2 VARCHAR2(150),
570 attribute3 VARCHAR2(150),
571 attribute4 VARCHAR2(150),
572 attribute5 VARCHAR2(150),
573 attribute6 VARCHAR2(150),
574 attribute7 VARCHAR2(150),
575 attribute8 VARCHAR2(150),
576 attribute9 VARCHAR2(150),
577 attribute10 VARCHAR2(150),
578 attribute11 VARCHAR2(150),
579 attribute12 VARCHAR2(150),
580 attribute13 VARCHAR2(150),
581 attribute14 VARCHAR2(150),
582 attribute15 VARCHAR2(150)
583 );
584
585 G_MISS_CONTACT_REC contact_rec_type;
586 TYPE contact_tbl_type IS TABLE OF contact_rec_type
587 INDEX BY BINARY_INTEGER;
588 G_MISS_CONTACT_TBL contact_tbl_type;
589
590 TYPE contact_out_rec_type IS RECORD
591 (
592 lead_contact_id NUMBER,
593 return_status VARCHAR2(1)
594 );
595 TYPE contact_out_tbl_type IS TABLE OF contact_out_rec_type
596 INDEX BY BINARY_INTEGER;
597
598
599 TYPE Competitor_Prod_Rec_Type IS RECORD
600 (
601 -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
602 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
603 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
604 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
605 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
606 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
607 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
608 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
609 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
610 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
611 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
612 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
613 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
614 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
615 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
616 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
617 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
618 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
619 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
620 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
621 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
622 WIN_LOSS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR,
623 COMPETITOR_PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
624 LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
625 LEAD_ID NUMBER := FND_API.G_MISS_NUM,
626 LEAD_COMPETITOR_PROD_ID NUMBER := FND_API.G_MISS_NUM,
627 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
628 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
629 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
630 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
631 CREATION_DATE DATE := FND_API.G_MISS_DATE
632 );
633
634 G_MISS_Competitor_Prod_REC Competitor_Prod_Rec_Type;
635 TYPE Competitor_Prod_Tbl_Type IS TABLE OF Competitor_Prod_Rec_Type
636 INDEX BY BINARY_INTEGER;
637 G_MISS_Competitor_Prod_TBL Competitor_Prod_Tbl_Type;
638
639 TYPE Competitor_Prod_out_rec_type IS RECORD
640 (
641 LEAD_COMPETITOR_PROD_ID NUMBER,
642 return_status VARCHAR2(1)
643 );
644 TYPE Competitor_Prod_out_tbl_type IS TABLE OF Competitor_Prod_out_rec_type
645 INDEX BY BINARY_INTEGER;
646
647
648 TYPE Decision_Factor_Rec_Type IS RECORD
649 (
650 -- SECURITY_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
651 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
652 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
653 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
654 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
655 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
656 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
657 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
658 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
659 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
660 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
661 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
662 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
663 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
664 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
665 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
666 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
667 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
668 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
669 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
670 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
671 DECISION_RANK NUMBER := FND_API.G_MISS_NUM,
672 DECISION_PRIORITY_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
673 DECISION_FACTOR_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
674 LEAD_DECISION_FACTOR_ID NUMBER := FND_API.G_MISS_NUM,
675 LEAD_LINE_ID NUMBER := FND_API.G_MISS_NUM,
676 CREATE_BY NUMBER := FND_API.G_MISS_NUM,
677 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
678 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
679 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
680 CREATION_DATE DATE := FND_API.G_MISS_DATE
681 );
682
683 G_MISS_Decision_Factor_REC Decision_Factor_Rec_Type;
684 TYPE Decision_Factor_Tbl_Type IS TABLE OF Decision_Factor_Rec_Type
685 INDEX BY BINARY_INTEGER;
686 G_MISS_Decision_Factor_TBL Decision_Factor_Tbl_Type;
687
688 TYPE Decision_Factor_out_rec_type IS RECORD
689 (
690 LEAD_DECISION_FACTOR_ID NUMBER,
691 return_status VARCHAR2(1)
692 );
693 TYPE Decision_Factor_out_tbl_type IS TABLE OF Decision_Factor_out_rec_type
694 INDEX BY BINARY_INTEGER;
695
696
697
698 -- Start of Comments
699 --
700 -- API name : Create_Opp_header
701 -- Type : Public.
702 --
703 --
704 -- Required:
705 -- last_update_date
706 -- last_updated_by
707 -- creation_date
708 -- created_by
709 -- last_update_login
710 -- Customer_Id
711 -- Status
712 --
713 --
714 -- End of Comments
715
716 /*#
717 * Creates the Opportunity Header.
718 *
719 * This procedure performs the following functions:
720 * <ul>
721 * <li>Checks for user privileges to create new opportunities.</li>
722 * <li>Validates the data in the header record.</li>
723 * <li>Inserts a new opportunity header record in table AS_LEADS_ALL.</li>
724 * <li>Adds creator to the opportunity's sales team.</li>
725 * <li>Performs territory assignment for this opportunity.</li>
726 * <li>Starts the sales methodology workflow.</li>
727 * <li>Performs post creation processes through user-hook to handle business logic
728 * implemented by Oracle Partners.</li>
729 * </ul>
730 *
731 * @param p_api_version_number API version number.
732 * @param p_init_msg_list Intialize the message array.
733 * @param p_commit Commit after processing the transaction.
734 * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
735 * or FND_API.G_VALID_LEVEL_FULL).
736 * @param p_header_rec Record of the opportunity header to be created. The
737 * record type passed in p_header_rec is defined in the package AS_OPPORTUNITY_PUB.
738 * @param p_check_access_flag Check whether the logged in user has privileges
739 * to create the opportunity.
740 * @param p_admin_flag 'Y' if the logged in user has an administrator role.
741 * @param p_admin_group_id Sales group identifier of the logged in user if
742 * the user has an administrator role.
743 * @param p_identity_salesforce_id Sales force identifier of the logged in user.
744 * @param p_salesgroup_id Sales group identifier of the logged in user.
745 * @param p_partner_cont_party_id The party identifier of the partner contact
746 * if the logged in user is a partner contact.
747 * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
748 * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
749 * package AS_UTILITY_PUB.
750 * @param x_return_status The return status of the API stating Success, Failure or
751 * Unexpected Error.
752 * @param x_msg_count Number of error messages recorded during processing.
753 * @param x_msg_data Contains the text of the message if msg_count = 1.
754 * @param x_lead_id The identifier of the created opportunity.
755 * @rep:scope public
756 * @rep:lifecycle active
757 * @rep:displayname Create Opportunity Header
758 */
759 PROCEDURE Create_Opp_Header
760 ( p_api_version_number IN NUMBER,
761 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
762 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
763 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
764 p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
765 p_check_access_flag IN VARCHAR2,
766 p_admin_flag IN VARCHAR2,
767 p_admin_group_id IN NUMBER,
768 p_identity_salesforce_id IN NUMBER,
769 p_salesgroup_id IN NUMBER DEFAULT NULL,
770 p_partner_cont_party_id IN NUMBER,
771 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
772 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
773 x_return_status OUT NOCOPY VARCHAR2,
774 x_msg_count OUT NOCOPY NUMBER,
775 x_msg_data OUT NOCOPY VARCHAR2,
776 x_lead_id OUT NOCOPY NUMBER
777 );
778
779
780 -- Start of Comments
781 --
782 -- API name : Update_Opp_Header
783 -- Type : Public
784 -- Function : Update Opportunity Information
785 --
786 -- Required:
787 -- Lead_Id
788 -- last_update_date
789 --
790
791 /*#
792 * Updates the Opportunity Header.
793 *
794 * This procedure performs the following functions:
795 * <ul>
796 * <li>Checks for user privileges to update new opportunities.</li>
797 * <li>Validates the data in the header record.</li>
798 * <li>Creates system notes for this opportunity if needed.</li>
799 * <li>Updates the opportunity header in the AS_LEADS_ALL table.</li>
800 * <li>Starts the sales methodology workflow if sales methodology is added to
801 * the opportunity.</li>
802 * <li>Performs territory assignment for this opportunity.</li>
803 * <li>Performs post creation processes through user-hook to handle business logic
804 * implemented by Oracle Partners.</li>
805 * </ul>
806 *
807 * @param p_api_version_number API version number.
808 * @param p_init_msg_list Intialize the message array.
809 * @param p_commit Commit after processing the transaction.
810 * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
811 * or FND_API.G_VALID_LEVEL_FULL).
812 * @param p_header_rec Record of the opportunity header to be updated. The
813 * record type passed in p_header_rec is defined in the package AS_OPPORTUNITY_PUB.
814 * @param p_check_access_flag Check whether the logged in user has privileges
815 * to update the opportunity.
816 * @param p_admin_flag 'Y' if logged in user has an administrator role.
817 * @param p_admin_group_id Sales group identifier of the logged in user if
818 * user has an administrator role.
819 * @param p_identity_salesforce_id Sales force identifier of the logged in user.
820 * @param p_partner_cont_party_id The party identifier of the partner contact
821 * if the logged in user is a partner contact.
822 * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
823 * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
824 * package AS_UTILITY_PUB.
825 * @param x_return_status The return status of the API stating Success, Failure or
826 * Unexpected Error.
827 * @param x_msg_count Number of error messages recorded during processing.
828 * @param x_msg_data Contains the text of the message if msg_count = 1.
829 * @param x_lead_id The identifier of the updated opportunity.
830 * @rep:scope public
831 * @rep:lifecycle active
832 * @rep:displayname Update Opportunity Header
833 */
834 PROCEDURE Update_Opp_Header
835 ( p_api_version_number IN NUMBER,
836 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
837 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
838 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
839 p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
840 p_check_access_flag IN VARCHAR2,
841 p_admin_flag IN VARCHAR2,
842 p_admin_group_id IN NUMBER,
843 p_identity_salesforce_id IN NUMBER,
844 p_partner_cont_party_id IN NUMBER,
845 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
846 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
847 x_return_status OUT NOCOPY VARCHAR2,
848 x_msg_count OUT NOCOPY NUMBER,
849 x_msg_data OUT NOCOPY VARCHAR2,
850 x_lead_id OUT NOCOPY NUMBER);
851
852
853 -- Start of Comments
854 --
855 -- API name : Delete_Opp_Header
856 -- Type : Public
857 -- Function : Delete Opportunity Record
858 --
859
860 PROCEDURE Delete_Opp_Header
861 ( p_api_version_number IN NUMBER,
862 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
863 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
864 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
865 p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
866 p_check_access_flag IN VARCHAR2,
867 p_admin_flag IN VARCHAR2,
868 p_admin_group_id IN NUMBER,
869 p_identity_salesforce_id IN NUMBER,
870 p_partner_cont_party_id IN NUMBER,
871 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
872 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
873 x_return_status OUT NOCOPY VARCHAR2,
874 x_msg_count OUT NOCOPY NUMBER,
875 x_msg_data OUT NOCOPY VARCHAR2,
876 x_lead_id OUT NOCOPY NUMBER);
877
878
879 -- Start of Comments
880 --
881 -- API name : Create_Opp_Lines
882 -- Type : Public
883 -- Function : Create Opportunity Lines for an Opportunity
884 --
885 --
886 -- Required:
887 -- Lead_Id
888 -- Interest_Type_Id/Inventory_Item_Id and Organization_Id
889 --
890
891 /*#
892 * Creates product lines for an Opportunity.
893 *
894 * This procedure performs the following functions:
895 * <ul>
896 * <li>Checks for user privileges to create product lines.</li>
897 * <li>Validates the data in the purchase line table.</li>
898 * <li>Inserts purchase line records to the table AS_LEAD_LINES_ALL.</li>
899 * <li>Updates the opportunity header with the new purchase amount.</li>
900 * <li>Defaults forecast information to the user creating the product line.</li>
901 * <li>Performs the territory assignment for the opportunity.</li>
902 * </ul>
903 *
904 * @param p_api_version_number API version number.
905 * @param p_init_msg_list Intialize the message array.
906 * @param p_commit Commit after processing the transaction.
907 * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
908 * or FND_API.G_VALID_LEVEL_FULL).
909 * @param p_line_tbl A PL/SQL table of product lines to be created. This PL/SQL
910 * table is of record type AS_OPPORTUNITY_PUB.line_rec_type defined in the
911 * package AS_OPPORTUNITY_PUB.
912 * @param p_header_rec Record of the opportunity header to which the purchase
913 * lines belong. The record type passed in p_header_rec is defined in the
914 * package AS_OPPORTUNITY_PUB.
915 * @param p_check_access_flag Check whether the logged in user has privileges
916 * to create the opportunity.
917 * @param p_admin_flag 'Y' if the logged in user has an administrator role.
918 * @param p_admin_group_id Sales group identifier of the logged in user if
919 * the user has an administrator role.
920 * @param p_identity_salesforce_id Sales force identifier of the logged in user.
921 * @param p_salesgroup_id Sales group identifier of the logged in user.
922 * @param p_partner_cont_party_id The party identifier of the partner contact
923 * if the logged in user is a partner contact.
924 * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
925 * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
926 * package AS_UTILITY_PUB.
927 * @param x_line_out_tbl The identifiers of the created product lines and
928 * their statuses. This PL/SQL table is of record type
929 * AS_OPPORTUNITY_PUB.line_out_rec_type defined in the package AS_OPPORTUNITY_PUB.
930 * @param x_return_status The return status of the API stating Success, Failure or
931 * Unexpected Error.
932 * @param x_msg_count Number of error messages recorded during processing.
933 * @param x_msg_data Contains the text of the message if msg_count = 1.
934 * @rep:scope public
935 * @rep:lifecycle active
936 * @rep:displayname Create Opportunity Lines
937 */
938 PROCEDURE Create_Opp_Lines
939 ( p_api_version_number IN NUMBER,
940 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
941 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
942 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
943 p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
944 p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
945 p_check_access_flag IN VARCHAR2,
946 p_admin_flag IN VARCHAR2,
947 p_admin_group_id IN NUMBER,
948 p_identity_salesforce_id IN NUMBER,
949 p_salesgroup_id IN NUMBER DEFAULT NULL,
950 p_partner_cont_party_id IN NUMBER,
951 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
952 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
953 x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
954 x_return_status OUT NOCOPY VARCHAR2,
955 x_msg_count OUT NOCOPY NUMBER,
956 x_msg_data OUT NOCOPY VARCHAR2);
957
958
959 -- Start of Comments
960 --
961 -- API name : Update_Opp_Lines
962 -- Type : Public
963 -- Function : Update Opp_Line Information for an Opportunity
964 --
965 --
966 -- Required: LAST_UPDATE_DATE
967 -- Lead_Line_Id
968 -- Lead_Id
969 -- Interest_Type_Id/Inventory_Item_Id and Organization_Id
970 --
971
972 /*#
973 * Updates the product lines for an Opportunity.
974 *
975 * This procedure performs the following functions:
976 * <ul>
977 * <li>Checks for user privileges to update product lines.</li>
978 * <li>Validates the data in the purchase line table.</li>
979 * <li>Updates purchase line records in the AS_LEAD_LINES_ALL table.</li>
980 * <li>Updates the opportunity header with the new purchase amount.</li>
981 * <li>Sychronizes the forecast information with the new product line
982 * amounts for the assigned owner.</li>
983 * <li>Performs the territory assignment for the opportunity.</li>
984 * </ul>
985 *
986 * @param p_api_version_number API version number.
987 * @param p_init_msg_list Initialize the message array.
988 * @param p_commit Commit after processing the transaction.
989 * @param p_validation_level Validation Level (FND_API.G_VALID_LEVEL_NONE
990 * or FND_API.G_VALID_LEVEL_FULL).
991 * @param p_identity_salesforce_id Sales force identifier of the logged in user
992 * @param p_line_tbl A PL/SQL table of product lines to be updated. This PL/SQL
993 * table is of record type AS_OPPORTUNITY_PUB.line_rec_type defined in the
994 * package AS_OPPORTUNITY_PUB.
995 * @param p_header_rec Record of the opportunity header to which the purchase
996 * line belongs. The record type passed in p_header_rec is defined in
997 * the package AS_OPPORTUNITY_PUB.
998 * @param p_check_access_flag Check whether the logged in user has privileges
999 * to update the opportunity.
1000 * @param p_admin_flag 'Y' if the logged in user has an administrator role.
1001 * @param p_admin_group_id Sales group identifier of the logged in user if
1002 * the user has an administrator role.
1003 * @param p_partner_cont_party_id The party identifier of the partner contact
1004 * if the logged in user is a partner contact.
1005 * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
1006 * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
1007 * package AS_UTILITY_PUB.
1008 * @param x_line_out_tbl The identifiers of the updated product lines and
1009 * their statuses. This PL/SQL table is of record type
1010 * AS_OPPORTUNITY_PUB.line_out_rec_type defined in the package AS_OPPORTUNITY_PUB.
1011 * @param x_return_status The return status of the API stating Success, Failure or
1012 * Unexpected Error.
1013 * @param x_msg_count Number of error messages recorded during processing.
1014 * @param x_msg_data Contains the text of the message if msg_count = 1.
1015 * @rep:scope public
1016 * @rep:lifecycle active
1017 * @rep:displayname Update Opportunity Lines
1018 */
1019 PROCEDURE Update_Opp_Lines
1020 ( p_api_version_number IN NUMBER,
1021 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1022 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1023 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1024 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1025 p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1026 p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1027 p_check_access_flag IN VARCHAR2,
1028 p_admin_flag IN VARCHAR2,
1029 p_admin_group_id IN NUMBER,
1030 p_partner_cont_party_id IN NUMBER,
1031 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1032 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1033 x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1034 x_return_status OUT NOCOPY VARCHAR2,
1035 x_msg_count OUT NOCOPY NUMBER,
1036 x_msg_data OUT NOCOPY VARCHAR2);
1037
1038
1039
1040 -- Start of Comments
1041 --
1042 -- API name : Delete_Opp_Lines
1043 -- Type : Public
1044 -- Function : Delete Lines for an Opportunity
1045 --
1046 --
1047
1048 PROCEDURE Delete_Opp_Lines
1049 ( p_api_version_number IN NUMBER,
1050 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1051 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1052 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1053 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1054 p_line_tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
1055 p_header_rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
1056 p_check_access_flag IN VARCHAR2,
1057 p_admin_flag IN VARCHAR2,
1058 p_admin_group_id IN NUMBER,
1059 p_partner_cont_party_id IN NUMBER,
1060 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1061 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1062 x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1063 x_return_status OUT NOCOPY VARCHAR2,
1064 x_msg_count OUT NOCOPY NUMBER,
1065 x_msg_data OUT NOCOPY VARCHAR2);
1066
1067
1068 --
1069 -- Create Sales Credits
1070 --
1071 -- Required:
1072 -- Lead_Id
1073 -- Lead_Line_Id
1074 -- Saleforce_Id
1075 -- Credit_Type_Id
1076 -- Credit_Amount/Credit_Percent
1077 --
1078
1079
1080 PROCEDURE Create_Sales_Credits
1081 ( p_api_version_number IN NUMBER,
1082 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1083 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1084 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1085 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1086 p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1087 p_check_access_flag IN VARCHAR2,
1088 p_admin_flag IN VARCHAR2,
1089 p_admin_group_id IN NUMBER,
1090 p_partner_cont_party_id IN NUMBER,
1091 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1092 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1093 x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1094 x_return_status OUT NOCOPY VARCHAR2,
1095 x_msg_count OUT NOCOPY NUMBER,
1096 x_msg_data OUT NOCOPY VARCHAR2);
1097
1098 --
1099 -- Update Sales Credits
1100 --
1101 -- Required: Last_Update_date
1102 -- Sales_Credit_Id
1103 -- Lead_Id
1104 -- Lead_Line_Id
1105 -- Saleforce_Id
1106 -- Credit_Type_Id
1107 -- Credit_Amount/Credit_Percent
1108 --
1109
1110 PROCEDURE Update_Sales_Credits
1111 ( p_api_version_number IN NUMBER,
1112 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1113 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1115 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1116 p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1117 p_check_access_flag IN VARCHAR2,
1118 p_admin_flag IN VARCHAR2,
1119 p_admin_group_id IN NUMBER,
1120 p_partner_cont_party_id IN NUMBER,
1121 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1122 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1123 x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1124 x_return_status OUT NOCOPY VARCHAR2,
1125 x_msg_count OUT NOCOPY NUMBER,
1126 x_msg_data OUT NOCOPY VARCHAR2);
1127
1128 --
1129 -- Modify Sales Credits
1130 --
1131 -- Required:
1132 -- Lead_Id
1133 -- Lead_Line_Id
1134 -- Saleforce_Id
1135 -- Credit_Type_Id
1136 -- Credit_Amount/Credit_Percent
1137 --
1138 -- Note: This API will perform 100% validation for forecast/revenue credit
1139 -- before insert/update/delete sales credits for opportunity line.
1140 -- The caller need to pass in all the sales credit records
1141 -- under the opportunity line for insert/update. The records
1142 -- which are not passed in will be deleted from the database.
1143 --
1144
1145 PROCEDURE Modify_Sales_Credits
1146 ( p_api_version_number IN NUMBER,
1147 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1148 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1149 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1150 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1151 p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
1152 p_check_access_flag IN VARCHAR2,
1153 p_admin_flag IN VARCHAR2,
1154 p_admin_group_id IN NUMBER,
1155 p_partner_cont_party_id IN NUMBER,
1156 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1157 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1158 x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1159 x_return_status OUT NOCOPY VARCHAR2,
1160 x_msg_count OUT NOCOPY NUMBER,
1161 x_msg_data OUT NOCOPY VARCHAR2);
1162
1163
1164 --
1165 -- Delete Sales Credits
1166 --
1167
1168 PROCEDURE Delete_Sales_Credits
1169 ( p_api_version_number IN NUMBER,
1170 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1171 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1172 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1173 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1174 p_sales_credit_tbl IN AS_OPPORTUNITY_PUB.Sales_Credit_tbl_Type,
1175 p_check_access_flag IN VARCHAR2,
1176 p_admin_flag IN VARCHAR2,
1177 p_admin_group_id IN NUMBER,
1178 p_partner_cont_party_id IN NUMBER,
1179 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1180 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1181 x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1182 x_return_status OUT NOCOPY VARCHAR2,
1183 x_msg_count OUT NOCOPY NUMBER,
1184 x_msg_data OUT NOCOPY VARCHAR2);
1185
1186 --
1187 -- Create Obstacles
1188 --
1189 -- Required:
1190 -- Lead_Id
1191 -- Obstacle_Code
1192 --
1193
1194 PROCEDURE Create_Obstacles
1195 ( p_api_version_number IN NUMBER,
1196 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1197 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1198 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1199 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1200 p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1201 p_check_access_flag IN VARCHAR2,
1202 p_admin_flag IN VARCHAR2,
1203 p_admin_group_id IN NUMBER,
1204 p_partner_cont_party_id IN NUMBER,
1205 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1206 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1207 x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1208 x_return_status OUT NOCOPY VARCHAR2,
1209 x_msg_count OUT NOCOPY NUMBER,
1210 x_msg_data OUT NOCOPY VARCHAR2);
1211
1212 --
1213 -- Update Obstacles
1214 --
1215 -- Required: Last_Update_date
1216 -- Lead_Obstacle_Id
1217 -- Lead_Id
1218 -- Obstacle_Code
1219 --
1220
1221 PROCEDURE Update_Obstacles
1222 ( p_api_version_number IN NUMBER,
1223 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1224 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1225 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1226 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1227 p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1228 p_check_access_flag IN VARCHAR2,
1229 p_admin_flag IN VARCHAR2,
1230 p_admin_group_id IN NUMBER,
1231 p_partner_cont_party_id IN NUMBER,
1232 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1233 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1234 x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1235 x_return_status OUT NOCOPY VARCHAR2,
1236 x_msg_count OUT NOCOPY NUMBER,
1237 x_msg_data OUT NOCOPY VARCHAR2);
1238
1239 --
1240 -- Delete Obstacles
1241 --
1242
1243 PROCEDURE Delete_Obstacles
1244 ( p_api_version_number IN NUMBER,
1245 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1246 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1247 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1248 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1249 p_obstacle_tbl IN AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
1250 p_check_access_flag IN VARCHAR2,
1251 p_admin_flag IN VARCHAR2,
1252 p_admin_group_id IN NUMBER,
1253 p_partner_cont_party_id IN NUMBER,
1254 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1255 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1256 x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1257 x_return_status OUT NOCOPY VARCHAR2,
1258 x_msg_count OUT NOCOPY NUMBER,
1259 x_msg_data OUT NOCOPY VARCHAR2);
1260
1261 --
1262 -- Update Lead Orders
1263 --
1264 -- Required: Last_Update_date
1265 -- Lead_Order_Id
1266 -- Lead_Id
1267 -- Order_Header_Id
1268 --
1269
1270 PROCEDURE Update_Orders
1271 ( p_api_version_number IN NUMBER,
1272 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1273 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1274 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1275 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1276 p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1277 p_check_access_flag IN VARCHAR2,
1278 p_admin_flag IN VARCHAR2,
1279 p_admin_group_id IN NUMBER,
1280 p_partner_cont_party_id IN NUMBER,
1281 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1282 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1283 x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1284 x_return_status OUT NOCOPY VARCHAR2,
1285 x_msg_count OUT NOCOPY NUMBER,
1286 x_msg_data OUT NOCOPY VARCHAR2);
1287
1288 --
1289 -- Delete Lead Orders
1290 --
1291
1292 PROCEDURE Delete_Orders
1293 ( p_api_version_number IN NUMBER,
1294 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1295 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1296 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1297 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1298 p_lead_order_tbl IN AS_OPPORTUNITY_PUB.Order_tbl_Type,
1299 p_check_access_flag IN VARCHAR2,
1300 p_admin_flag IN VARCHAR2,
1301 p_admin_group_id IN NUMBER,
1302 p_partner_cont_party_id IN NUMBER,
1303 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1304 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1305 x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1306 x_return_status OUT NOCOPY VARCHAR2,
1307 x_msg_count OUT NOCOPY NUMBER,
1308 x_msg_data OUT NOCOPY VARCHAR2);
1309
1310 --
1311 -- Create Competitors
1312 --
1313 -- Required:
1314 -- Lead_Id
1315 -- Competitor_Id
1316 --
1317
1318 PROCEDURE Create_Competitors
1319 ( p_api_version_number IN NUMBER,
1320 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1321 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1322 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1323 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1324 p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1325 p_check_access_flag IN VARCHAR2,
1326 p_admin_flag IN VARCHAR2,
1327 p_admin_group_id IN NUMBER,
1328 p_partner_cont_party_id IN NUMBER,
1329 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1330 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1331 x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1332 x_return_status OUT NOCOPY VARCHAR2,
1333 x_msg_count OUT NOCOPY NUMBER,
1334 x_msg_data OUT NOCOPY VARCHAR2);
1335
1336 --
1337 -- Update Competitors
1338 --
1339 -- Required: Last_Update_date
1340 -- Lead_Competitor_Id
1341 -- Lead_Id
1342 -- Competitor_Id
1343 --
1344
1345 PROCEDURE Update_Competitors
1346 ( p_api_version_number IN NUMBER,
1347 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1348 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1349 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1350 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1351 p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1352 p_check_access_flag IN VARCHAR2,
1353 p_admin_flag IN VARCHAR2,
1354 p_admin_group_id IN NUMBER,
1355 p_partner_cont_party_id IN NUMBER,
1356 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1357 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1358 x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1359 x_return_status OUT NOCOPY VARCHAR2,
1360 x_msg_count OUT NOCOPY NUMBER,
1361 x_msg_data OUT NOCOPY VARCHAR2);
1362
1363
1364 PROCEDURE Delete_Competitors
1365 ( p_api_version_number IN NUMBER,
1366 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1367 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1368 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1369 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1370 p_competitor_tbl IN AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
1371 p_check_access_flag IN VARCHAR2,
1372 p_admin_flag IN VARCHAR2,
1373 p_admin_group_id IN NUMBER,
1374 p_partner_cont_party_id IN NUMBER,
1375 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1376 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1377 x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1378 x_return_status OUT NOCOPY VARCHAR2,
1379 x_msg_count OUT NOCOPY NUMBER,
1380 x_msg_data OUT NOCOPY VARCHAR2);
1381
1382
1383 --
1384 -- Create Competitor_Prods
1385 --
1386 -- Required:
1387 -- Lead_Id
1388 -- Lead_Line_Id
1389 -- Lead_Competitor_Id
1390
1391 PROCEDURE Create_Competitor_Prods
1392 ( p_api_version_number IN NUMBER,
1393 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1394 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1395 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1396 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1397 p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1398 p_check_access_flag IN VARCHAR2,
1399 p_admin_flag IN VARCHAR2,
1400 p_admin_group_id IN NUMBER,
1401 p_partner_cont_party_id IN NUMBER,
1402 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1403 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1404 x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1405 x_return_status OUT NOCOPY VARCHAR2,
1406 x_msg_count OUT NOCOPY NUMBER,
1407 x_msg_data OUT NOCOPY VARCHAR2);
1408
1409 --
1410 -- Update Competitor_Prods
1411 --
1412 -- Required: Last_Update_date
1413 -- Lead_Competitor_Id
1414 -- Lead_Id
1415 -- Lead_Line_Id
1416 -- Lead_Competitor_Prod_Id
1417 --
1418
1419 PROCEDURE Update_Competitor_Prods
1420 ( p_api_version_number IN NUMBER,
1421 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1422 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1423 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1424 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1425 p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1426 p_check_access_flag IN VARCHAR2,
1427 p_admin_flag IN VARCHAR2,
1428 p_admin_group_id IN NUMBER,
1429 p_partner_cont_party_id IN NUMBER,
1430 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1431 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1432 x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1433 x_return_status OUT NOCOPY VARCHAR2,
1434 x_msg_count OUT NOCOPY NUMBER,
1435 x_msg_data OUT NOCOPY VARCHAR2);
1436
1437
1438 PROCEDURE Delete_Competitor_Prods
1439 ( p_api_version_number IN NUMBER,
1440 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1441 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1442 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1443 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1444 p_competitor_prod_tbl IN AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
1445 p_check_access_flag IN VARCHAR2,
1446 p_admin_flag IN VARCHAR2,
1447 p_admin_group_id IN NUMBER,
1448 p_partner_cont_party_id IN NUMBER,
1449 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1450 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1451 x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1452 x_return_status OUT NOCOPY VARCHAR2,
1453 x_msg_count OUT NOCOPY NUMBER,
1454 x_msg_data OUT NOCOPY VARCHAR2);
1455
1456
1457 --
1458 -- Create Decision_Factors
1459 --
1460 -- Required:
1461 -- Lead_Id
1462 -- Lead_Line_Id
1463 --
1464
1465 PROCEDURE Create_Decision_Factors
1466 ( p_api_version_number IN NUMBER,
1467 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1468 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1469 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1470 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1471 p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1472 p_check_access_flag IN VARCHAR2,
1473 p_admin_flag IN VARCHAR2,
1474 p_admin_group_id IN NUMBER,
1475 p_partner_cont_party_id IN NUMBER,
1476 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1477 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1478 x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1479 x_return_status OUT NOCOPY VARCHAR2,
1480 x_msg_count OUT NOCOPY NUMBER,
1481 x_msg_data OUT NOCOPY VARCHAR2);
1482
1483 --
1484 -- Update Decision_Factors
1485 --
1486 -- Required: Last_Update_date
1487 -- Lead_Decision_Factor_Id
1488 -- Lead_Id
1489 -- Lead_Line_Id
1490
1491 --
1492
1493 PROCEDURE Update_Decision_Factors
1494 ( p_api_version_number IN NUMBER,
1495 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1496 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1497 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1498 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1499 p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1500 p_check_access_flag IN VARCHAR2,
1501 p_admin_flag IN VARCHAR2,
1502 p_admin_group_id IN NUMBER,
1503 p_partner_cont_party_id IN NUMBER,
1504 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1505 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1506 x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1507 x_return_status OUT NOCOPY VARCHAR2,
1508 x_msg_count OUT NOCOPY NUMBER,
1509 x_msg_data OUT NOCOPY VARCHAR2);
1510
1511
1512 PROCEDURE Delete_Decision_Factors
1513 ( p_api_version_number IN NUMBER,
1514 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1515 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1516 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1517 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1518 p_decision_factor_tbl IN AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
1519 p_check_access_flag IN VARCHAR2,
1520 p_admin_flag IN VARCHAR2,
1521 p_admin_group_id IN NUMBER,
1522 p_partner_cont_party_id IN NUMBER,
1523 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1524 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1525 x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1526 x_return_status OUT NOCOPY VARCHAR2,
1527 x_msg_count OUT NOCOPY NUMBER,
1528 x_msg_data OUT NOCOPY VARCHAR2);
1529
1530
1531
1532 --
1533 -- Create Contacts
1534 --
1535 -- Required:
1536 -- Lead_Id
1537 -- Customer_Id
1538 -- Contact_Party_Id
1539 -- Enabled_Flag
1540 --
1541
1542 PROCEDURE Create_Contacts
1543 ( p_api_version_number IN NUMBER,
1544 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1545 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1546 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1547 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1548 p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1549 p_header_rec IN HEADER_REC_TYPE DEFAULT G_MISS_HEADER_REC,
1550 p_check_access_flag IN VARCHAR2,
1551 p_admin_flag IN VARCHAR2,
1552 p_admin_group_id IN NUMBER,
1553 p_partner_cont_party_id IN NUMBER,
1554 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1555 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1556 x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1557 x_return_status OUT NOCOPY VARCHAR2,
1558 x_msg_count OUT NOCOPY NUMBER,
1559 x_msg_data OUT NOCOPY VARCHAR2);
1560
1561
1562 --
1563 -- Update Contacts
1564 --
1565 -- Required: Last_Update_date
1566 -- Lead_Contact_Id
1567 -- Lead_Id
1568 -- Customer_Id
1569 -- Contact_Party_Id
1570 -- Enabled_Flag
1571 --
1572
1573 PROCEDURE Update_Contacts
1574 ( p_api_version_number IN NUMBER,
1575 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1576 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1577 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1578 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1579 p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1580 p_check_access_flag IN VARCHAR2,
1581 p_admin_flag IN VARCHAR2,
1582 p_admin_group_id IN NUMBER,
1583 p_partner_cont_party_id IN NUMBER,
1584 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1585 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1586 x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1587 x_return_status OUT NOCOPY VARCHAR2,
1588 x_msg_count OUT NOCOPY NUMBER,
1589 x_msg_data OUT NOCOPY VARCHAR2);
1590
1591 --
1592 -- Delete Contacts
1593 --
1594
1595 PROCEDURE Delete_Contacts
1596 ( p_api_version_number IN NUMBER,
1597 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1598 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1599 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1600 p_identity_salesforce_id IN NUMBER DEFAULT NULL,
1601 p_contact_tbl IN AS_OPPORTUNITY_PUB.Contact_tbl_Type,
1602 p_check_access_flag IN VARCHAR2,
1603 p_admin_flag IN VARCHAR2,
1604 p_admin_group_id IN NUMBER,
1605 p_partner_cont_party_id IN NUMBER,
1606 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1607 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1608 x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1609 x_return_status OUT NOCOPY VARCHAR2,
1610 x_msg_count OUT NOCOPY NUMBER,
1611 x_msg_data OUT NOCOPY VARCHAR2);
1612
1613
1614 --
1615 -- Delete Sales Teams
1616 --
1617
1618 PROCEDURE Delete_SalesTeams
1619 ( p_api_version_number IN NUMBER,
1620 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1621 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1622 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1623 p_sales_team_tbl IN AS_ACCESS_PUB.SALES_TEAM_TBL_TYPE,
1624 p_check_access_flag IN VARCHAR2,
1625 p_admin_flag IN VARCHAR2,
1626 p_admin_group_id IN NUMBER,
1627 p_identity_salesforce_id IN NUMBER,
1628 p_partner_cont_party_id IN NUMBER,
1629 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1630 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1631 x_return_status OUT NOCOPY VARCHAR2,
1632 x_msg_count OUT NOCOPY NUMBER,
1633 x_msg_data OUT NOCOPY VARCHAR2
1634 );
1635
1636
1637 -- Start of Comments
1638 --
1639 -- API name: Copy_Opportunity
1640 -- Type: Public.
1641 --
1642 -- Function: To copy an existing opportunity header with/without
1643 -- the salesteam, opportunity lines, sales_credits, contacts
1644 -- and competitors
1645 --
1646 -- Note: 1. If the p_sales_credits = FND_API.G_TRUE then
1647 -- the p_opp_lines must be FND_API.G_TRUE.
1648 -- 2. If the p_copy_salesteam is FALSE the salesteam
1649 -- will be defaulted as in creating a new opportunity.
1650 -- 3. If the p_copy_sales_credit is FALSE then the
1651 -- the sales credits will be defaulted 100% to the
1652 -- logon salesforce.
1653 --
1654 --
1655 -- Parameter specifications:
1656 -- p_lead_id - which opportunity you want to copy from
1657 -- p_description - name of opportunity
1658 -- p_copy_salesteam - whether to copy the sales team
1659 -- p_copy_opp_lines - whether to copy the opportunity lines
1660 -- p_copy_lead_contacts - whether to copy the opportunity contacts
1661 -- p_copy_lead_competitors - whether to copy the opportunity competitors
1662 -- p_copy_sales_credits - whether to copy the sales credits
1663 -- p_copy_methodology - whether to copy the sales methodology
1664 -- p_new_customer_id - the customer identifier of the new opportunity
1665 -- p_new_address_id - the customer address identifier of the new
1666 -- opportunity
1667 --
1668 -- End of Comments
1669
1670 PROCEDURE Copy_Opportunity
1671 ( p_api_version_number IN NUMBER,
1672 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1673 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1674 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1675 p_lead_id IN NUMBER,
1676 p_description IN VARCHAR2,
1677 p_copy_salesteam IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1678 p_copy_opp_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1679 p_copy_lead_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1680 p_copy_lead_competitors IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1681 p_copy_sales_credits IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1682 p_copy_methodology IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1683 p_new_customer_id IN NUMBER,
1684 p_new_address_id IN NUMBER,
1685 p_check_access_flag IN VARCHAR2,
1686 p_admin_flag IN VARCHAR2,
1687 p_admin_group_id IN NUMBER,
1688 p_identity_salesforce_id IN NUMBER,
1689 p_salesgroup_id IN NUMBER DEFAULT NULL,
1690 p_partner_cont_party_id IN NUMBER,
1691 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1692 DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1693 x_return_status OUT NOCOPY VARCHAR2,
1694 x_msg_count OUT NOCOPY NUMBER,
1695 x_msg_data OUT NOCOPY VARCHAR2,
1696 x_lead_id OUT NOCOPY NUMBER
1697 );
1698
1699
1700 --
1701 -- Get Access Profiles
1702 --
1703 -- This procedure gets profile values from profile table type
1704 -- and output access profile record type.
1705 --
1706 -- This procedure is used by internal private APIs where input
1707 -- parameter is profile table type and need to call check access
1708 -- APIs.
1709 --
1710
1711 PROCEDURE Get_Access_Profiles(
1712 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
1713 x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type
1714 );
1715
1716 --
1717 -- Get Profiles
1718 --
1719 -- This function get profile value from profile table type
1720 -- and return the value for the input profile name.
1721 --
1722 -- If profile name is not found in profile table or
1723 -- profile value is NULL or FND_API.G_MISS_CHAR
1724 -- then the function return NULL
1725 --
1726
1727 FUNCTION Get_Profile(
1728 p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
1729 p_profile_name IN VARCHAR2 )
1730 RETURN VARCHAR2;
1731
1732
1733 END AS_OPPORTUNITY_PUB;
[Home] [Help]