eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PUB dependencies on OZF_DISC_LINE_PVT

Line 44: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;

40: l_dummy NUMBER;
41: l_prod_index NUMBER := 0;
42: l_excl_index NUMBER := 0;
43:
44: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
45: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
46: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
47: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;

Line 45: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;

41: l_prod_index NUMBER := 0;
42: l_excl_index NUMBER := 0;
43:
44: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
45: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
46: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
47: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;

Line 46: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;

42: l_excl_index NUMBER := 0;
43:
44: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
45: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
46: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
47: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

Line 48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;

44: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
45: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
46: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
47: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
48: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
49: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
50: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
51: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
52: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

Line 459: OZF_Disc_Line_PVT.Create_discount_line(

455: ELSE
456: l_discount_line_rec.offer_id := p_discount_tbl(i).offer_id;
457: END IF;
458:
459: OZF_Disc_Line_PVT.Create_discount_line(
460: p_api_version_number => p_api_version,
461: p_init_msg_list => p_init_msg_list,
462: p_commit => p_commit,
463: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 480: OZF_Disc_Line_PVT.Update_discount_line(

476: l_discount_line_rec.offer_discount_line_id := p_discount_tbl(i).offer_discount_line_id;
477: l_discount_line_rec.offer_id := p_discount_tbl(i).offer_id;
478: l_discount_line_rec.object_version_number := p_discount_tbl(i).object_version_number;
479:
480: OZF_Disc_Line_PVT.Update_discount_line(
481: p_api_version_number => p_api_version,
482: p_init_msg_list => p_init_msg_list,
483: p_commit => p_commit,
484: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 496: OZF_Disc_Line_PVT.Delete_offer_line(

492: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
493: RAISE Fnd_Api.g_exc_unexpected_error;
494: END IF;
495: ELSIF p_discount_tbl(i).operation = 'DELETE' THEN
496: OZF_Disc_Line_PVT.Delete_offer_line(
497: p_api_version_number => p_api_version,
498: p_init_msg_list => p_init_msg_list,
499: p_commit => p_commit,
500: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 525: OZF_Disc_Line_PVT.Create_Product_Exclusion(

521: l_excl_rec.end_date_active := p_excl_tbl(i).end_date_active;
522: l_excl_rec.parent_off_disc_prod_id := p_excl_tbl(i).parent_off_disc_prod_id;
523:
524: IF p_excl_tbl(i).operation = 'CREATE' THEN
525: OZF_Disc_Line_PVT.Create_Product_Exclusion(
526: p_api_version_number => p_api_version,
527: p_init_msg_list => p_init_msg_list,
528: p_commit => p_commit,
529: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 545: OZF_Disc_Line_PVT.Update_Product_Exclusion(

541: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
542: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;
543: l_excl_rec.object_version_number := p_excl_tbl(i).object_version_number;
544:
545: OZF_Disc_Line_PVT.Update_Product_Exclusion(
546: p_api_version_number => p_api_version,
547: p_init_msg_list => p_init_msg_list,
548: p_commit => p_commit,
549: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 561: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

557: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
558: RAISE Fnd_Api.g_exc_unexpected_error;
559: END IF;
560: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
561: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
562: p_api_version_number => p_api_version,
563: p_init_msg_list => p_init_msg_list,
564: p_commit => p_commit,
565: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 597: OZF_Disc_Line_PVT.Create_Disc_Tiers(

593: l_offer_tier_rec.end_date_active := p_offer_tier_tbl(i).end_date_active;
594: l_offer_tier_rec.uom_code := p_offer_tier_tbl(i).uom_code;
595:
596: IF p_offer_tier_tbl(i).operation = 'CREATE' THEN
597: OZF_Disc_Line_PVT.Create_Disc_Tiers(
598: p_api_version_number => p_api_version,
599: p_init_msg_list => p_init_msg_list,
600: p_commit => p_commit,
601: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 617: OZF_Disc_Line_PVT.Update_Disc_Tiers(

613: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
614: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;
615: l_offer_tier_rec.object_version_number := p_offer_tier_tbl(i).object_version_number;
616:
617: OZF_Disc_Line_PVT.Update_Disc_Tiers(
618: p_api_version_number => p_api_version,
619: p_init_msg_list => p_init_msg_list,
620: p_commit => p_commit,
621: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 634: OZF_Disc_Line_PVT.Delete_Disc_tiers(

630: RAISE Fnd_Api.g_exc_unexpected_error;
631: END IF;
632: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
633: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN
634: OZF_Disc_Line_PVT.Delete_Disc_tiers(
635: p_api_version_number => p_api_version,
636: p_init_msg_list => p_init_msg_list,
637: p_commit => p_commit,
638: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 650: OZF_Disc_Line_PVT.Delete_Tier_line(

646: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
647: RAISE Fnd_Api.g_exc_unexpected_error;
648: END IF;
649: ELSE
650: OZF_Disc_Line_PVT.Delete_Tier_line(
651: p_api_version_number => p_api_version,
652: p_init_msg_list => p_init_msg_list,
653: p_commit => p_commit,
654: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 689: OZF_Disc_Line_PVT.Create_Ozf_Prod_Line(

685: ELSE
686: l_prod_rec.offer_id := p_prod_tbl(i).offer_id;
687: END IF;
688:
689: OZF_Disc_Line_PVT.Create_Ozf_Prod_Line(
690: p_api_version_number => p_api_version,
691: p_init_msg_list => p_init_msg_list,
692: p_commit => p_commit,
693: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 710: OZF_Disc_Line_PVT.Update_Ozf_Prod_Line(

706: l_prod_rec.off_discount_product_id := p_prod_tbl(i).off_discount_product_id;
707: l_prod_rec.offer_id := p_prod_tbl(i).offer_id;
708: l_prod_rec.object_version_number := p_prod_tbl(i).object_version_number;
709:
710: OZF_Disc_Line_PVT.Update_Ozf_Prod_Line(
711: p_api_version_number => p_api_version,
712: p_init_msg_list => p_init_msg_list,
713: p_commit => p_commit,
714: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 726: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

722: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
723: RAISE Fnd_Api.g_exc_unexpected_error;
724: END IF;
725: ELSIF p_prod_tbl(i).operation = 'DELETE' THEN
726: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
727: p_api_version_number => p_api_version,
728: p_init_msg_list => p_init_msg_list,
729: p_commit => p_commit,
730: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 756: OZF_Disc_Line_PVT.Create_Product_Exclusion(

752: l_excl_rec.end_date_active := p_excl_tbl(i).end_date_active;
753: l_excl_rec.parent_off_disc_prod_id := p_excl_tbl(i).parent_off_disc_prod_id;
754:
755: IF p_excl_tbl(i).operation = 'CREATE' THEN
756: OZF_Disc_Line_PVT.Create_Product_Exclusion(
757: p_api_version_number => p_api_version,
758: p_init_msg_list => p_init_msg_list,
759: p_commit => p_commit,
760: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 776: OZF_Disc_Line_PVT.Update_Product_Exclusion(

772: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
773: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;
774: l_excl_rec.object_version_number := p_excl_tbl(i).object_version_number;
775:
776: OZF_Disc_Line_PVT.Update_Product_Exclusion(
777: p_api_version_number => p_api_version,
778: p_init_msg_list => p_init_msg_list,
779: p_commit => p_commit,
780: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 792: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

788: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
789: RAISE Fnd_Api.g_exc_unexpected_error;
790: END IF;
791: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
792: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
793: p_api_version_number => p_api_version,
794: p_init_msg_list => p_init_msg_list,
795: p_commit => p_commit,
796: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 828: OZF_Disc_Line_PVT.Create_Disc_Tiers(

824: l_offer_tier_rec.end_date_active := p_offer_tier_tbl(i).end_date_active;
825: l_offer_tier_rec.uom_code := p_offer_tier_tbl(i).uom_code;
826:
827: IF p_offer_tier_tbl(i).operation = 'CREATE' THEN
828: OZF_Disc_Line_PVT.Create_Disc_Tiers(
829: p_api_version_number => p_api_version,
830: p_init_msg_list => p_init_msg_list,
831: p_commit => p_commit,
832: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 848: OZF_Disc_Line_PVT.Update_Disc_Tiers(

844: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
845: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;
846: l_offer_tier_rec.object_version_number := p_offer_tier_tbl(i).object_version_number;
847:
848: OZF_Disc_Line_PVT.Update_Disc_Tiers(
849: p_api_version_number => p_api_version,
850: p_init_msg_list => p_init_msg_list,
851: p_commit => p_commit,
852: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 865: OZF_Disc_Line_PVT.Delete_Disc_tiers(

861: RAISE Fnd_Api.g_exc_unexpected_error;
862: END IF;
863: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
864: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN
865: OZF_Disc_Line_PVT.Delete_Disc_tiers(
866: p_api_version_number => p_api_version,
867: p_init_msg_list => p_init_msg_list,
868: p_commit => p_commit,
869: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 881: OZF_Disc_Line_PVT.Delete_Tier_line(

877: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
878: RAISE Fnd_Api.g_exc_unexpected_error;
879: END IF;
880: ELSE
881: OZF_Disc_Line_PVT.Delete_Tier_line(
882: p_api_version_number => p_api_version,
883: p_init_msg_list => p_init_msg_list,
884: p_commit => p_commit,
885: p_validation_level => FND_API.G_VALID_LEVEL_FULL,