[Home] [Help]
PACKAGE: APPS.AR_REVENUE_ADJUSTMENT_PVT
Source
1 PACKAGE AR_Revenue_Adjustment_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARXVRADS.pls 120.14 2011/01/05 13:45:17 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 :
310 -- IN : p_api_version NUMBER Required
311 -- p_init_msg_list VARCHAR2 Optional
312 -- Default = FND_API.G_FALSE
313 -- p_commit VARCHAR2 Optional
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 ,p_unearn_zero_dists_flag IN VARCHAR2 DEFAULT 'N');
412
413 PROCEDURE no_rule_debit_credit
414 (p_customer_trx_line_id IN NUMBER
415 ,p_customer_trx_id IN NUMBER
416 ,p_salesrep_id IN NUMBER
417 ,p_revenue_amount IN NUMBER
418 ,p_gl_date IN DATE
419 ,p_credit_ccid IN NUMBER
420 ,p_inventory_item_id IN NUMBER
421 ,p_memo_line_id IN NUMBER
422 ,p_adjustment_id IN NUMBER
423 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL
424 ,p_unearn_zero_dists_flag IN VARCHAR2 DEFAULT 'N');
425
426 /* 5021530 - procedure that does not require salesreps
427 on non-rule transactions */
428 PROCEDURE no_rule_debit_credit_no_sr
429 (p_customer_trx_line_id IN NUMBER
430 ,p_customer_trx_id IN NUMBER
431 ,p_salesrep_id IN NUMBER
432 ,p_revenue_amount IN NUMBER
433 ,p_gl_date IN DATE
434 ,p_credit_ccid IN NUMBER
435 ,p_inventory_item_id IN NUMBER
436 ,p_memo_line_id IN NUMBER
437 ,p_adjustment_id IN NUMBER
438 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL
439 ,p_unearn_zero_dists_flag IN VARCHAR2 DEFAULT 'N');
440
441
442 /* 3879222 - procedure for supporting override of autoacc */
443 PROCEDURE dists_by_model
444 (p_customer_trx_id IN NUMBER DEFAULT NULL
445 ,p_customer_trx_line_id IN NUMBER
446 ,p_revenue_amount IN NUMBER
447 ,p_adjustment_id IN NUMBER
448 ,p_user_generated_flag IN VARCHAR2 DEFAULT NULL
449 ,p_gl_date IN DATE DEFAULT NULL
450 ,p_original_gl_date IN DATE DEFAULT NULL
451 ,p_rule_start_date IN DATE DEFAULT NULL
452 ,p_deferred_revenue_flag IN VARCHAR2 DEFAULT NULL
453 ,p_unearn_zero_dists_flag IN VARCHAR2 DEFAULT 'N');
454
455
456 -----------------------------------------------------------------------
457 -- API name : Transfer_Revenue_Between_Lines
458 -- Type : Private
459 -- Function : Transfers a specified amount of revenue between
460 -- specified transaction lines via a clearing account
461 -- Pre-reqs : Sufficient earned revenue must exist.
462 -- Parameters :
463 -- IN : p_api_version NUMBER Required
464 -- p_init_msg_list VARCHAR2 Optional
465 -- Default = FND_API.G_FALSE
466 -- p_commit VARCHAR2 Optional
467 -- Default = FND_API.G_FALSE
468 -- p_validation_level NUMBER Optional
469 -- Default = FND_API.G_VALID_LEVEL_FULL
470 -- p_rev_adj_rec Rev_Adj_Rec_Type Optional
471 -- OUT NOCOPY : x_return_status VARCHAR2(1)
472 -- x_msg_count NUMBER
473 -- x_msg_data VARCHAR2(2000)
474 -- x_adjustment_id NUMBER
475 -- x_adjustment_number VARCHAR2
476 -- .
477 -- .
478 -- Version : Current version 2.0
479 -- IN parameters consolidated into new record type
480 -- Initial version 1.0
481 --
482 -- Notes : AutoAccounting used for revenue debits and credits
483 --
484
485 -----------------------------------------------------------------------
486 PROCEDURE Transfer_Revenue_Between_Lines
487 ( p_api_version IN NUMBER
488 ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
489 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
490 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
491 ,x_return_status OUT NOCOPY VARCHAR2
492 ,x_msg_count OUT NOCOPY NUMBER
493 ,x_msg_data OUT NOCOPY VARCHAR2
494 ,p_rev_adj_rec IN Rev_Adj_Rec_Type
495 ,x_adjustment_id OUT NOCOPY NUMBER
496 ,x_adjustment_number OUT NOCOPY VARCHAR2);
497
498 PROCEDURE reset_dist_percent
499 (p_customer_trx_line_id IN NUMBER);
500
501 PROCEDURE create_adjustment
502 (p_rev_adj_rec IN Rev_Adj_Rec_Type
503 ,x_adjustment_id OUT NOCOPY NUMBER
504 ,x_adjustment_number OUT NOCOPY VARCHAR2);
505
506 PROCEDURE cr_target_line_unearned
507 (p_customer_trx_line_id IN NUMBER
508 ,p_customer_trx_id IN NUMBER
509 ,p_revenue_amount IN NUMBER
510 ,p_gl_date IN DATE
511 ,p_inventory_item_id IN NUMBER
512 ,p_memo_line_id IN NUMBER
513 ,p_adjustment_id IN NUMBER);
514
515 PROCEDURE insert_distribution (p_customer_trx_line_id IN NUMBER,
516 p_ccid IN NUMBER,
517 p_percent IN NUMBER,
518 p_acctd_amount IN NUMBER,
519 p_gl_date IN DATE,
520 p_orig_gl_date IN DATE,
521 p_account_class IN VARCHAR2,
522 p_amount IN NUMBER,
523 p_cust_trx_line_salesrep_id IN NUMBER,
524 p_customer_trx_id IN NUMBER,
525 p_adjustment_id IN NUMBER,
526 p_user_generated_flag IN VARCHAR2
527 DEFAULT NULL,
528 p_rounding_flag IN VARCHAR2
529 DEFAULT NULL);
530
531 PROCEDURE insert_sales_credit (p_customer_trx_id IN NUMBER,
532 p_salesrep_id IN NUMBER,
533 p_salesgroup_id IN NUMBER,
534 p_cust_trx_line_id IN NUMBER,
535 p_amount IN NUMBER,
536 p_percent IN NUMBER,
537 p_type IN VARCHAR2,
538 p_sales_credit_id IN OUT NOCOPY NUMBER,
539 p_adjustment_id IN NUMBER,
540 p_gl_date IN DATE);
541
542 FUNCTION category_set_id
543 RETURN VARCHAR2;
544
545 FUNCTION inv_org_id
546 RETURN VARCHAR2;
547
548 PROCEDURE Record_Acceptance
549 (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
550 p_category_id IN mtl_categories.category_id%TYPE,
551 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
552 p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
553 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%TYPE,
554 p_comments IN ar_revenue_adjustments.comments%TYPE,
555 p_ram_desc_flexfield IN ar_revenue_management_pvt.desc_flexfield,
556 x_scenario OUT NOCOPY NUMBER,
557 x_first_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
558 x_last_rev_adj_id OUT NOCOPY ar_revenue_adjustments.revenue_adjustment_id%TYPE,
559 x_return_status OUT NOCOPY VARCHAR2,
560 x_msg_count OUT NOCOPY NUMBER,
561 x_msg_data OUT NOCOPY VARCHAR2);
562
563 END AR_Revenue_Adjustment_PVT;