[Home] [Help]
PACKAGE: APPS.CN_GET_TX_DATA_PUB
Source
1 PACKAGE CN_GET_TX_DATA_PUB AUTHID CURRENT_USER AS
2 -- $Header: cnpxadjs.pls 120.1.12000000.2 2007/08/07 14:24:35 apink ship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8
9 --
10 -- Package Name
11 -- cn_get_tx_data_pub
12 -- Purpose
13 -- Package Body for Mass Adjustments Package
14 -- History
15 --+ 08/08/2005 Hithanki R12 Version
16 --
17
18 TYPE adj_rec_type IS RECORD(
19 commission_header_id number := fnd_api.g_miss_num,
20 direct_salesrep_number varchar2(30) := fnd_api.g_miss_char,
21 direct_salesrep_name varchar2(360) := fnd_api.g_miss_char,
22 direct_salesrep_id number := fnd_api.g_miss_num,
23 processed_period_id number := fnd_api.g_miss_num,
24 processed_period varchar2(30) := fnd_api.g_miss_char,
25 processed_date date := fnd_api.g_miss_date,
26 rollup_date date := fnd_api.g_miss_date,
27 transaction_amount number := fnd_api.g_miss_num,
28 transaction_amount_orig number := fnd_api.g_miss_num,
29 quantity number := fnd_api.g_miss_num,
30 discount_percentage number := fnd_api.g_miss_num,
31 margin_percentage number := fnd_api.g_miss_num,
32 orig_currency_code varchar2(15) := fnd_api.g_miss_char,
33 exchange_rate number := fnd_api.g_miss_num,
34 status_disp varchar2(80) := fnd_api.g_miss_char,
35 status varchar2(30) := fnd_api.g_miss_char,
36 trx_type_disp varchar2(80) := fnd_api.g_miss_char,
37 trx_type varchar2(30) := fnd_api.g_miss_char,
38 reason varchar2(80) := fnd_api.g_miss_char,
39 reason_code varchar2(30) := fnd_api.g_miss_char,
40 comments varchar2(1800) := fnd_api.g_miss_char,
41 trx_batch_id number := fnd_api.g_miss_num,
42 created_by number := fnd_api.g_miss_num,
43 creation_date date := fnd_api.g_miss_date,
44 last_updated_by number := fnd_api.g_miss_num,
45 last_update_login number := fnd_api.g_miss_num,
46 last_update_date date := fnd_api.g_miss_date,
47 attribute_category varchar2(30) := fnd_api.g_miss_char,
48 attribute1 varchar2(240) := fnd_api.g_miss_char,
49 attribute2 varchar2(240) := fnd_api.g_miss_char,
50 attribute3 varchar2(240) := fnd_api.g_miss_char,
51 attribute4 varchar2(240) := fnd_api.g_miss_char,
52 attribute5 varchar2(240) := fnd_api.g_miss_char,
53 attribute6 varchar2(240) := fnd_api.g_miss_char,
54 attribute7 varchar2(240) := fnd_api.g_miss_char,
55 attribute8 varchar2(240) := fnd_api.g_miss_char,
56 attribute9 varchar2(240) := fnd_api.g_miss_char,
57 attribute10 varchar2(240) := fnd_api.g_miss_char,
58 attribute11 varchar2(240) := fnd_api.g_miss_char,
59 attribute12 varchar2(240) := fnd_api.g_miss_char,
60 attribute13 varchar2(240) := fnd_api.g_miss_char,
61 attribute14 varchar2(240) := fnd_api.g_miss_char,
62 attribute15 varchar2(240) := fnd_api.g_miss_char,
63 attribute16 varchar2(240) := fnd_api.g_miss_char,
64 attribute17 varchar2(240) := fnd_api.g_miss_char,
65 attribute18 varchar2(240) := fnd_api.g_miss_char,
66 attribute19 varchar2(240) := fnd_api.g_miss_char,
67 attribute20 varchar2(240) := fnd_api.g_miss_char,
68 attribute21 varchar2(240) := fnd_api.g_miss_char,
69 attribute22 varchar2(240) := fnd_api.g_miss_char,
70 attribute23 varchar2(240) := fnd_api.g_miss_char,
71 attribute24 varchar2(240) := fnd_api.g_miss_char,
72 attribute25 varchar2(240) := fnd_api.g_miss_char,
73 attribute26 varchar2(240) := fnd_api.g_miss_char,
74 attribute27 varchar2(240) := fnd_api.g_miss_char,
75 attribute28 varchar2(240) := fnd_api.g_miss_char,
76 attribute29 varchar2(240) := fnd_api.g_miss_char,
77 attribute30 varchar2(240) := fnd_api.g_miss_char,
78 attribute31 varchar2(240) := fnd_api.g_miss_char,
79 attribute32 varchar2(240) := fnd_api.g_miss_char,
80 attribute33 varchar2(240) := fnd_api.g_miss_char,
81 attribute34 varchar2(240) := fnd_api.g_miss_char,
82 attribute35 varchar2(240) := fnd_api.g_miss_char,
83 attribute36 varchar2(240) := fnd_api.g_miss_char,
84 attribute37 varchar2(240) := fnd_api.g_miss_char,
85 attribute38 varchar2(240) := fnd_api.g_miss_char,
86 attribute39 varchar2(240) := fnd_api.g_miss_char,
87 attribute40 varchar2(240) := fnd_api.g_miss_char,
88 attribute41 varchar2(240) := fnd_api.g_miss_char,
89 attribute42 varchar2(240) := fnd_api.g_miss_char,
90 attribute43 varchar2(240) := fnd_api.g_miss_char,
91 attribute44 varchar2(240) := fnd_api.g_miss_char,
92 attribute45 varchar2(240) := fnd_api.g_miss_char,
93 attribute46 varchar2(240) := fnd_api.g_miss_char,
94 attribute47 varchar2(240) := fnd_api.g_miss_char,
95 attribute48 varchar2(240) := fnd_api.g_miss_char,
96 attribute49 varchar2(240) := fnd_api.g_miss_char,
97 attribute50 varchar2(240) := fnd_api.g_miss_char,
98 attribute51 varchar2(240) := fnd_api.g_miss_char,
99 attribute52 varchar2(240) := fnd_api.g_miss_char,
100 attribute53 varchar2(240) := fnd_api.g_miss_char,
101 attribute54 varchar2(240) := fnd_api.g_miss_char,
102 attribute55 varchar2(240) := fnd_api.g_miss_char,
103 attribute56 varchar2(240) := fnd_api.g_miss_char,
104 attribute57 varchar2(240) := fnd_api.g_miss_char,
105 attribute58 varchar2(240) := fnd_api.g_miss_char,
106 attribute59 varchar2(240) := fnd_api.g_miss_char,
107 attribute60 varchar2(240) := fnd_api.g_miss_char,
108 attribute61 varchar2(240) := fnd_api.g_miss_char,
109 attribute62 varchar2(240) := fnd_api.g_miss_char,
110 attribute63 varchar2(240) := fnd_api.g_miss_char,
111 attribute64 varchar2(240) := fnd_api.g_miss_char,
112 attribute65 varchar2(240) := fnd_api.g_miss_char,
113 attribute66 varchar2(240) := fnd_api.g_miss_char,
114 attribute67 varchar2(240) := fnd_api.g_miss_char,
115 attribute68 varchar2(240) := fnd_api.g_miss_char,
116 attribute69 varchar2(240) := fnd_api.g_miss_char,
117 attribute70 varchar2(240) := fnd_api.g_miss_char,
118 attribute71 varchar2(240) := fnd_api.g_miss_char,
119 attribute72 varchar2(240) := fnd_api.g_miss_char,
120 attribute73 varchar2(240) := fnd_api.g_miss_char,
121 attribute74 varchar2(240) := fnd_api.g_miss_char,
122 attribute75 varchar2(240) := fnd_api.g_miss_char,
123 attribute76 varchar2(240) := fnd_api.g_miss_char,
124 attribute77 varchar2(240) := fnd_api.g_miss_char,
125 attribute78 varchar2(240) := fnd_api.g_miss_char,
126 attribute79 varchar2(240) := fnd_api.g_miss_char,
127 attribute80 varchar2(240) := fnd_api.g_miss_char,
128 attribute81 varchar2(240) := fnd_api.g_miss_char,
129 attribute82 varchar2(240) := fnd_api.g_miss_char,
130 attribute83 varchar2(240) := fnd_api.g_miss_char,
131 attribute84 varchar2(240) := fnd_api.g_miss_char,
132 attribute85 varchar2(240) := fnd_api.g_miss_char,
133 attribute86 varchar2(240) := fnd_api.g_miss_char,
134 attribute87 varchar2(240) := fnd_api.g_miss_char,
135 attribute88 varchar2(240) := fnd_api.g_miss_char,
136 attribute89 varchar2(240) := fnd_api.g_miss_char,
137 attribute90 varchar2(240) := fnd_api.g_miss_char,
138 attribute91 varchar2(240) := fnd_api.g_miss_char,
139 attribute92 varchar2(240) := fnd_api.g_miss_char,
140 attribute93 varchar2(240) := fnd_api.g_miss_char,
141 attribute94 varchar2(240) := fnd_api.g_miss_char,
142 attribute95 varchar2(240) := fnd_api.g_miss_char,
143 attribute96 varchar2(240) := fnd_api.g_miss_char,
144 attribute97 varchar2(240) := fnd_api.g_miss_char,
145 attribute98 varchar2(240) := fnd_api.g_miss_char,
146 attribute99 varchar2(240) := fnd_api.g_miss_char,
147 attribute100 varchar2(240) := fnd_api.g_miss_char,
148 quota_id number := fnd_api.g_miss_num,
149 quota_name varchar2(80) := fnd_api.g_miss_char,
150 revenue_class_id number := fnd_api.g_miss_num,
151 revenue_class_name varchar2(30) := fnd_api.g_miss_char,
152 trx_batch_name varchar2(30) := fnd_api.g_miss_char,
153 source_trx_number varchar2(80) := fnd_api.g_miss_char,
154 trx_sales_line_id number := fnd_api.g_miss_num,
155 trx_line_id number := fnd_api.g_miss_num,
156 trx_id number := fnd_api.g_miss_num,
157 comm_lines_api_id number := fnd_api.g_miss_num,
158 source_doc_type varchar2(80) := fnd_api.g_miss_char,
159 upside_amount number := fnd_api.g_miss_num,
160 upside_quantity number := fnd_api.g_miss_num,
161 uom_code varchar2(3) := fnd_api.g_miss_char,
162 forecast_id number := fnd_api.g_miss_num,
163 program_id number := fnd_api.g_miss_num,
164 request_id number := fnd_api.g_miss_num,
165 program_application_id number := fnd_api.g_miss_num,
166 program_update_date date := fnd_api.g_miss_date,
167 adj_comm_lines_api_id number := fnd_api.g_miss_num,
168 invoice_number varchar2(20) := fnd_api.g_miss_char,
169 invoice_date date := fnd_api.g_miss_date,
170 order_number number := fnd_api.g_miss_num,
171 order_date date := fnd_api.g_miss_date,
172 line_number number := fnd_api.g_miss_num,
173 customer_id number := fnd_api.g_miss_num,
174 bill_to_address_id number := fnd_api.g_miss_num,
175 ship_to_address_id number := fnd_api.g_miss_num,
176 bill_to_contact_id number := fnd_api.g_miss_num,
177 ship_to_contact_id number := fnd_api.g_miss_num,
178 load_status varchar2(30) := fnd_api.g_miss_char,
179 revenue_type_disp varchar2(80) := fnd_api.g_miss_char,
180 revenue_type varchar2(15) := fnd_api.g_miss_char,
181 adjust_rollup_flag varchar2(1) := fnd_api.g_miss_char,
182 adjust_date date := fnd_api.g_miss_date,
183 adjusted_by varchar2(100) := fnd_api.g_miss_char,
184 adjust_status_disp varchar2(80) := fnd_api.g_miss_char,
185 adjust_status varchar2(20) := fnd_api.g_miss_char,
186 adjust_comments varchar2(2000) := fnd_api.g_miss_char,
187 type varchar2(80) := fnd_api.g_miss_char,
188 pre_processed_code varchar2(30) := fnd_api.g_miss_char,
189 comp_group_id number := fnd_api.g_miss_num,
190 srp_plan_assign_id number := fnd_api.g_miss_num,
191 role_id number := fnd_api.g_miss_num,
192 sales_channel varchar2(30) := fnd_api.g_miss_char,
193 object_version_number number := fnd_api.g_miss_num,
194 split_pct number := fnd_api.g_miss_num,
195 split_status varchar2(30) := fnd_api.g_miss_char,
196 commission_amount number := fnd_api.g_miss_num,
197 role_name varchar2(60) := fnd_api.g_miss_char,
198 comp_group_name varchar2(60) := fnd_api.g_miss_char,
199 pre_processed_code_disp varchar2(80) := fnd_api.g_miss_char,
200 customer_name varchar2(50) := fnd_api.g_miss_char,
201 customer_number varchar2(30) := fnd_api.g_miss_char,
202 inventory_item_id number := fnd_api.g_miss_num,
203 source_trx_id number := fnd_api.g_miss_num,
204 source_trx_line_id number := fnd_api.g_miss_num,
205 source_trx_sales_line_id number := fnd_api.g_miss_num,
206 org_id number := fnd_api.g_miss_num,
207 terr_id number := fnd_api.g_miss_num,
208 preserve_credit_override_flag varchar2(1) := fnd_api.g_miss_char,
209 terr_name varchar2(2000) := fnd_api.g_miss_char);
210
211 TYPE adj_tbl_type IS
212 TABLE OF adj_rec_type INDEX BY BINARY_INTEGER ;
213 --
214 TYPE tx_core_data_rec IS RECORD(
215 salesrep_id NUMBER(15),
216 employee_number VARCHAR2(30),
217 salesrep_name VARCHAR2(360),
218 processed_date DATE,
219 processed_period_id NUMBER(15),
220 comm_lines_api_id NUMBER(15),
221 commission_header_id NUMBER,
222 load_status VARCHAR2(30),
223 adjust_status VARCHAR2(20),
224 revenue_type VARCHAR2(15),
225 order_number NUMBER,
226 order_date DATE,
227 invoice_number VARCHAR2(20),
228 invoice_date DATE,
229 transaction_amount NUMBER);
230 --
231 TYPE tx_adj_data_tbl IS TABLE OF tx_core_data_rec
232 INDEX BY BINARY_INTEGER;
233 --
234 TYPE split_data_rec IS RECORD(
235 salesrep_id NUMBER(15),
236 salesrep_number VARCHAR2(30),
237 revenue_type VARCHAR2(15),
238 split_pct NUMBER,
239 split_amount NUMBER);
240 --
241 TYPE split_data_tbl IS TABLE OF split_data_rec
242 INDEX BY BINARY_INTEGER;
243 --
244 TYPE trx_line_rec IS RECORD(
245 commission_line_id NUMBER(15),
246 commission_header_id NUMBER(15),
247 credited_salesrep_id NUMBER(15),
248 credited_salesrep_name VARCHAR2(360), -- For Rosetta Purpose
249 credited_salesrep_number VARCHAR2(30), -- For Rosetta Purpose
250 processed_period_id NUMBER(15),
251 processed_date DATE,
252 plan_element VARCHAR2(80),
253 payment_uplift NUMBER,
254 quota_uplift NUMBER,
255 commission_amount NUMBER,
256 commission_rate NUMBER, -- Changed From NUMBER(10,5) To number
257 -- Bug Fix : 3560705 Hitesh M Thanki
258 created_during VARCHAR2(30),
259 pay_period VARCHAR2(30),
260 accumulation_period VARCHAR2(30),
261 perf_achieved NUMBER,
262 posting_status VARCHAR2(30),
263 pending_status VARCHAR2(30),
264 trx_status VARCHAR2(80),
265 payee VARCHAR2(360));
266 --
267 TYPE trx_line_tbl IS TABLE OF trx_line_rec
268 INDEX BY BINARY_INTEGER;
269 --
270 TYPE cust_info_rec IS RECORD(
271 customer_id NUMBER(15),
272 customer_number VARCHAR2(30),
273 customer_name VARCHAR2(255),
274 bill_to_address_id NUMBER,
275 bill_to_address1 VARCHAR2(240),
276 bill_to_address2 VARCHAR2(240),
277 bill_to_address3 VARCHAR2(240),
278 bill_to_address4 VARCHAR2(240),
279 bill_to_city VARCHAR2(60),
280 bill_to_postal_code VARCHAR2(60),
281 bill_to_state VARCHAR2(60),
282 ship_to_address_id NUMBER,
283 ship_to_address1 VARCHAR2(240),
284 ship_to_address2 VARCHAR2(240),
285 ship_to_address3 VARCHAR2(240),
286 ship_to_address4 VARCHAR2(240),
287 ship_to_city VARCHAR2(60),
288 ship_to_postal_code VARCHAR2(60),
289 ship_to_state VARCHAR2(60),
290 bill_to_contact_id NUMBER,
291 bill_to_contact VARCHAR2(301),
292 ship_to_contact_id NUMBER,
293 ship_to_contact VARCHAR2(301));
294 --
295 TYPE cust_info_tbl IS
296 TABLE OF cust_info_rec INDEX BY BINARY_INTEGER ;
297 --
298 TYPE attribute_rec IS RECORD(
299 attribute_name VARCHAR2(60),
300 attribute_value VARCHAR2(60));
301 --
302 TYPE attribute_tbl IS TABLE OF attribute_rec
303 INDEX BY BINARY_INTEGER;
304 --
305 /*--------------------------------------------------------------------------
306 API name : get_api_data
307 Type : Private
308 Pre-reqs :
309 Usage :
310 Desc : This api get the record information either from the
311 cn_commission_headers or cn_comm_lines_api table based on
312 the api_id given as input parameter.
313 Parameters
314 IN : p_comm_lines_api_id - To fetch the record based on this ID.
315 OUT NOCOPY : x_adj_tbl - This PL/SQL table holds the resultset based
316 on the p_comm_lines_api_id.
317 Notes :
318 --------------------------------------------------------------------------*/
319 PROCEDURE get_api_data(
320 p_comm_lines_api_id IN NUMBER,
321 x_adj_tbl OUT NOCOPY adj_tbl_type);
322 /*--------------------------------------------------------------------------
326 Usage :
323 API name : get_adj
324 Type : Private
325 Pre-reqs :
327 Desc : Get the transaction details based on the search criteria
328 given.
329 Parameters
330 IN : p_salesrep_id - From the transaction summary search page.
331 : p_pr_date_to - From the transaction summary search page.
332 : p_pr_date_from - From the transaction summary search page.
333 : p_calc_status - From the transaction summary search page.
334 : p_order_num - From the transaction summary search page.
335 : p_srch_attr_rec - This record type stores the attribute
336 columns from the advanced search option.
337 : p_first - For the page navigation
338 : p_last - For the page navigation
339 OUT NOCOPY : x_adj_tbl - This PL/SQL table holds the resultset based
340 on the search criteria given.
341 : x_adj_count - This will give the total number of records
342 of the resultset.
343 Notes : This API is used to get the transactions information based
344 on the search criteria given in the cntxsum.jsp.
345 --------------------------------------------------------------------------*/
346 PROCEDURE get_adj (
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
349 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
350 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
351 p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
352 p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
353 p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
354 p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
355 p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
356 p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
357 p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
358 p_order_num IN NUMBER := FND_API.G_MISS_NUM,
359 p_srch_attr_rec IN adj_rec_type,
360 p_first IN NUMBER,
361 p_last IN NUMBER,
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2,
365 x_loading_status OUT NOCOPY VARCHAR2,
366 x_adj_tbl OUT NOCOPY adj_tbl_type,
367 x_adj_count OUT NOCOPY NUMBER,
368 x_valid_trx_count OUT NOCOPY NUMBER);
369 PROCEDURE get_split_data(
370 p_api_version IN NUMBER,
371 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
372 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
373 p_comm_lines_api_id IN NUMBER DEFAULT NULL,
374 p_load_status IN VARCHAR2 DEFAULT NULL,
375 x_return_status OUT NOCOPY VARCHAR2,
376 x_msg_count OUT NOCOPY NUMBER,
377 x_msg_data OUT NOCOPY VARCHAR2,
378 x_loading_status OUT NOCOPY VARCHAR2,
379 x_adj_tbl OUT NOCOPY adj_tbl_type,
380 x_adj_count OUT NOCOPY NUMBER);
381 /*--------------------------------------------------------------------------
382 API name : insert_api_record
383 Type : Private
384 Pre-reqs :
385 Usage :
386 Desc : This API is being called from Insert Transaction Screen
387 (cnnewtx.jsp) to create a new record in the API table. It is
388 also being called from other APIs of Adjustment Module.
389 Parameters
390 IN : p_newtx_rec - This PL/SQL record hold the transaction data
391 to be inserted.
392 OUT NOCOPY : x_api_id - comm_lines_api_id assigned for the above data.
393 Notes :
394 --------------------------------------------------------------------------*/
395 PROCEDURE insert_api_record(
396 p_api_version IN NUMBER,
397 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
398 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
399 p_action IN VARCHAR2 DEFAULT NULL,
400 p_newtx_rec IN adj_rec_type,
401 x_api_id OUT NOCOPY NUMBER,
402 x_return_status OUT NOCOPY VARCHAR2,
403 x_msg_count OUT NOCOPY NUMBER,
404 x_msg_data OUT NOCOPY VARCHAR2,
405 x_loading_status OUT NOCOPY VARCHAR2);
406 /*--------------------------------------------------------------------------
407 API name : call_mass_update
408 Type : Private
409 Pre-reqs :
410 Usage :
411 Desc : This API is being called from Move Credits Screen
412 (cnmvcr.jsp) to move the resultset to a different salesrep.
413 Parameters
414 IN : p_salesrep_id - From the transaction summary search page.
415 : p_pr_date_to - From the transaction summary search page.
416 : p_pr_date_from - From the transaction summary search page.
417 : p_calc_status - From the transaction summary search page.
418 : p_order_num - From the transaction summary search page.
419 : p_srch_attr_rec - This record type stores the attribute
420 columns from the advanced search option.
421 : p_mass_adj_type - Obsoleted Functionality.
422 : p_adj_rec - PL/SQL record to customize the target records.
426 PROCEDURE call_mass_update (
423 OUT NOCOPY :
424 Notes :
425 --------------------------------------------------------------------------*/
427 p_api_version IN NUMBER,
428 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
429 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
430 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
431 p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
432 p_pr_date_to IN DATE := FND_API.G_MISS_DATE,
433 p_pr_date_from IN DATE := FND_API.G_MISS_DATE,
434 p_calc_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
435 p_adj_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
436 p_load_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
437 p_invoice_num IN VARCHAR2 := FND_API.G_MISS_CHAR,
438 p_order_num IN NUMBER := FND_API.G_MISS_NUM,
439 p_srch_attr_rec IN adj_rec_type,
440 p_mass_adj_type IN VARCHAR2 DEFAULT NULL,
441 p_adj_rec IN adj_rec_type,
442 x_return_status OUT NOCOPY VARCHAR2,
443 x_msg_count OUT NOCOPY NUMBER,
444 x_msg_data OUT NOCOPY VARCHAR2,
445 x_loading_status OUT NOCOPY VARCHAR2);
446 /*--------------------------------------------------------------------------
447 API name : call_deal_assign
448 Type : Private
449 Pre-reqs :
450 Usage :
451 Desc : Obsoleted Functionality (Deal Move has been removed)
452 Parameters
453 IN :
454 OUT NOCOPY :
455 Notes :
456 --------------------------------------------------------------------------*/
457 PROCEDURE call_deal_assign(
458 p_api_version IN NUMBER,
459 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
460 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
461 p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
462 p_to_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
463 p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
464 p_order_number IN NUMBER := FND_API.G_MISS_NUM,
465 p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
466 p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
467 x_return_status OUT NOCOPY VARCHAR2,
468 x_msg_count OUT NOCOPY NUMBER,
469 x_msg_data OUT NOCOPY VARCHAR2,
470 x_loading_status OUT NOCOPY VARCHAR2);
471 /*--------------------------------------------------------------------------
472 API name : call_split
473 Type : Private
474 Pre-reqs :
475 Usage :
476 Desc : This API is being called from Split/Deal Split JSP.
477 Parameters
478 IN : p_split_type - Tells Deal Split or Transaction Split
479 : p_comm_lines_api_id - Used for the Transaction Split
480 : p_invoice_number - Used for the Deal Split
481 : p_order_number - Used for the Deal Split
482 : p_transaction_amount - Not Used.
483 : p_adjusted_by - Login User
484 : p_adjust_comments - Adjustment Comments.
485 : p_split_data_tbl - This PL/SQL table holds the split
486 transaction information.
487 OUT NOCOPY :
488 Notes :
489 --------------------------------------------------------------------------*/
490 PROCEDURE call_split(
491 p_api_version IN NUMBER,
492 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
493 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
494 p_split_type IN VARCHAR2,
495 p_from_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
496 p_split_data_tbl IN split_data_tbl,
497 p_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
498 p_invoice_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
499 p_order_number IN NUMBER := FND_API.G_MISS_NUM,
500 p_transaction_amount IN NUMBER,
501 p_adjusted_by IN VARCHAR2 := FND_GLOBAL.USER_NAME,
502 p_adjust_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
503 p_org_id IN NUMBER := FND_API.G_MISS_NUM,
504 x_return_status OUT NOCOPY VARCHAR2,
505 x_msg_count OUT NOCOPY NUMBER,
506 x_msg_data OUT NOCOPY VARCHAR2,
507 x_loading_status OUT NOCOPY VARCHAR2);
508 /*--------------------------------------------------------------------------
509 API name : get_trx_lines
510 Type : Private
511 Pre-reqs :
512 Usage :
513 Desc : This API is being called from Update Transaction JSP. In the
514 Update Transaction JSP, when user selects Transaction Lines
515 from the dropdown box, this API populate the transaction
516 lines data.
517 Parameters
518 IN : p_header_id - To populate the data from cn_commission_lines
519 this ID is needed.
520 OUT NOCOPY : x_trx_line_tbl - This PL/SQL table holds the transaction
521 line information.
522 x_tbl_count - Record Count
523 Notes :
524 --------------------------------------------------------------------------*/
525 PROCEDURE get_trx_lines(
526 p_api_version IN NUMBER,
527 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
528 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
529 p_header_id IN NUMBER := FND_API.G_MISS_NUM,
530 x_return_status OUT NOCOPY VARCHAR2,
534 x_trx_line_tbl OUT NOCOPY trx_line_tbl,
531 x_msg_count OUT NOCOPY NUMBER,
532 x_msg_data OUT NOCOPY VARCHAR2,
533 x_loading_status OUT NOCOPY VARCHAR2,
535 x_tbl_count OUT NOCOPY NUMBER);
536 /*--------------------------------------------------------------------------
537 API name : get_trx_history
538 Type : Private
539 Pre-reqs :
540 Usage :
541 Desc : This API is being called from Update Transaction JSP. In the
542 Update Transaction JSP, when user selects Transaction Hisotry
543 from the dropdown box, this API populate the transaction
544 history data.
545 Parameters
546 IN : p_adj_comm_lines_api_id - To populate the data from API and
547 header tables this ID is being used.
548 OUT NOCOPY : x_adj_tbl - This PL/SQL table holds the transaction history
549 information.
550 x_tbl_count - Record Count
551 Notes :
552 --------------------------------------------------------------------------*/
553 PROCEDURE get_trx_history(
554 p_api_version IN NUMBER,
555 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
556 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
557 p_adj_comm_lines_api_id IN NUMBER := FND_API.G_MISS_NUM,
558 x_return_status OUT NOCOPY VARCHAR2,
559 x_msg_count OUT NOCOPY NUMBER,
560 x_msg_data OUT NOCOPY VARCHAR2,
561 x_loading_status OUT NOCOPY VARCHAR2,
562 x_adj_tbl OUT NOCOPY adj_tbl_type,
563 x_adj_count OUT NOCOPY NUMBER);
564 /*--------------------------------------------------------------------------
565 API name : get_cust_info
566 Type : Private
567 Pre-reqs :
568 Usage :
569 Desc : This API is being called from Update Transaction JSP. In the
570 Update Transaction JSP, when user selects Customer Address
571 from the dropdown box, this API populate the Customer
572 Address Information
573 Parameters
574 IN : p_comm_lines_api_id - To populate the data from API and
575 header tables this ID is being used.
576 OUT NOCOPY : x_cust_info_rec - This PL/SQL record holds the Customer
577 information.
578 Notes :
579 --------------------------------------------------------------------------*/
580 PROCEDURE get_cust_info(
581 p_api_version IN NUMBER,
582 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
583 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
584 p_comm_lines_api_id IN NUMBER,
585 p_load_status IN VARCHAR2,
586 x_return_status OUT NOCOPY VARCHAR2,
587 x_msg_count OUT NOCOPY NUMBER,
588 x_msg_data OUT NOCOPY VARCHAR2,
589 x_loading_status OUT NOCOPY VARCHAR2,
590 x_cust_info_rec OUT NOCOPY cust_info_rec);
591 /*--------------------------------------------------------------------------
592 API name : update_api_record
593 Type : Private
594 Pre-reqs :
595 Usage :
596 Desc : This API is being called from Update Transaction JSP to
597 update a transaction based on the changes made by the user.
598 Parameters
599 IN : p_newtx_rec - This PL/SQL record holds the data needed to
600 create a new transaction in the cn_comm_lines_api table.
601 OUT NOCOPY : x_api_id - comm_lines_api_id assigned for the above data.
602 Notes :
603 --------------------------------------------------------------------------*/
604 PROCEDURE update_api_record(
605 p_api_version IN NUMBER,
606 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
607 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
608 p_newtx_rec IN adj_rec_type,
609 x_api_id OUT NOCOPY NUMBER,
610 x_return_status OUT NOCOPY VARCHAR2,
611 x_msg_count OUT NOCOPY NUMBER,
612 x_msg_data OUT NOCOPY VARCHAR2,
613 x_loading_status OUT NOCOPY VARCHAR2);
614 /*--------------------------------------------------------------------------
615 API name : call_load
616 Type : Private
617 Pre-reqs :
618 Usage :
619 Desc : This API is a wrapper for cn_transaction_load_pub package and
620 it is being called from Load Transactions JSP.
621 Parameters
622 IN : p_salesrep_id - From the Load Transactions page.
623 : p_pr_date_to - From the Load Transactions page.
624 : p_pr_date_from - From the Load Transactions page.
625 : p_cls_rol_flag - Classification Rollup Flag.
626 : p_load_method - Concurrent/Online
627 OUT NOCOPY : x_process_audit_id - Status of the LOAD program.
628 Notes :
629 --------------------------------------------------------------------------*/
630 PROCEDURE call_load(
631 p_api_version IN NUMBER,
632 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
633 p_commit IN VARCHAR2 := FND_API.G_FALSE,
634 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
635 p_salesrep_id IN NUMBER := FND_API.G_MISS_NUM,
636 p_pr_date_from IN DATE,
637 p_pr_date_to IN DATE,
638 p_cls_rol_flag IN CHAR,
642 x_msg_count OUT NOCOPY NUMBER,
639 p_load_method IN VARCHAR2,
640 p_org_id IN NUMBER,
641 x_return_status OUT NOCOPY VARCHAR2,
643 x_msg_data OUT NOCOPY VARCHAR2,
644 x_loading_status OUT NOCOPY VARCHAR2,
645 x_process_audit_id OUT NOCOPY NUMBER);
646 --
647 END cn_get_tx_data_pub;