270: -- NOTES
271: ---------------------------------------------------------------------
272: PROCEDURE Update_Batch_Calculations (
273: p_api_version IN NUMBER
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_resale_batch_id IN NUMBER
278: ,x_return_status OUT NOCOPY VARCHAR2
271: ---------------------------------------------------------------------
272: PROCEDURE Update_Batch_Calculations (
273: p_api_version IN NUMBER
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_resale_batch_id IN NUMBER
278: ,x_return_status OUT NOCOPY VARCHAR2
279: ,x_msg_data OUT NOCOPY VARCHAR2
272: PROCEDURE Update_Batch_Calculations (
273: p_api_version IN NUMBER
274: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
275: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
276: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277: ,p_resale_batch_id IN NUMBER
278: ,x_return_status OUT NOCOPY VARCHAR2
279: ,x_msg_data OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
314: -- NOTES
315: ---------------------------------------------------------------------
316: PROCEDURE Validate_Batch(
317: p_api_version IN NUMBER
318: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
320: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321: ,p_resale_batch_id IN NUMBER
322: ,x_batch_status OUT NOCOPY VARCHAR2
315: ---------------------------------------------------------------------
316: PROCEDURE Validate_Batch(
317: p_api_version IN NUMBER
318: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
320: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321: ,p_resale_batch_id IN NUMBER
322: ,x_batch_status OUT NOCOPY VARCHAR2
323: ,x_return_status OUT NOCOPY VARCHAR2
316: PROCEDURE Validate_Batch(
317: p_api_version IN NUMBER
318: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
319: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
320: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
321: ,p_resale_batch_id IN NUMBER
322: ,x_batch_status OUT NOCOPY VARCHAR2
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_data OUT NOCOPY VARCHAR2
339: -- NOTES
340: ---------------------------------------------------------------------
341: PROCEDURE Validate_Order_Record(
342: p_api_version IN NUMBER
343: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
344: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
345: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
346: ,p_resale_batch_id IN NUMBER
347: ,x_return_status OUT NOCOPY VARCHAR2
340: ---------------------------------------------------------------------
341: PROCEDURE Validate_Order_Record(
342: p_api_version IN NUMBER
343: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
344: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
345: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
346: ,p_resale_batch_id IN NUMBER
347: ,x_return_status OUT NOCOPY VARCHAR2
348: ,x_msg_data OUT NOCOPY VARCHAR2
341: PROCEDURE Validate_Order_Record(
342: p_api_version IN NUMBER
343: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
344: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
345: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
346: ,p_resale_batch_id IN NUMBER
347: ,x_return_status OUT NOCOPY VARCHAR2
348: ,x_msg_data OUT NOCOPY VARCHAR2
349: ,x_msg_count OUT NOCOPY NUMBER
362: -- NOTES
363: ---------------------------------------------------------------------
364: PROCEDURE Update_Duplicates (
365: p_api_version IN NUMBER
366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
369: ,p_resale_batch_id IN NUMBER
370: ,p_resale_batch_type IN VARCHAR2
363: ---------------------------------------------------------------------
364: PROCEDURE Update_Duplicates (
365: p_api_version IN NUMBER
366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
369: ,p_resale_batch_id IN NUMBER
370: ,p_resale_batch_type IN VARCHAR2
371: ,p_batch_status IN VARCHAR2
364: PROCEDURE Update_Duplicates (
365: p_api_version IN NUMBER
366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
369: ,p_resale_batch_id IN NUMBER
370: ,p_resale_batch_type IN VARCHAR2
371: ,p_batch_status IN VARCHAR2
372: ,x_batch_status OUT NOCOPY VARCHAR2
388: -- NOTES
389: ---------------------------------------------------------------------
390: PROCEDURE Check_Duplicate_Line(
391: p_api_version_number IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
393: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
394: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
395: ,p_resale_line_int_id IN NUMBER
396: ,p_direct_customer_flag IN VARCHAR2
389: ---------------------------------------------------------------------
390: PROCEDURE Check_Duplicate_Line(
391: p_api_version_number IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
393: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
394: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
395: ,p_resale_line_int_id IN NUMBER
396: ,p_direct_customer_flag IN VARCHAR2
397: ,p_claimed_amount IN NUMBER
390: PROCEDURE Check_Duplicate_Line(
391: p_api_version_number IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
393: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
394: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
395: ,p_resale_line_int_id IN NUMBER
396: ,p_direct_customer_flag IN VARCHAR2
397: ,p_claimed_amount IN NUMBER
398: ,p_batch_type IN VARCHAR2
419: --
420: ---------------------------------------------------------------------
421: PROCEDURE Create_Utilization(
422: p_api_version IN NUMBER
423: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
424: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
425: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
426: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
427: ,p_fund_id IN NUMBER
420: ---------------------------------------------------------------------
421: PROCEDURE Create_Utilization(
422: p_api_version IN NUMBER
423: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
424: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
425: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
426: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
427: ,p_fund_id IN NUMBER
428: ,p_line_id IN NUMBER
421: PROCEDURE Create_Utilization(
422: p_api_version IN NUMBER
423: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
424: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
425: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
426: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
427: ,p_fund_id IN NUMBER
428: ,p_line_id IN NUMBER
429: ,p_cust_account_id IN NUMBER
454: -- for bug#8867381.
455: ---------------------------------------------------------------------
456: PROCEDURE Create_Utilization(
457: p_api_version IN NUMBER
458: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
459: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
460: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
461: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
462: ,p_fund_id IN NUMBER
455: ---------------------------------------------------------------------
456: PROCEDURE Create_Utilization(
457: p_api_version IN NUMBER
458: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
459: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
460: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
461: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
462: ,p_fund_id IN NUMBER
463: ,p_fund_int_rec IN ozf_funds_pvt.fund_rec_int_type DEFAULT NULL
456: PROCEDURE Create_Utilization(
457: p_api_version IN NUMBER
458: ,p_init_msg_LIST IN VARCHAR2 := FND_API.G_FALSE
459: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
460: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
461: ,p_line_int_rec IN g_interface_rec_csr%ROWTYPE
462: ,p_fund_id IN NUMBER
463: ,p_fund_int_rec IN ozf_funds_pvt.fund_rec_int_type DEFAULT NULL
464: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'
489: --06/11/2011 BKUNJAN Added OUT parameter x_utilization_id for ER 13333298
490: ---------------------------------------------------------------------
491: PROCEDURE Create_Adj_And_Utilization(
492: p_api_version IN NUMBER
493: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
494: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
495: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
496: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
497: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
490: ---------------------------------------------------------------------
491: PROCEDURE Create_Adj_And_Utilization(
492: p_api_version IN NUMBER
493: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
494: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
495: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
496: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
497: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
498: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
491: PROCEDURE Create_Adj_And_Utilization(
492: p_api_version IN NUMBER
493: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
494: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
495: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
496: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
497: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
498: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
499: ,p_to_create_utilization IN BOOLEAN
526: --06/11/2011 BKUNJAN Added OUT parameter x_utilization_id for ER 13333298
527: ---------------------------------------------------------------------
528: PROCEDURE Create_Adj_And_Utilization(
529: p_api_version IN NUMBER
530: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
531: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
532: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
533: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
534: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
527: ---------------------------------------------------------------------
528: PROCEDURE Create_Adj_And_Utilization(
529: p_api_version IN NUMBER
530: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
531: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
532: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
533: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
534: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
535: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
528: PROCEDURE Create_Adj_And_Utilization(
529: p_api_version IN NUMBER
530: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
531: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
532: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
533: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
534: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
535: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
536: ,p_to_create_utilization IN BOOLEAN
561: --
562: ---------------------------------------------------------------------
563: PROCEDURE Create_Sales_Transaction(
564: p_api_version IN NUMBER
565: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
566: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
567: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
568: ,p_line_int_rec IN g_interface_rec_csr%rowtype
569: ,p_header_id IN NUMBER
562: ---------------------------------------------------------------------
563: PROCEDURE Create_Sales_Transaction(
564: p_api_version IN NUMBER
565: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
566: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
567: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
568: ,p_line_int_rec IN g_interface_rec_csr%rowtype
569: ,p_header_id IN NUMBER
570: ,p_line_id IN NUMBER
563: PROCEDURE Create_Sales_Transaction(
564: p_api_version IN NUMBER
565: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
566: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
567: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
568: ,p_line_int_rec IN g_interface_rec_csr%rowtype
569: ,p_header_id IN NUMBER
570: ,p_line_id IN NUMBER
571: ,x_sales_transaction_id OUT NOCOPY NUMBER
590: --
591: ---------------------------------------------------------------------
592: PROCEDURE Insert_Resale_Header(
593: p_api_version IN NUMBER
594: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
595: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
596: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
597: ,p_line_int_rec IN g_interface_rec_csr%rowtype
598: ,x_header_id OUT NOCOPY NUMBER
591: ---------------------------------------------------------------------
592: PROCEDURE Insert_Resale_Header(
593: p_api_version IN NUMBER
594: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
595: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
596: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
597: ,p_line_int_rec IN g_interface_rec_csr%rowtype
598: ,x_header_id OUT NOCOPY NUMBER
599: ,x_return_status OUT NOCOPY VARCHAR2
592: PROCEDURE Insert_Resale_Header(
593: p_api_version IN NUMBER
594: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
595: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
596: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
597: ,p_line_int_rec IN g_interface_rec_csr%rowtype
598: ,x_header_id OUT NOCOPY NUMBER
599: ,x_return_status OUT NOCOPY VARCHAR2
600: ,x_msg_data OUT NOCOPY VARCHAR2
616: --
617: ---------------------------------------------------------------------
618: PROCEDURE Insert_Resale_Line(
619: p_api_version IN NUMBER
620: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
621: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
622: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
623: ,p_line_int_rec IN g_interface_rec_csr%rowtype
624: ,p_header_id IN NUMBER
617: ---------------------------------------------------------------------
618: PROCEDURE Insert_Resale_Line(
619: p_api_version IN NUMBER
620: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
621: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
622: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
623: ,p_line_int_rec IN g_interface_rec_csr%rowtype
624: ,p_header_id IN NUMBER
625: ,x_line_id OUT NOCOPY NUMBER
618: PROCEDURE Insert_Resale_Line(
619: p_api_version IN NUMBER
620: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
621: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
622: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
623: ,p_line_int_rec IN g_interface_rec_csr%rowtype
624: ,p_header_id IN NUMBER
625: ,x_line_id OUT NOCOPY NUMBER
626: ,x_return_status OUT NOCOPY VARCHAR2
643: --
644: ---------------------------------------------------------------------
645: PROCEDURE Insert_Resale_Line_Mapping(
646: p_api_version IN NUMBER
647: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
648: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
649: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
650: ,p_resale_batch_id IN NUMBER
651: ,p_line_id IN NUMBER
644: ---------------------------------------------------------------------
645: PROCEDURE Insert_Resale_Line_Mapping(
646: p_api_version IN NUMBER
647: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
648: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
649: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
650: ,p_resale_batch_id IN NUMBER
651: ,p_line_id IN NUMBER
652: ,x_return_status OUT NOCOPY VARCHAR2
645: PROCEDURE Insert_Resale_Line_Mapping(
646: p_api_version IN NUMBER
647: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
648: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
649: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
650: ,p_resale_batch_id IN NUMBER
651: ,p_line_id IN NUMBER
652: ,x_return_status OUT NOCOPY VARCHAR2
653: ,x_msg_data OUT NOCOPY VARCHAR2
667: -- NOTES
668: -----------------------------------------------------------------------
669: PROCEDURE Delete_Log(
670: p_api_version IN NUMBER
671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
673: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
674: ,p_resale_batch_id IN NUMBER
675: ,x_return_status OUT NOCOPY VARCHAR2
668: -----------------------------------------------------------------------
669: PROCEDURE Delete_Log(
670: p_api_version IN NUMBER
671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
673: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
674: ,p_resale_batch_id IN NUMBER
675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,x_msg_data OUT NOCOPY VARCHAR2
669: PROCEDURE Delete_Log(
670: p_api_version IN NUMBER
671: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
672: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
673: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
674: ,p_resale_batch_id IN NUMBER
675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,x_msg_data OUT NOCOPY VARCHAR2
677: ,x_msg_count OUT NOCOPY NUMBER
692: --
693: ---------------------------------------------------------------------
694: PROCEDURE Create_Party
695: ( p_api_version IN NUMBER
696: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
697: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
698: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
699: ,px_party_rec IN OUT NOCOPY party_rec_type
700: ,x_return_status OUT NOCOPY VARCHAR2
693: ---------------------------------------------------------------------
694: PROCEDURE Create_Party
695: ( p_api_version IN NUMBER
696: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
697: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
698: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
699: ,px_party_rec IN OUT NOCOPY party_rec_type
700: ,x_return_status OUT NOCOPY VARCHAR2
701: ,x_msg_count OUT NOCOPY NUMBER
694: PROCEDURE Create_Party
695: ( p_api_version IN NUMBER
696: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
697: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
698: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
699: ,px_party_rec IN OUT NOCOPY party_rec_type
700: ,x_return_status OUT NOCOPY VARCHAR2
701: ,x_msg_count OUT NOCOPY NUMBER
702: ,x_msg_data OUT NOCOPY VARCHAR2
752: -- Bug# 8489216 fixed.
753: -------------------------------------------------------------------------------
754: PROCEDURE Derive_Orig_Parties (
755: p_api_version IN NUMBER
756: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
757: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
758: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
759: ,p_resale_batch_id IN NUMBER
760: ,p_partner_party_id IN NUMBER
753: -------------------------------------------------------------------------------
754: PROCEDURE Derive_Orig_Parties (
755: p_api_version IN NUMBER
756: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
757: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
758: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
759: ,p_resale_batch_id IN NUMBER
760: ,p_partner_party_id IN NUMBER
761: ,x_return_status OUT NOCOPY VARCHAR2
754: PROCEDURE Derive_Orig_Parties (
755: p_api_version IN NUMBER
756: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
757: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
758: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
759: ,p_resale_batch_id IN NUMBER
760: ,p_partner_party_id IN NUMBER
761: ,x_return_status OUT NOCOPY VARCHAR2
762: ,x_msg_data OUT NOCOPY VARCHAR2
784: -- Bug# 8489216 fixed.
785: -------------------------------------------------------------------------------
786: PROCEDURE Derive_Bill_To_Party (
787: p_api_version IN NUMBER
788: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
791: ,p_resale_batch_id IN NUMBER
792: ,p_partner_party_id IN NUMBER
785: -------------------------------------------------------------------------------
786: PROCEDURE Derive_Bill_To_Party (
787: p_api_version IN NUMBER
788: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
791: ,p_resale_batch_id IN NUMBER
792: ,p_partner_party_id IN NUMBER
793: ,x_return_status OUT NOCOPY VARCHAR2
786: PROCEDURE Derive_Bill_To_Party (
787: p_api_version IN NUMBER
788: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
791: ,p_resale_batch_id IN NUMBER
792: ,p_partner_party_id IN NUMBER
793: ,x_return_status OUT NOCOPY VARCHAR2
794: ,x_msg_data OUT NOCOPY VARCHAR2
816: -- Bug# 8489216 fixed.
817: -------------------------------------------------------------------------------
818: PROCEDURE Derive_Ship_To_Party (
819: p_api_version IN NUMBER
820: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
822: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
823: ,p_resale_batch_id IN NUMBER
824: ,p_partner_party_id IN NUMBER
817: -------------------------------------------------------------------------------
818: PROCEDURE Derive_Ship_To_Party (
819: p_api_version IN NUMBER
820: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
822: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
823: ,p_resale_batch_id IN NUMBER
824: ,p_partner_party_id IN NUMBER
825: ,x_return_status OUT NOCOPY VARCHAR2
818: PROCEDURE Derive_Ship_To_Party (
819: p_api_version IN NUMBER
820: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
821: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
822: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
823: ,p_resale_batch_id IN NUMBER
824: ,p_partner_party_id IN NUMBER
825: ,x_return_status OUT NOCOPY VARCHAR2
826: ,x_msg_data OUT NOCOPY VARCHAR2
848: -- Bug# 8489216 fixed.
849: -------------------------------------------------------------------------------
850: PROCEDURE Derive_End_Cust_Party (
851: p_api_version IN NUMBER
852: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
853: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
854: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
855: ,p_resale_batch_id IN NUMBER
856: ,p_partner_party_id IN NUMBER
849: -------------------------------------------------------------------------------
850: PROCEDURE Derive_End_Cust_Party (
851: p_api_version IN NUMBER
852: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
853: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
854: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
855: ,p_resale_batch_id IN NUMBER
856: ,p_partner_party_id IN NUMBER
857: ,x_return_status OUT NOCOPY VARCHAR2
850: PROCEDURE Derive_End_Cust_Party (
851: p_api_version IN NUMBER
852: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
853: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
854: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
855: ,p_resale_batch_id IN NUMBER
856: ,p_partner_party_id IN NUMBER
857: ,x_return_status OUT NOCOPY VARCHAR2
858: ,x_msg_data OUT NOCOPY VARCHAR2
890: -- 7/31/2012 nepanda Created For Bug 14194884 - TPA In Draft Mode ER
891: --======================================================================
892: PROCEDURE Create_Draft_Utilization(
893: p_api_version IN NUMBER
894: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
895: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
896: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
897: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
898: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
891: --======================================================================
892: PROCEDURE Create_Draft_Utilization(
893: p_api_version IN NUMBER
894: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
895: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
896: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
897: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
898: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
899: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
892: PROCEDURE Create_Draft_Utilization(
893: p_api_version IN NUMBER
894: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
895: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
896: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
897: ,p_price_adj_rec IN ozf_resale_adjustments_all%rowtype
898: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
899: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
900: ,p_resale_line_int_rec IN OUT NOCOPY g_interface_rec_csr%rowtype