233: -- NOTES
234: ---------------------------------------------------------------------
235: PROCEDURE Update_Batch_Calculations (
236: p_api_version IN NUMBER
237: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
239: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240: ,p_resale_batch_id IN NUMBER
241: ,x_return_status OUT NOCOPY VARCHAR2
234: ---------------------------------------------------------------------
235: PROCEDURE Update_Batch_Calculations (
236: p_api_version IN NUMBER
237: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
239: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240: ,p_resale_batch_id IN NUMBER
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_data OUT NOCOPY VARCHAR2
235: PROCEDURE Update_Batch_Calculations (
236: p_api_version IN NUMBER
237: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
238: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
239: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
240: ,p_resale_batch_id IN NUMBER
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_data OUT NOCOPY VARCHAR2
243: ,x_msg_count OUT NOCOPY NUMBER
277: -- NOTES
278: ---------------------------------------------------------------------
279: PROCEDURE Validate_Batch(
280: p_api_version IN NUMBER
281: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
282: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
283: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284: ,p_resale_batch_id IN NUMBER
285: ,x_batch_status OUT NOCOPY VARCHAR2
278: ---------------------------------------------------------------------
279: PROCEDURE Validate_Batch(
280: p_api_version IN NUMBER
281: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
282: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
283: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284: ,p_resale_batch_id IN NUMBER
285: ,x_batch_status OUT NOCOPY VARCHAR2
286: ,x_return_status OUT NOCOPY VARCHAR2
279: PROCEDURE Validate_Batch(
280: p_api_version IN NUMBER
281: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
282: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
283: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284: ,p_resale_batch_id IN NUMBER
285: ,x_batch_status OUT NOCOPY VARCHAR2
286: ,x_return_status OUT NOCOPY VARCHAR2
287: ,x_msg_data OUT NOCOPY VARCHAR2
302: -- NOTES
303: ---------------------------------------------------------------------
304: PROCEDURE Validate_Order_Record(
305: p_api_version IN NUMBER
306: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
308: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
309: ,p_resale_batch_id IN NUMBER
310: ,x_return_status OUT NOCOPY VARCHAR2
303: ---------------------------------------------------------------------
304: PROCEDURE Validate_Order_Record(
305: p_api_version IN NUMBER
306: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
308: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
309: ,p_resale_batch_id IN NUMBER
310: ,x_return_status OUT NOCOPY VARCHAR2
311: ,x_msg_data OUT NOCOPY VARCHAR2
304: PROCEDURE Validate_Order_Record(
305: p_api_version IN NUMBER
306: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
307: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
308: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
309: ,p_resale_batch_id IN NUMBER
310: ,x_return_status OUT NOCOPY VARCHAR2
311: ,x_msg_data OUT NOCOPY VARCHAR2
312: ,x_msg_count OUT NOCOPY NUMBER
325: -- NOTES
326: ---------------------------------------------------------------------
327: PROCEDURE Update_Duplicates (
328: p_api_version IN NUMBER
329: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
330: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
331: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
332: ,p_resale_batch_id IN NUMBER
333: ,p_resale_batch_type IN VARCHAR2
326: ---------------------------------------------------------------------
327: PROCEDURE Update_Duplicates (
328: p_api_version IN NUMBER
329: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
330: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
331: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
332: ,p_resale_batch_id IN NUMBER
333: ,p_resale_batch_type IN VARCHAR2
334: ,p_batch_status IN VARCHAR2
327: PROCEDURE Update_Duplicates (
328: p_api_version IN NUMBER
329: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
330: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
331: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
332: ,p_resale_batch_id IN NUMBER
333: ,p_resale_batch_type IN VARCHAR2
334: ,p_batch_status IN VARCHAR2
335: ,x_batch_status OUT NOCOPY VARCHAR2
351: -- NOTES
352: ---------------------------------------------------------------------
353: PROCEDURE Check_Duplicate_Line(
354: p_api_version_number IN NUMBER
355: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358: ,p_resale_line_int_id IN NUMBER
359: ,p_direct_customer_flag IN VARCHAR2
352: ---------------------------------------------------------------------
353: PROCEDURE Check_Duplicate_Line(
354: p_api_version_number IN NUMBER
355: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358: ,p_resale_line_int_id IN NUMBER
359: ,p_direct_customer_flag IN VARCHAR2
360: ,p_claimed_amount IN NUMBER
353: PROCEDURE Check_Duplicate_Line(
354: p_api_version_number IN NUMBER
355: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358: ,p_resale_line_int_id IN NUMBER
359: ,p_direct_customer_flag IN VARCHAR2
360: ,p_claimed_amount IN NUMBER
361: ,p_batch_type IN VARCHAR2
380: -- NOTES
381: ---------------------------------------------------------------------
382: PROCEDURE Create_Utilization(
383: p_api_version IN NUMBER
384: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
385: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
386: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
387: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
388: ,p_fund_id IN NUMBER
381: ---------------------------------------------------------------------
382: PROCEDURE Create_Utilization(
383: p_api_version IN NUMBER
384: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
385: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
386: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
387: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
388: ,p_fund_id IN NUMBER
389: ,p_line_id IN NUMBER
382: PROCEDURE Create_Utilization(
383: p_api_version IN NUMBER
384: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
385: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
386: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
387: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
388: ,p_fund_id IN NUMBER
389: ,p_line_id IN NUMBER
390: ,p_cust_account_id IN NUMBER
407: -- NOTES
408: ---------------------------------------------------------------------
409: PROCEDURE Create_Adj_And_Utilization(
410: p_api_version IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
414: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
415: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
408: ---------------------------------------------------------------------
409: PROCEDURE Create_Adj_And_Utilization(
410: p_api_version IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
414: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
415: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
416: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
409: PROCEDURE Create_Adj_And_Utilization(
410: p_api_version IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
414: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
415: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
416: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
417: ,p_to_create_utilization IN BOOLEAN
436: --
437: ---------------------------------------------------------------------
438: PROCEDURE Create_Sales_Transaction(
439: p_api_version IN NUMBER
440: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
441: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
442: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
443: ,p_line_int_rec IN g_interface_rec_csr%rowtype
444: ,p_header_id IN NUMBER
437: ---------------------------------------------------------------------
438: PROCEDURE Create_Sales_Transaction(
439: p_api_version IN NUMBER
440: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
441: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
442: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
443: ,p_line_int_rec IN g_interface_rec_csr%rowtype
444: ,p_header_id IN NUMBER
445: ,p_line_id IN NUMBER
438: PROCEDURE Create_Sales_Transaction(
439: p_api_version IN NUMBER
440: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
441: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
442: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
443: ,p_line_int_rec IN g_interface_rec_csr%rowtype
444: ,p_header_id IN NUMBER
445: ,p_line_id IN NUMBER
446: ,x_sales_transaction_id OUT NOCOPY NUMBER
465: --
466: ---------------------------------------------------------------------
467: PROCEDURE Insert_Resale_Header(
468: p_api_version IN NUMBER
469: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
470: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
471: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
472: ,p_line_int_rec IN g_interface_rec_csr%rowtype
473: ,x_header_id OUT NOCOPY NUMBER
466: ---------------------------------------------------------------------
467: PROCEDURE Insert_Resale_Header(
468: p_api_version IN NUMBER
469: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
470: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
471: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
472: ,p_line_int_rec IN g_interface_rec_csr%rowtype
473: ,x_header_id OUT NOCOPY NUMBER
474: ,x_return_status OUT NOCOPY VARCHAR2
467: PROCEDURE Insert_Resale_Header(
468: p_api_version IN NUMBER
469: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
470: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
471: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
472: ,p_line_int_rec IN g_interface_rec_csr%rowtype
473: ,x_header_id OUT NOCOPY NUMBER
474: ,x_return_status OUT NOCOPY VARCHAR2
475: ,x_msg_data OUT NOCOPY VARCHAR2
491: --
492: ---------------------------------------------------------------------
493: PROCEDURE Insert_Resale_Line(
494: p_api_version IN NUMBER
495: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
496: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
497: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
498: ,p_line_int_rec IN g_interface_rec_csr%rowtype
499: ,p_header_id IN NUMBER
492: ---------------------------------------------------------------------
493: PROCEDURE Insert_Resale_Line(
494: p_api_version IN NUMBER
495: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
496: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
497: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
498: ,p_line_int_rec IN g_interface_rec_csr%rowtype
499: ,p_header_id IN NUMBER
500: ,x_line_id OUT NOCOPY NUMBER
493: PROCEDURE Insert_Resale_Line(
494: p_api_version IN NUMBER
495: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
496: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
497: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
498: ,p_line_int_rec IN g_interface_rec_csr%rowtype
499: ,p_header_id IN NUMBER
500: ,x_line_id OUT NOCOPY NUMBER
501: ,x_return_status OUT NOCOPY VARCHAR2
518: --
519: ---------------------------------------------------------------------
520: PROCEDURE Insert_Resale_Line_Mapping(
521: p_api_version IN NUMBER
522: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
523: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
524: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525: ,p_resale_batch_id IN NUMBER
526: ,p_line_id IN NUMBER
519: ---------------------------------------------------------------------
520: PROCEDURE Insert_Resale_Line_Mapping(
521: p_api_version IN NUMBER
522: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
523: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
524: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525: ,p_resale_batch_id IN NUMBER
526: ,p_line_id IN NUMBER
527: ,x_return_status OUT NOCOPY VARCHAR2
520: PROCEDURE Insert_Resale_Line_Mapping(
521: p_api_version IN NUMBER
522: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
523: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
524: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
525: ,p_resale_batch_id IN NUMBER
526: ,p_line_id IN NUMBER
527: ,x_return_status OUT NOCOPY VARCHAR2
528: ,x_msg_data OUT NOCOPY VARCHAR2
542: -- NOTES
543: -----------------------------------------------------------------------
544: PROCEDURE Delete_Log(
545: p_api_version IN NUMBER
546: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
547: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
548: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
549: ,p_resale_batch_id IN NUMBER
550: ,x_return_status OUT NOCOPY VARCHAR2
543: -----------------------------------------------------------------------
544: PROCEDURE Delete_Log(
545: p_api_version IN NUMBER
546: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
547: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
548: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
549: ,p_resale_batch_id IN NUMBER
550: ,x_return_status OUT NOCOPY VARCHAR2
551: ,x_msg_data OUT NOCOPY VARCHAR2
544: PROCEDURE Delete_Log(
545: p_api_version IN NUMBER
546: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
547: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
548: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
549: ,p_resale_batch_id IN NUMBER
550: ,x_return_status OUT NOCOPY VARCHAR2
551: ,x_msg_data OUT NOCOPY VARCHAR2
552: ,x_msg_count OUT NOCOPY NUMBER
567: --
568: ---------------------------------------------------------------------
569: PROCEDURE Create_Party
570: ( p_api_version IN NUMBER
571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
574: ,px_party_rec IN OUT NOCOPY party_rec_type
575: ,x_return_status OUT NOCOPY VARCHAR2
568: ---------------------------------------------------------------------
569: PROCEDURE Create_Party
570: ( p_api_version IN NUMBER
571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
574: ,px_party_rec IN OUT NOCOPY party_rec_type
575: ,x_return_status OUT NOCOPY VARCHAR2
576: ,x_msg_count OUT NOCOPY NUMBER
569: PROCEDURE Create_Party
570: ( p_api_version IN NUMBER
571: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
572: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
573: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
574: ,px_party_rec IN OUT NOCOPY party_rec_type
575: ,x_return_status OUT NOCOPY VARCHAR2
576: ,x_msg_count OUT NOCOPY NUMBER
577: ,x_msg_data OUT NOCOPY VARCHAR2