[Home] [Help]
PACKAGE: APPS.AR_REVENUE_ADJUSTMENT_PVT
Source
1 PACKAGE AR_Revenue_Adjustment_PVT AS
2 /*$Header: ARXVRADS.pls 120.11.12010000.2 2008/10/06 18:29:42 mraymond ship $*/
3 g_system_cache_flag VARCHAR2(1) := 'N';
4
5 TYPE RA_Dist_Tbl_Type IS TABLE OF ra_cust_trx_line_gl_dist%ROWTYPE
6 INDEX BY BINARY_INTEGER;
7
8 g_update_db_flag VARCHAR2(1) := 'Y';
9
10 TYPE Rev_Adj_Rec_Type IS RECORD
11 ( CUSTOMER_TRX_ID NUMBER(15)
12 ,TRX_NUMBER RA_CUSTOMER_TRX.trx_number%TYPE
13 ,BATCH_SOURCE_NAME RA_BATCH_SOURCES.name%TYPE
14 ,ADJUSTMENT_TYPE VARCHAR2(15) DEFAULT 'UN'
15 ,FROM_SALESREP_ID NUMBER(15)
16 ,FROM_SALESREP_NUMBER RA_SALESREPS.salesrep_number%TYPE
17 ,TO_SALESREP_ID NUMBER(15)
18 ,TO_SALESREP_NUMBER RA_SALESREPS.salesrep_number%TYPE
19 ,FROM_SALESGROUP_ID jtf_rs_groups_b.group_id%TYPE
20 ,TO_SALESGROUP_ID jtf_rs_groups_b.group_id%TYPE
21 ,SALES_CREDIT_TYPE VARCHAR2(15) DEFAULT 'R'
22 ,AMOUNT_MODE VARCHAR2(15) DEFAULT 'T'
23 ,AMOUNT NUMBER
24 ,PERCENT NUMBER
25 ,LINE_SELECTION_MODE VARCHAR2(15) DEFAULT 'A'
26 ,FROM_CATEGORY_ID NUMBER(15)
27 ,FROM_CATEGORY_SEGMENT1 VARCHAR2(40)
28 ,FROM_CATEGORY_SEGMENT2 VARCHAR2(40)
29 ,FROM_CATEGORY_SEGMENT3 VARCHAR2(40)
30 ,FROM_CATEGORY_SEGMENT4 VARCHAR2(40)
31 ,FROM_CATEGORY_SEGMENT5 VARCHAR2(40)
32 ,FROM_CATEGORY_SEGMENT6 VARCHAR2(40)
33 ,FROM_CATEGORY_SEGMENT7 VARCHAR2(40)
34 ,FROM_CATEGORY_SEGMENT8 VARCHAR2(40)
35 ,FROM_CATEGORY_SEGMENT9 VARCHAR2(40)
36 ,FROM_CATEGORY_SEGMENT10 VARCHAR2(40)
37 ,FROM_CATEGORY_SEGMENT11 VARCHAR2(40)
38 ,FROM_CATEGORY_SEGMENT12 VARCHAR2(40)
39 ,FROM_CATEGORY_SEGMENT13 VARCHAR2(40)
40 ,FROM_CATEGORY_SEGMENT14 VARCHAR2(40)
41 ,FROM_CATEGORY_SEGMENT15 VARCHAR2(40)
42 ,FROM_CATEGORY_SEGMENT16 VARCHAR2(40)
43 ,FROM_CATEGORY_SEGMENT17 VARCHAR2(40)
44 ,FROM_CATEGORY_SEGMENT18 VARCHAR2(40)
45 ,FROM_CATEGORY_SEGMENT19 VARCHAR2(40)
46 ,FROM_CATEGORY_SEGMENT20 VARCHAR2(40)
47 ,TO_CATEGORY_ID NUMBER(15)
48 ,TO_CATEGORY_SEGMENT1 VARCHAR2(40)
49 ,TO_CATEGORY_SEGMENT2 VARCHAR2(40)
50 ,TO_CATEGORY_SEGMENT3 VARCHAR2(40)
51 ,TO_CATEGORY_SEGMENT4 VARCHAR2(40)
52 ,TO_CATEGORY_SEGMENT5 VARCHAR2(40)
53 ,TO_CATEGORY_SEGMENT6 VARCHAR2(40)
54 ,TO_CATEGORY_SEGMENT7 VARCHAR2(40)
55 ,TO_CATEGORY_SEGMENT8 VARCHAR2(40)
56 ,TO_CATEGORY_SEGMENT9 VARCHAR2(40)
57 ,TO_CATEGORY_SEGMENT10 VARCHAR2(40)
58 ,TO_CATEGORY_SEGMENT11 VARCHAR2(40)
59 ,TO_CATEGORY_SEGMENT12 VARCHAR2(40)
60 ,TO_CATEGORY_SEGMENT13 VARCHAR2(40)
61 ,TO_CATEGORY_SEGMENT14 VARCHAR2(40)
62 ,TO_CATEGORY_SEGMENT15 VARCHAR2(40)
63 ,TO_CATEGORY_SEGMENT16 VARCHAR2(40)
64 ,TO_CATEGORY_SEGMENT17 VARCHAR2(40)
65 ,TO_CATEGORY_SEGMENT18 VARCHAR2(40)
66 ,TO_CATEGORY_SEGMENT19 VARCHAR2(40)
67 ,TO_CATEGORY_SEGMENT20 VARCHAR2(40)
68 ,FROM_INVENTORY_ITEM_ID NUMBER(15)
69 ,FROM_ITEM_SEGMENT1 VARCHAR2(40)
70 ,FROM_ITEM_SEGMENT2 VARCHAR2(40)
71 ,FROM_ITEM_SEGMENT3 VARCHAR2(40)
72 ,FROM_ITEM_SEGMENT4 VARCHAR2(40)
73 ,FROM_ITEM_SEGMENT5 VARCHAR2(40)
74 ,FROM_ITEM_SEGMENT6 VARCHAR2(40)
75 ,FROM_ITEM_SEGMENT7 VARCHAR2(40)
76 ,FROM_ITEM_SEGMENT8 VARCHAR2(40)
77 ,FROM_ITEM_SEGMENT9 VARCHAR2(40)
78 ,FROM_ITEM_SEGMENT10 VARCHAR2(40)
79 ,FROM_ITEM_SEGMENT11 VARCHAR2(40)
80 ,FROM_ITEM_SEGMENT12 VARCHAR2(40)
81 ,FROM_ITEM_SEGMENT13 VARCHAR2(40)
82 ,FROM_ITEM_SEGMENT14 VARCHAR2(40)
83 ,FROM_ITEM_SEGMENT15 VARCHAR2(40)
84 ,FROM_ITEM_SEGMENT16 VARCHAR2(40)
85 ,FROM_ITEM_SEGMENT17 VARCHAR2(40)
86 ,FROM_ITEM_SEGMENT18 VARCHAR2(40)
87 ,FROM_ITEM_SEGMENT19 VARCHAR2(40)
88 ,FROM_ITEM_SEGMENT20 VARCHAR2(40)
89 ,TO_INVENTORY_ITEM_ID NUMBER(15)
90 ,TO_ITEM_SEGMENT1 VARCHAR2(40)
91 ,TO_ITEM_SEGMENT2 VARCHAR2(40)
92 ,TO_ITEM_SEGMENT3 VARCHAR2(40)
93 ,TO_ITEM_SEGMENT4 VARCHAR2(40)
94 ,TO_ITEM_SEGMENT5 VARCHAR2(40)
95 ,TO_ITEM_SEGMENT6 VARCHAR2(40)
96 ,TO_ITEM_SEGMENT7 VARCHAR2(40)
97 ,TO_ITEM_SEGMENT8 VARCHAR2(40)
98 ,TO_ITEM_SEGMENT9 VARCHAR2(40)
99 ,TO_ITEM_SEGMENT10 VARCHAR2(40)
100 ,TO_ITEM_SEGMENT11 VARCHAR2(40)
101 ,TO_ITEM_SEGMENT12 VARCHAR2(40)
102 ,TO_ITEM_SEGMENT13 VARCHAR2(40)
103 ,TO_ITEM_SEGMENT14 VARCHAR2(40)
104 ,TO_ITEM_SEGMENT15 VARCHAR2(40)
105 ,TO_ITEM_SEGMENT16 VARCHAR2(40)
106 ,TO_ITEM_SEGMENT17 VARCHAR2(40)
107 ,TO_ITEM_SEGMENT18 VARCHAR2(40)
108 ,TO_ITEM_SEGMENT19 VARCHAR2(40)
109 ,TO_ITEM_SEGMENT20 VARCHAR2(40)
110 ,FROM_CUST_TRX_LINE_ID NUMBER(15)
111 ,FROM_LINE_NUMBER NUMBER(15)
112 ,TO_CUST_TRX_LINE_ID NUMBER(15)
113 ,TO_LINE_NUMBER NUMBER(15)
114 ,GL_DATE DATE
115 ,REASON_CODE VARCHAR2(15)
116 ,COMMENTS VARCHAR2(2000)
117 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
118 ,ATTRIBUTE1 VARCHAR2(150)
119 ,ATTRIBUTE2 VARCHAR2(150)
120 ,ATTRIBUTE3 VARCHAR2(150)
121 ,ATTRIBUTE4 VARCHAR2(150)
122 ,ATTRIBUTE5 VARCHAR2(150)
123 ,ATTRIBUTE6 VARCHAR2(150)
124 ,ATTRIBUTE7 VARCHAR2(150)
125 ,ATTRIBUTE8 VARCHAR2(150)
126 ,ATTRIBUTE9 VARCHAR2(150)
127 ,ATTRIBUTE10 VARCHAR2(150)
128 ,ATTRIBUTE11 VARCHAR2(150)
129 ,ATTRIBUTE12 VARCHAR2(150)
130 ,ATTRIBUTE13 VARCHAR2(150)
131 ,ATTRIBUTE14 VARCHAR2(150)
132 ,ATTRIBUTE15 VARCHAR2(150)
133 ,SOURCE VARCHAR2(30) DEFAULT NULL
134 );
135
136 TYPE Segment_Rec_Type IS RECORD
137 ( segment1 VARCHAR2(40)
138 ,segment2 VARCHAR2(40)
139 ,segment3 VARCHAR2(40)
140 ,segment4 VARCHAR2(40)
141 ,segment5 VARCHAR2(40)
142 ,segment6 VARCHAR2(40)
143 ,segment7 VARCHAR2(40)
144 ,segment8 VARCHAR2(40)
145 ,segment9 VARCHAR2(40)
146 ,segment10 VARCHAR2(40)
147 ,segment11 VARCHAR2(40)
148 ,segment12 VARCHAR2(40)
149 ,segment13 VARCHAR2(40)
150 ,segment14 VARCHAR2(40)
151 ,segment15 VARCHAR2(40)
152 ,segment16 VARCHAR2(40)
153 ,segment17 VARCHAR2(40)
154 ,segment18 VARCHAR2(40)
155 ,segment19 VARCHAR2(40)
156 ,segment20 VARCHAR2(40));
157
158 -----------------------------------------------------------------------
159 -- API name : Unearn_Revenue
160 -- Type : Private
161 -- Function : Transfers a specified amount of revenue from
162 -- earned to unearned revenue account
163 -- Pre-reqs : Sufficient earned revenue must exist.
164 -- Parameters :
165 -- IN : p_api_version NUMBER Required
166 -- p_init_msg_list VARCHAR2 Optional
167 -- Default = FND_API.G_FALSE
168 -- p_commit VARCHAR2 Optional
169 -- Default = FND_API.G_FALSE
170 -- p_validation_level NUMBER Optional
171 -- Default = FND_API.G_VALID_LEVEL_FULL
172 -- p_rev_adj_rec Rev_Adj_Rec_Type Required
173 -- OUT NOCOPY : x_return_status VARCHAR2(1)
174 -- x_msg_count NUMBER
175 -- x_msg_data VARCHAR2(2000)
176 -- x_adjustment_id NUMBER
177 -- x_adjustment_number VARCHAR2
178 -- .
179 -- .
180 -- Version : Current version 2.0
181 -- IN parameters consolidated into new record type
182 -- Initial version 1.0
183 --
184 -- Notes : AutoAccounting used for both debits and credits
185 --
186
187 -----------------------------------------------------------------------
188 PROCEDURE Unearn_Revenue
189 ( p_api_version IN NUMBER
190 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
191 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
192 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
193 ,x_return_status OUT NOCOPY VARCHAR2
194 ,x_msg_count OUT NOCOPY NUMBER
195 ,x_msg_data OUT NOCOPY VARCHAR2
196 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
197 ,x_adjustment_id OUT NOCOPY NUMBER
198 ,x_adjustment_number OUT NOCOPY VARCHAR2);
199
200 -----------------------------------------------------------------------
201 -- API name : Earn_Revenue
202 -- Type : Private
203 -- Function : Transfers a specified amount of revenue from
204 -- unearned to earned revenue account
205 -- Pre-reqs : Sufficient unearned revenue must exist.
206 -- Parameters :
207 -- IN : p_api_version NUMBER Required
208 -- p_init_msg_list VARCHAR2 Optional
209 -- Default = FND_API.G_FALSE
210 -- p_commit VARCHAR2 Optional
211 -- Default = FND_API.G_FALSE
212 -- p_validation_level NUMBER Optional
213 -- Default = FND_API.G_VALID_LEVEL_FULL
214 -- p_rev_adj_rec Rev_Adj_Rec_Type Required
215 -- OUT NOCOPY : x_return_status VARCHAR2(1)
216 -- x_msg_count NUMBER
217 -- x_msg_data VARCHAR2(2000)
218 -- x_adjustment_id NUMBER
219 -- x_adjustment_number VARCHAR2
220 -- .
221 -- .
222 -- Version : Current version 2.0
223 -- IN parameters consolidated into new record type
224 -- Initial version 1.0
225 --
226 -- Notes : AutoAccounting used for both debits and credits
227 --
228 -----------------------------------------------------------------------
229 PROCEDURE Earn_Revenue
230 ( p_api_version IN NUMBER
231 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
232 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
233 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
234 ,x_return_status OUT NOCOPY VARCHAR2
235 ,x_msg_count OUT NOCOPY NUMBER
236 ,x_msg_data OUT NOCOPY VARCHAR2
237 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
238 ,x_adjustment_id OUT NOCOPY NUMBER
239 ,x_adjustment_number OUT NOCOPY VARCHAR2);
240
241 -----------------------------------------------------------------------
242 --OVERLOADED EARN_REVENUE procedure
243 --
244 --NOTE : This procedure is not published and must not be used by customers
245 --
246 -- API name : Earn_Revenue
247 -- Type : Private
248 -- Function : Transfers a specified amount of revenue from
249 -- unearned to earned revenue account
250 -- Pre-reqs : Sufficient unearned revenue must exist.
251 -- Parameters :
252 -- IN : p_api_version NUMBER Required
253 -- p_init_msg_list VARCHAR2 Optional
254 -- Default = FND_API.G_FALSE
255 -- p_commit VARCHAR2 Optional
256 -- Default = FND_API.G_FALSE
257 -- p_validation_level NUMBER Optional
258 -- Default = FND_API.G_VALID_LEVEL_FULL
259 -- p_rev_adj_rec Rev_Adj_Rec_Type Required
260 -- OUT NOCOPY : x_return_status VARCHAR2(1)
261 -- x_msg_count NUMBER
262 -- x_msg_data VARCHAR2(2000)
263 -- x_adjustment_id NUMBER
264 -- x_adjustment_number VARCHAR2
265 -- x_ra_dist_tbl RA_Dist_Tbl_Type
266 -- .
267 -- .
268 -- Version : Current version 2.0
269 -- IN parameters consolidated into new record type
270 -- Initial version 1.0
271 --
272 -- Notes : AutoAccounting used for both debits and credits
273 -- Does not write to database, instead it passes
274 -- new distribution data back to calling routine
275 -- in a pl/sql table parameter
276 -----------------------------------------------------------------------
277 PROCEDURE Earn_Revenue
278 ( p_api_version IN NUMBER
279 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
280 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
281 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
282 ,x_return_status OUT NOCOPY VARCHAR2
283 ,x_msg_count OUT NOCOPY NUMBER
284 ,x_msg_data OUT NOCOPY VARCHAR2
285 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
286 ,x_adjustment_id OUT NOCOPY NUMBER
287 ,x_adjustment_number OUT NOCOPY VARCHAR2
288 ,x_dist_count OUT NOCOPY NUMBER
289 ,x_ra_dist_tbl OUT NOCOPY RA_Dist_Tbl_Type);
290
291 PROCEDURE earn_or_unearn
292 (p_rev_adj_rec IN Rev_Adj_Rec_Type
293 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
294 ,x_return_status OUT NOCOPY VARCHAR2
295 ,x_msg_count OUT NOCOPY NUMBER
296 ,x_msg_data OUT NOCOPY VARCHAR2
297 ,x_adjustment_id OUT NOCOPY NUMBER
298 ,x_adjustment_number OUT NOCOPY VARCHAR2);
299
300 -----------------------------------------------------------------------
301 -- API name : Transfer_Sales_Credits
302 -- Type : Private
303 -- Function : Transfers revenue and/or non revenue sales credits
304 -- between the specified salesreps. The associated
305 -- earned revenue is transferred with revenue sales
306 -- credits
307 -- Pre-reqs : Sufficient earned revenue must exist for the salesrep
308 -- from whom sales credits are being transferred.
309 -- Parameters :
313 -- p_commit VARCHAR2 Optional
310 -- IN : p_api_version NUMBER Required
311 -- p_init_msg_list VARCHAR2 Optional
312 -- Default = FND_API.G_FALSE
314 -- Default = FND_API.G_FALSE
315 -- p_validation_level NUMBER Optional
316 -- Default = FND_API.G_VALID_LEVEL_FULL
317 -- p_rev_adj_rec Rev_Adj_Rec_Type Required
318 -- OUT NOCOPY : x_return_status VARCHAR2(1)
319 -- x_msg_count NUMBER
320 -- x_msg_data VARCHAR2(2000)
321 -- x_adjustment_id NUMBER
322 -- x_adjustment_number VARCHAR2
323 --
324 -- Version : Current version 2.0
325 -- IN parameters consolidated into new record type
326 -- Initial version 1.0
327 --
328 -- Notes : AutoAccounting used for both debits and credits
329 --
330 -----------------------------------------------------------------------
331
332 PROCEDURE Transfer_Sales_Credits
333 ( p_api_version IN NUMBER
334 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
335 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
336 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
337 ,x_return_status OUT NOCOPY VARCHAR2
338 ,x_msg_count OUT NOCOPY NUMBER
339 ,x_msg_data OUT NOCOPY VARCHAR2
340 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
341 ,x_adjustment_id OUT NOCOPY NUMBER
342 ,x_adjustment_number OUT NOCOPY VARCHAR2);
343
344 -----------------------------------------------------------------------
345 -- API name : Add_Non_Revenue_Sales_Credits
346 -- Type : Private
347 -- Function : Adds non revenue sales credits to the specified
348 -- salesrep subject to any maximum limit of revenue
349 -- and non revenue salsescredit per salesrep per line
350 -- as defined in the sales credit percent limit in
351 -- system options.
352 -- Pre-reqs : None
353 --
354 -- Parameters :
355 -- IN : p_api_version NUMBER Required
356 -- p_init_msg_list VARCHAR2 Optional
357 -- Default = FND_API.G_FALSE
358 -- p_commit VARCHAR2 Optional
359 -- Default = FND_API.G_FALSE
360 -- p_validation_level NUMBER Optional
361 -- Default = FND_API.G_VALID_LEVEL_FULL
362 -- p_rev_adj_rec Rev_Adj_Rec_Type Optional
363 -- OUT NOCOPY : x_return_status VARCHAR2(1)
364 -- x_msg_count NUMBER
365 -- x_msg_data VARCHAR2(2000)
366 -- x_adjustment_id NUMBER
367 -- x_adjustment_number VARCHAR2
368 --
369 -- Version : Current version 2.0
370 -- IN parameters consolidated into new record type
371 -- Initial version 1.0
372 --
373 -- Notes :
374 --
375 PROCEDURE Add_Non_Revenue_Sales_Credits
376 ( p_api_version IN NUMBER
377 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
378 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
379 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
380 ,x_return_status OUT NOCOPY VARCHAR2
381 ,x_msg_count OUT NOCOPY NUMBER
382 ,x_msg_data OUT NOCOPY VARCHAR2
383 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
384 ,x_adjustment_id OUT NOCOPY NUMBER
385 ,x_adjustment_number OUT NOCOPY VARCHAR2);
386
387 PROCEDURE transfer_salesrep_revenue
388 (p_customer_trx_line_id IN NUMBER
389 ,p_customer_trx_id IN NUMBER
390 ,p_sales_credit_id IN NUMBER
391 ,p_revenue_amount IN NUMBER
392 ,p_revenue_acctd_amount IN NUMBER
393 ,p_gl_date IN DATE
394 ,p_ccid IN NUMBER
395 ,p_last_salesrep_flag IN VARCHAR2
396 ,p_line_amount IN NUMBER
397 ,p_line_amount_acctd IN NUMBER
398 ,p_adjustment_id IN NUMBER);
399
400 PROCEDURE debit_credit
401 (p_customer_trx_line_id IN NUMBER
402 ,p_customer_trx_id IN NUMBER
403 ,p_salesrep_id IN NUMBER
404 ,p_revenue_amount IN NUMBER
405 ,p_gl_date IN DATE
406 ,p_credit_ccid IN NUMBER
407 ,p_inventory_item_id IN NUMBER
408 ,p_memo_line_id IN NUMBER
409 ,p_adjustment_id IN NUMBER
410 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL);
411
412 PROCEDURE no_rule_debit_credit
413 (p_customer_trx_line_id IN NUMBER
414 ,p_customer_trx_id IN NUMBER
415 ,p_salesrep_id IN NUMBER
416 ,p_revenue_amount IN NUMBER
417 ,p_gl_date IN DATE
418 ,p_credit_ccid IN NUMBER
422 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL);
419 ,p_inventory_item_id IN NUMBER
420 ,p_memo_line_id IN NUMBER
421 ,p_adjustment_id IN NUMBER
423
424 /* 5021530 - procedure that does not require salesreps
425 on non-rule transactions */
426 PROCEDURE no_rule_debit_credit_no_sr
427 (p_customer_trx_line_id IN NUMBER
428 ,p_customer_trx_id IN NUMBER
429 ,p_salesrep_id IN NUMBER
430 ,p_revenue_amount IN NUMBER
431 ,p_gl_date IN DATE
432 ,p_credit_ccid IN NUMBER
433 ,p_inventory_item_id IN NUMBER
434 ,p_memo_line_id IN NUMBER
435 ,p_adjustment_id IN NUMBER
436 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL);
437
438
439 /* 3879222 - procedure for supporting override of autoacc */
440 PROCEDURE dists_by_model
441 (p_customer_trx_line_id IN NUMBER
442 ,p_revenue_amount IN NUMBER
443 ,p_adjustment_id IN NUMBER
444 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL
445 ,p_gl_date IN DATE DEFAULT NULL);
446
447 -----------------------------------------------------------------------
448 -- API name : Transfer_Revenue_Between_Lines
449 -- Type : Private
450 -- Function : Transfers a specified amount of revenue between
451 -- specified transaction lines via a clearing account
452 -- Pre-reqs : Sufficient earned revenue must exist.
453 -- Parameters :
454 -- IN : p_api_version NUMBER Required
455 -- p_init_msg_list VARCHAR2 Optional
456 -- Default = FND_API.G_FALSE
457 -- p_commit VARCHAR2 Optional
458 -- Default = FND_API.G_FALSE
459 -- p_validation_level NUMBER Optional
460 -- Default = FND_API.G_VALID_LEVEL_FULL
461 -- p_rev_adj_rec Rev_Adj_Rec_Type Optional
462 -- OUT NOCOPY : x_return_status VARCHAR2(1)
463 -- x_msg_count NUMBER
464 -- x_msg_data VARCHAR2(2000)
465 -- x_adjustment_id NUMBER
466 -- x_adjustment_number VARCHAR2
467 -- .
468 -- .
469 -- Version : Current version 2.0
470 -- IN parameters consolidated into new record type
471 -- Initial version 1.0
472 --
473 -- Notes : AutoAccounting used for revenue debits and credits
474 --
475
476 -----------------------------------------------------------------------
477 PROCEDURE Transfer_Revenue_Between_Lines
478 ( p_api_version IN NUMBER
479 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
480 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
481 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
482 ,x_return_status OUT NOCOPY VARCHAR2
483 ,x_msg_count OUT NOCOPY NUMBER
484 ,x_msg_data OUT NOCOPY VARCHAR2
485 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
486 ,x_adjustment_id OUT NOCOPY NUMBER
487 ,x_adjustment_number OUT NOCOPY VARCHAR2);
488
489 PROCEDURE reset_dist_percent
490 (p_customer_trx_line_id IN NUMBER);
491
492 PROCEDURE create_adjustment
493 (p_rev_adj_rec IN Rev_Adj_Rec_Type
494 ,x_adjustment_id OUT NOCOPY NUMBER
495 ,x_adjustment_number OUT NOCOPY VARCHAR2);
496
497 PROCEDURE cr_target_line_unearned
498 (p_customer_trx_line_id IN NUMBER
499 ,p_customer_trx_id IN NUMBER
500 ,p_revenue_amount IN NUMBER
501 ,p_gl_date IN DATE
502 ,p_inventory_item_id IN NUMBER
503 ,p_memo_line_id IN NUMBER
504 ,p_adjustment_id IN NUMBER);
505
506 PROCEDURE insert_distribution (p_customer_trx_line_id IN NUMBER,
507 p_ccid IN NUMBER,
508 p_percent IN NUMBER,
509 p_acctd_amount IN NUMBER,
510 p_gl_date IN DATE,
511 p_orig_gl_date IN DATE,
512 p_account_class IN VARCHAR2,
513 p_amount IN NUMBER,
514 p_cust_trx_line_salesrep_id IN NUMBER,
515 p_customer_trx_id IN NUMBER,
516 p_adjustment_id IN NUMBER,
517 p_user_generated_flag IN VARCHAR2
518 DEFAULT NULL,
519 p_rounding_flag IN VARCHAR2
520 DEFAULT NULL);
521
522 PROCEDURE insert_sales_credit (p_customer_trx_id IN NUMBER,
523 p_salesrep_id IN NUMBER,
524 p_salesgroup_id IN NUMBER,
525 p_cust_trx_line_id IN NUMBER,
526 p_amount IN NUMBER,
527 p_percent IN NUMBER,
528 p_type IN VARCHAR2,
529 p_sales_credit_id IN OUT NOCOPY NUMBER,
530 p_adjustment_id IN NUMBER,
531 p_gl_date IN DATE);
532
533 FUNCTION category_set_id
534 RETURN VARCHAR2;
535
536 FUNCTION inv_org_id
537 RETURN VARCHAR2;
538
539 PROCEDURE Record_Acceptance
540 (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
541 p_category_id IN mtl_categories.category_id%TYPE,
542 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
543 p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
544 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
545 p_comments IN ar_revenue_adjustments.comments%TYPE,
546 p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
547 x_scenario OUT NOCOPY NUMBER,
548 x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
549 x_last_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
550 x_return_status OUT NOCOPY VARCHAR2,
551 x_msg_count OUT NOCOPY NUMBER,
552 x_msg_data OUT NOCOPY VARCHAR2);
553
554 END AR_Revenue_Adjustment_PVT;