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 40: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;

36: l_dummy NUMBER;
37: l_prod_index NUMBER := 0;
38: l_excl_index NUMBER := 0;
39:
40: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
41: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
42: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
43: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;

Line 41: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;

37: l_prod_index NUMBER := 0;
38: l_excl_index NUMBER := 0;
39:
40: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
41: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
42: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
43: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;

Line 42: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;

38: l_excl_index NUMBER := 0;
39:
40: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
41: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
42: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
43: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

Line 44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;

40: l_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
41: l_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
42: l_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
43: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
44: l_offer_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
45: l_na_qualifier_rec ozf_offr_qual_pvt.ozf_offr_qual_rec_type;
46: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
47: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
48: l_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

Line 453: OZF_Disc_Line_PVT.Create_discount_line(

449: ELSE
450: l_discount_line_rec.offer_id := p_discount_tbl(i).offer_id;
451: END IF;
452:
453: OZF_Disc_Line_PVT.Create_discount_line(
454: p_api_version_number => p_api_version,
455: p_init_msg_list => p_init_msg_list,
456: p_commit => p_commit,
457: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 474: OZF_Disc_Line_PVT.Update_discount_line(

470: l_discount_line_rec.offer_discount_line_id := p_discount_tbl(i).offer_discount_line_id;
471: l_discount_line_rec.offer_id := p_discount_tbl(i).offer_id;
472: l_discount_line_rec.object_version_number := p_discount_tbl(i).object_version_number;
473:
474: OZF_Disc_Line_PVT.Update_discount_line(
475: p_api_version_number => p_api_version,
476: p_init_msg_list => p_init_msg_list,
477: p_commit => p_commit,
478: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 490: OZF_Disc_Line_PVT.Delete_offer_line(

486: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
487: RAISE Fnd_Api.g_exc_unexpected_error;
488: END IF;
489: ELSIF p_discount_tbl(i).operation = 'DELETE' THEN
490: OZF_Disc_Line_PVT.Delete_offer_line(
491: p_api_version_number => p_api_version,
492: p_init_msg_list => p_init_msg_list,
493: p_commit => p_commit,
494: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 519: OZF_Disc_Line_PVT.Create_Product_Exclusion(

515: l_excl_rec.end_date_active := p_excl_tbl(i).end_date_active;
516: l_excl_rec.parent_off_disc_prod_id := p_excl_tbl(i).parent_off_disc_prod_id;
517:
518: IF p_excl_tbl(i).operation = 'CREATE' THEN
519: OZF_Disc_Line_PVT.Create_Product_Exclusion(
520: p_api_version_number => p_api_version,
521: p_init_msg_list => p_init_msg_list,
522: p_commit => p_commit,
523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 539: OZF_Disc_Line_PVT.Update_Product_Exclusion(

535: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
536: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;
537: l_excl_rec.object_version_number := p_excl_tbl(i).object_version_number;
538:
539: OZF_Disc_Line_PVT.Update_Product_Exclusion(
540: p_api_version_number => p_api_version,
541: p_init_msg_list => p_init_msg_list,
542: p_commit => p_commit,
543: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 555: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

551: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
552: RAISE Fnd_Api.g_exc_unexpected_error;
553: END IF;
554: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
555: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
556: p_api_version_number => p_api_version,
557: p_init_msg_list => p_init_msg_list,
558: p_commit => p_commit,
559: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 591: OZF_Disc_Line_PVT.Create_Disc_Tiers(

587: l_offer_tier_rec.end_date_active := p_offer_tier_tbl(i).end_date_active;
588: l_offer_tier_rec.uom_code := p_offer_tier_tbl(i).uom_code;
589:
590: IF p_offer_tier_tbl(i).operation = 'CREATE' THEN
591: OZF_Disc_Line_PVT.Create_Disc_Tiers(
592: p_api_version_number => p_api_version,
593: p_init_msg_list => p_init_msg_list,
594: p_commit => p_commit,
595: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 611: OZF_Disc_Line_PVT.Update_Disc_Tiers(

607: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
608: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;
609: l_offer_tier_rec.object_version_number := p_offer_tier_tbl(i).object_version_number;
610:
611: OZF_Disc_Line_PVT.Update_Disc_Tiers(
612: p_api_version_number => p_api_version,
613: p_init_msg_list => p_init_msg_list,
614: p_commit => p_commit,
615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 628: OZF_Disc_Line_PVT.Delete_Disc_tiers(

624: RAISE Fnd_Api.g_exc_unexpected_error;
625: END IF;
626: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
627: 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
628: OZF_Disc_Line_PVT.Delete_Disc_tiers(
629: p_api_version_number => p_api_version,
630: p_init_msg_list => p_init_msg_list,
631: p_commit => p_commit,
632: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 644: OZF_Disc_Line_PVT.Delete_Tier_line(

640: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
641: RAISE Fnd_Api.g_exc_unexpected_error;
642: END IF;
643: ELSE
644: OZF_Disc_Line_PVT.Delete_Tier_line(
645: p_api_version_number => p_api_version,
646: p_init_msg_list => p_init_msg_list,
647: p_commit => p_commit,
648: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 683: OZF_Disc_Line_PVT.Create_Ozf_Prod_Line(

679: ELSE
680: l_prod_rec.offer_id := p_prod_tbl(i).offer_id;
681: END IF;
682:
683: OZF_Disc_Line_PVT.Create_Ozf_Prod_Line(
684: p_api_version_number => p_api_version,
685: p_init_msg_list => p_init_msg_list,
686: p_commit => p_commit,
687: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 704: OZF_Disc_Line_PVT.Update_Ozf_Prod_Line(

700: l_prod_rec.off_discount_product_id := p_prod_tbl(i).off_discount_product_id;
701: l_prod_rec.offer_id := p_prod_tbl(i).offer_id;
702: l_prod_rec.object_version_number := p_prod_tbl(i).object_version_number;
703:
704: OZF_Disc_Line_PVT.Update_Ozf_Prod_Line(
705: p_api_version_number => p_api_version,
706: p_init_msg_list => p_init_msg_list,
707: p_commit => p_commit,
708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 720: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

716: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
717: RAISE Fnd_Api.g_exc_unexpected_error;
718: END IF;
719: ELSIF p_prod_tbl(i).operation = 'DELETE' THEN
720: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
721: p_api_version_number => p_api_version,
722: p_init_msg_list => p_init_msg_list,
723: p_commit => p_commit,
724: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 750: OZF_Disc_Line_PVT.Create_Product_Exclusion(

746: l_excl_rec.end_date_active := p_excl_tbl(i).end_date_active;
747: l_excl_rec.parent_off_disc_prod_id := p_excl_tbl(i).parent_off_disc_prod_id;
748:
749: IF p_excl_tbl(i).operation = 'CREATE' THEN
750: OZF_Disc_Line_PVT.Create_Product_Exclusion(
751: p_api_version_number => p_api_version,
752: p_init_msg_list => p_init_msg_list,
753: p_commit => p_commit,
754: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 770: OZF_Disc_Line_PVT.Update_Product_Exclusion(

766: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
767: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;
768: l_excl_rec.object_version_number := p_excl_tbl(i).object_version_number;
769:
770: OZF_Disc_Line_PVT.Update_Product_Exclusion(
771: p_api_version_number => p_api_version,
772: p_init_msg_list => p_init_msg_list,
773: p_commit => p_commit,
774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 786: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

782: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
783: RAISE Fnd_Api.g_exc_unexpected_error;
784: END IF;
785: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
786: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
787: p_api_version_number => p_api_version,
788: p_init_msg_list => p_init_msg_list,
789: p_commit => p_commit,
790: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 822: OZF_Disc_Line_PVT.Create_Disc_Tiers(

818: l_offer_tier_rec.end_date_active := p_offer_tier_tbl(i).end_date_active;
819: l_offer_tier_rec.uom_code := p_offer_tier_tbl(i).uom_code;
820:
821: IF p_offer_tier_tbl(i).operation = 'CREATE' THEN
822: OZF_Disc_Line_PVT.Create_Disc_Tiers(
823: p_api_version_number => p_api_version,
824: p_init_msg_list => p_init_msg_list,
825: p_commit => p_commit,
826: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 842: OZF_Disc_Line_PVT.Update_Disc_Tiers(

838: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
839: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;
840: l_offer_tier_rec.object_version_number := p_offer_tier_tbl(i).object_version_number;
841:
842: OZF_Disc_Line_PVT.Update_Disc_Tiers(
843: p_api_version_number => p_api_version,
844: p_init_msg_list => p_init_msg_list,
845: p_commit => p_commit,
846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 859: OZF_Disc_Line_PVT.Delete_Disc_tiers(

855: RAISE Fnd_Api.g_exc_unexpected_error;
856: END IF;
857: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
858: 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
859: OZF_Disc_Line_PVT.Delete_Disc_tiers(
860: p_api_version_number => p_api_version,
861: p_init_msg_list => p_init_msg_list,
862: p_commit => p_commit,
863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 875: OZF_Disc_Line_PVT.Delete_Tier_line(

871: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
872: RAISE Fnd_Api.g_exc_unexpected_error;
873: END IF;
874: ELSE
875: OZF_Disc_Line_PVT.Delete_Tier_line(
876: p_api_version_number => p_api_version,
877: p_init_msg_list => p_init_msg_list,
878: p_commit => p_commit,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,