361: -- Parameters
362: --
363: -- IN
364: -- p_api_version_number IN NUMBER Required
365: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
366: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
367: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_offer_discount_line_id IN NUMBER Required All the products attached to this discount line will be deleted
369: --
362: --
363: -- IN
364: -- p_api_version_number IN NUMBER Required
365: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
366: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
367: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_offer_discount_line_id IN NUMBER Required All the products attached to this discount line will be deleted
369: --
370: -- OUT
363: -- IN
364: -- p_api_version_number IN NUMBER Required
365: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
366: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
367: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
368: -- p_offer_discount_line_id IN NUMBER Required All the products attached to this discount line will be deleted
369: --
370: -- OUT
371: -- x_return_status OUT VARCHAR2
382: -- ==============================================================================
383:
384: PROCEDURE Delete_Product(
385: p_api_version_number IN NUMBER,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
383:
384: PROCEDURE Delete_Product(
385: p_api_version_number IN NUMBER,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
391: x_msg_data OUT NOCOPY VARCHAR2,
384: PROCEDURE Delete_Product(
385: p_api_version_number IN NUMBER,
386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
391: x_msg_data OUT NOCOPY VARCHAR2,
392: p_offer_discount_line_id IN NUMBER
404: -- Parameters
405: --
406: -- IN
407: -- p_api_version_number IN NUMBER Required
408: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
409: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
410: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
411: -- p_offer_discount_line_id IN NUMBER Required Discount Line id to be deleted
412: -- p_object_version_number IN NUMBER Required Object Version No. Of Discount Line to be deleted
405: --
406: -- IN
407: -- p_api_version_number IN NUMBER Required
408: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
409: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
410: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
411: -- p_offer_discount_line_id IN NUMBER Required Discount Line id to be deleted
412: -- p_object_version_number IN NUMBER Required Object Version No. Of Discount Line to be deleted
413: --
406: -- IN
407: -- p_api_version_number IN NUMBER Required
408: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
409: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
410: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
411: -- p_offer_discount_line_id IN NUMBER Required Discount Line id to be deleted
412: -- p_object_version_number IN NUMBER Required Object Version No. Of Discount Line to be deleted
413: --
414: -- OUT
427: -- ==============================================================================
428:
429: PROCEDURE Delete_offer_line(
430: p_api_version_number IN NUMBER,
431: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432: p_commit IN VARCHAR2 := FND_API.G_FALSE,
433: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
434:
435: x_return_status OUT NOCOPY VARCHAR2,
428:
429: PROCEDURE Delete_offer_line(
430: p_api_version_number IN NUMBER,
431: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432: p_commit IN VARCHAR2 := FND_API.G_FALSE,
433: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
434:
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_msg_count OUT NOCOPY NUMBER,
429: PROCEDURE Delete_offer_line(
430: p_api_version_number IN NUMBER,
431: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432: p_commit IN VARCHAR2 := FND_API.G_FALSE,
433: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
434:
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_msg_count OUT NOCOPY NUMBER,
437: x_msg_data OUT NOCOPY VARCHAR2,
453: -- Parameters
454: --
455: -- IN
456: -- p_api_version_number IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460: -- p_ozf_offer_line_rec IN ozf_offer_line_rec_type Required Record containing Discount Line Data
461: -- p_ozf_prod_rec IN ozf_prod_rec_type Required Record containing Product Data
454: --
455: -- IN
456: -- p_api_version_number IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460: -- p_ozf_offer_line_rec IN ozf_offer_line_rec_type Required Record containing Discount Line Data
461: -- p_ozf_prod_rec IN ozf_prod_rec_type Required Record containing Product Data
462: -- OUT
455: -- IN
456: -- p_api_version_number IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
458: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
460: -- p_ozf_offer_line_rec IN ozf_offer_line_rec_type Required Record containing Discount Line Data
461: -- p_ozf_prod_rec IN ozf_prod_rec_type Required Record containing Product Data
462: -- OUT
463: -- x_return_status OUT VARCHAR2
475: -- ==============================================================================
476:
477: PROCEDURE Create_discount_line(
478: p_api_version_number IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482:
483: x_return_status OUT NOCOPY VARCHAR2,
476:
477: PROCEDURE Create_discount_line(
478: p_api_version_number IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482:
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
477: PROCEDURE Create_discount_line(
478: p_api_version_number IN NUMBER,
479: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
480: p_commit IN VARCHAR2 := FND_API.G_FALSE,
481: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
482:
483: x_return_status OUT NOCOPY VARCHAR2,
484: x_msg_count OUT NOCOPY NUMBER,
485: x_msg_data OUT NOCOPY VARCHAR2,
501: -- Parameters
502: --
503: -- IN
504: -- p_api_version_number IN NUMBER Required
505: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508: -- p_ozf_discount_line_rec IN ozf_discount_line_rec_type Required Record Containing Discount Line Data
509: -- x_return_status OUT VARCHAR2
502: --
503: -- IN
504: -- p_api_version_number IN NUMBER Required
505: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508: -- p_ozf_discount_line_rec IN ozf_discount_line_rec_type Required Record Containing Discount Line Data
509: -- x_return_status OUT VARCHAR2
510: -- x_msg_count OUT NUMBER
503: -- IN
504: -- p_api_version_number IN NUMBER Required
505: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
506: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
507: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
508: -- p_ozf_discount_line_rec IN ozf_discount_line_rec_type Required Record Containing Discount Line Data
509: -- x_return_status OUT VARCHAR2
510: -- x_msg_count OUT NUMBER
511: -- x_msg_data OUT VARCHAR2
519: -- End of Comments
520: -- ==============================================================================
521: PROCEDURE Update_discount_line(
522: p_api_version_number IN NUMBER,
523: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524: p_commit IN VARCHAR2 := FND_API.G_FALSE,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526:
527: x_return_status OUT NOCOPY VARCHAR2,
520: -- ==============================================================================
521: PROCEDURE Update_discount_line(
522: p_api_version_number IN NUMBER,
523: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524: p_commit IN VARCHAR2 := FND_API.G_FALSE,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526:
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
521: PROCEDURE Update_discount_line(
522: p_api_version_number IN NUMBER,
523: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
524: p_commit IN VARCHAR2 := FND_API.G_FALSE,
525: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
526:
527: x_return_status OUT NOCOPY VARCHAR2,
528: x_msg_count OUT NOCOPY NUMBER,
529: x_msg_data OUT NOCOPY VARCHAR2,
545: -- Parameters
546: --
547: -- IN
548: -- p_api_version_number IN NUMBER Required
549: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
550: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
551: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
552: -- p_ozf_prod_rec IN ozf_prod_rec_type Required
553: --
546: --
547: -- IN
548: -- p_api_version_number IN NUMBER Required
549: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
550: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
551: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
552: -- p_ozf_prod_rec IN ozf_prod_rec_type Required
553: --
554: -- OUT
547: -- IN
548: -- p_api_version_number IN NUMBER Required
549: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
550: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
551: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
552: -- p_ozf_prod_rec IN ozf_prod_rec_type Required
553: --
554: -- OUT
555: -- x_return_status OUT VARCHAR2
572:
573: PROCEDURE Create_Product_Exclusion
574: (
575: p_api_version_number IN NUMBER,
576: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
577: p_commit IN VARCHAR2 := FND_API.G_FALSE,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579:
580: x_return_status OUT NOCOPY VARCHAR2,
573: PROCEDURE Create_Product_Exclusion
574: (
575: p_api_version_number IN NUMBER,
576: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
577: p_commit IN VARCHAR2 := FND_API.G_FALSE,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579:
580: x_return_status OUT NOCOPY VARCHAR2,
581: x_msg_count OUT NOCOPY NUMBER,
574: (
575: p_api_version_number IN NUMBER,
576: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
577: p_commit IN VARCHAR2 := FND_API.G_FALSE,
578: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
579:
580: x_return_status OUT NOCOPY VARCHAR2,
581: x_msg_count OUT NOCOPY NUMBER,
582: x_msg_data OUT NOCOPY VARCHAR2,
597: -- Parameters
598: --
599: -- IN
600: -- p_api_version_number IN NUMBER Required
601: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
602: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
603: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
604: -- p_ozf_prod_rec IN ozf_prod_rec_type Required
605: --
598: --
599: -- IN
600: -- p_api_version_number IN NUMBER Required
601: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
602: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
603: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
604: -- p_ozf_prod_rec IN ozf_prod_rec_type Required
605: --
606: -- OUT
599: -- IN
600: -- p_api_version_number IN NUMBER Required
601: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
602: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
603: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
604: -- p_ozf_prod_rec IN ozf_prod_rec_type Required
605: --
606: -- OUT
607: -- x_return_status OUT VARCHAR2
621: -- ==============================================================================
622:
623: PROCEDURE Update_Product_Exclusion(
624: p_api_version_number IN NUMBER,
625: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
626: p_commit IN VARCHAR2 := FND_API.G_FALSE,
627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
628:
629: x_return_status OUT NOCOPY VARCHAR2,
622:
623: PROCEDURE Update_Product_Exclusion(
624: p_api_version_number IN NUMBER,
625: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
626: p_commit IN VARCHAR2 := FND_API.G_FALSE,
627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
628:
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
623: PROCEDURE Update_Product_Exclusion(
624: p_api_version_number IN NUMBER,
625: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
626: p_commit IN VARCHAR2 := FND_API.G_FALSE,
627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
628:
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2,
635:
636:
637: PROCEDURE Create_Disc_Tiers(
638: p_api_version_number IN NUMBER,
639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
640: p_commit IN VARCHAR2 := FND_API.G_FALSE,
641: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
642:
643: x_return_status OUT NOCOPY VARCHAR2,
636:
637: PROCEDURE Create_Disc_Tiers(
638: p_api_version_number IN NUMBER,
639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
640: p_commit IN VARCHAR2 := FND_API.G_FALSE,
641: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
642:
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,
637: PROCEDURE Create_Disc_Tiers(
638: p_api_version_number IN NUMBER,
639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
640: p_commit IN VARCHAR2 := FND_API.G_FALSE,
641: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
642:
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,
649: );
650:
651: PROCEDURE Update_Disc_Tiers(
652: p_api_version_number IN NUMBER,
653: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
654: p_commit IN VARCHAR2 := FND_API.G_FALSE,
655: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
656:
657: x_return_status OUT NOCOPY VARCHAR2,
650:
651: PROCEDURE Update_Disc_Tiers(
652: p_api_version_number IN NUMBER,
653: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
654: p_commit IN VARCHAR2 := FND_API.G_FALSE,
655: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
656:
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,
651: PROCEDURE Update_Disc_Tiers(
652: p_api_version_number IN NUMBER,
653: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
654: p_commit IN VARCHAR2 := FND_API.G_FALSE,
655: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
656:
657: x_return_status OUT NOCOPY VARCHAR2,
658: x_msg_count OUT NOCOPY NUMBER,
659: x_msg_data OUT NOCOPY VARCHAR2,
662: );
663:
664: PROCEDURE Delete_Disc_tiers(
665: p_api_version_number IN NUMBER,
666: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
667: p_commit IN VARCHAR2 := FND_API.G_FALSE,
668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669:
670: x_return_status OUT NOCOPY VARCHAR2,
663:
664: PROCEDURE Delete_Disc_tiers(
665: p_api_version_number IN NUMBER,
666: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
667: p_commit IN VARCHAR2 := FND_API.G_FALSE,
668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669:
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,
664: PROCEDURE Delete_Disc_tiers(
665: p_api_version_number IN NUMBER,
666: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
667: p_commit IN VARCHAR2 := FND_API.G_FALSE,
668: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669:
670: x_return_status OUT NOCOPY VARCHAR2,
671: x_msg_count OUT NOCOPY NUMBER,
672: x_msg_data OUT NOCOPY VARCHAR2,
674: p_parent_discount_line_id IN NUMBER
675: );
676: PROCEDURE Delete_Tier_line(
677: p_api_version_number IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
681:
682: x_return_status OUT NOCOPY VARCHAR2,
675: );
676: PROCEDURE Delete_Tier_line(
677: p_api_version_number IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
681:
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_msg_count OUT NOCOPY NUMBER,
676: PROCEDURE Delete_Tier_line(
677: p_api_version_number IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
679: p_commit IN VARCHAR2 := FND_API.G_FALSE,
680: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
681:
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_msg_count OUT NOCOPY NUMBER,
684: x_msg_data OUT NOCOPY VARCHAR2,
689:
690:
691: PROCEDURE Create_Ozf_Prod_Line(
692: p_api_version_number IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
694: p_commit IN VARCHAR2 := FND_API.G_FALSE,
695: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
696:
697: x_return_status OUT NOCOPY VARCHAR2,
690:
691: PROCEDURE Create_Ozf_Prod_Line(
692: p_api_version_number IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
694: p_commit IN VARCHAR2 := FND_API.G_FALSE,
695: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
696:
697: x_return_status OUT NOCOPY VARCHAR2,
698: x_msg_count OUT NOCOPY NUMBER,
691: PROCEDURE Create_Ozf_Prod_Line(
692: p_api_version_number IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
694: p_commit IN VARCHAR2 := FND_API.G_FALSE,
695: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
696:
697: x_return_status OUT NOCOPY VARCHAR2,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY VARCHAR2,
703: );
704:
705: PROCEDURE Update_Ozf_Prod_Line(
706: p_api_version_number IN NUMBER,
707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708: p_commit IN VARCHAR2 := FND_API.G_FALSE,
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710:
711: x_return_status OUT NOCOPY VARCHAR2,
704:
705: PROCEDURE Update_Ozf_Prod_Line(
706: p_api_version_number IN NUMBER,
707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708: p_commit IN VARCHAR2 := FND_API.G_FALSE,
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710:
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
705: PROCEDURE Update_Ozf_Prod_Line(
706: p_api_version_number IN NUMBER,
707: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
708: p_commit IN VARCHAR2 := FND_API.G_FALSE,
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710:
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,
716: );
717:
718: PROCEDURE Delete_Ozf_Prod_Line(
719: p_api_version_number IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721: p_commit IN VARCHAR2 := FND_API.G_FALSE,
722: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
723: x_return_status OUT NOCOPY VARCHAR2,
724: x_msg_count OUT NOCOPY NUMBER,
717:
718: PROCEDURE Delete_Ozf_Prod_Line(
719: p_api_version_number IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721: p_commit IN VARCHAR2 := FND_API.G_FALSE,
722: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
723: x_return_status OUT NOCOPY VARCHAR2,
724: x_msg_count OUT NOCOPY NUMBER,
725: x_msg_data OUT NOCOPY VARCHAR2,
718: PROCEDURE Delete_Ozf_Prod_Line(
719: p_api_version_number IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721: p_commit IN VARCHAR2 := FND_API.G_FALSE,
722: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
723: x_return_status OUT NOCOPY VARCHAR2,
724: x_msg_count OUT NOCOPY NUMBER,
725: x_msg_data OUT NOCOPY VARCHAR2,
726: p_off_discount_product_id IN NUMBER,