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
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)
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)
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
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
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
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
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)
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)
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
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
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
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
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)
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)
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
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
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
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
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
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)
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)
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
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
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
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
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)
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)
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
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
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
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
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)
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)
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
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
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