APPS.OZF_DISC_LINE_PVT dependencies on OZF_CREATE_OZF_PROD_LINE_PKG

Line 1663: Ozf_Create_Ozf_Prod_Line_Pkg.Lock_Row(l_off_discount_product_id,p_object_version);

1659: x_return_status := FND_API.G_RET_STS_SUCCESS;
1660:
1661:
1662: ------------------------ lock -------------------------
1663: Ozf_Create_Ozf_Prod_Line_Pkg.Lock_Row(l_off_discount_product_id,p_object_version);
1664:
1665:
1666: -------------------- finish --------------------------
1667: FND_MSG_PUB.count_and_get(

Line 2422: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row)

2418:
2419: -- Debug Message
2420: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
2421:
2422: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row)
2423: Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row(
2424: px_off_discount_product_id => l_off_discount_product_id,
2425: p_parent_off_disc_prod_id => l_ozf_prod_rec.parent_off_disc_prod_id,
2426: p_product_level => l_ozf_prod_rec.product_level,

Line 2423: Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row(

2419: -- Debug Message
2420: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
2421:
2422: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row)
2423: Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row(
2424: px_off_discount_product_id => l_off_discount_product_id,
2425: p_parent_off_disc_prod_id => l_ozf_prod_rec.parent_off_disc_prod_id,
2426: p_product_level => l_ozf_prod_rec.product_level,
2427: p_product_id => l_ozf_prod_rec.product_id,

Line 2662: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row)

2658:
2659: -- Debug Message
2660: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
2661:
2662: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row)
2663: Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row(
2664: p_off_discount_product_id => p_ozf_prod_rec.off_discount_product_id,
2665: p_parent_off_disc_prod_id => p_ozf_prod_rec.parent_off_disc_prod_id,
2666: p_product_level => p_ozf_prod_rec.product_level,

Line 2663: Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row(

2659: -- Debug Message
2660: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
2661:
2662: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row)
2663: Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row(
2664: p_off_discount_product_id => p_ozf_prod_rec.off_discount_product_id,
2665: p_parent_off_disc_prod_id => p_ozf_prod_rec.parent_off_disc_prod_id,
2666: p_product_level => p_ozf_prod_rec.product_level,
2667: p_product_id => p_ozf_prod_rec.product_id,

Line 2768: OZF_Create_Ozf_Prod_Line_PKG.Delete_row(

2764:
2765: ozf_utility_pvt.debug_message('@# Parent Prod Id is '||p_parent_off_disc_prod_id);
2766: FOR excl_rec IN c_excl_id LOOP
2767: ozf_utility_pvt.debug_message('@# Prod id is '||excl_rec.off_discount_product_id);
2768: OZF_Create_Ozf_Prod_Line_PKG.Delete_row(
2769: p_off_discount_product_id => excl_rec.off_discount_product_id,
2770: p_object_version_number => excl_rec.object_version_number);
2771: END LOOP;
2772:

Line 2901: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Delete_Row)

2897: -- Api body
2898: --
2899: -- Debug Message
2900: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
2901: -- Invoke table handler(Ozf_Create_Ozf_Prod_Line_Pkg.Delete_Row)
2902: open c_offer_id(p_off_discount_product_id);
2903: fetch c_offer_id INTO l_offer_id;
2904: close c_offer_id;
2905: IF is_delete_valid(l_offer_id) = 'N' THEN

Line 2923: Ozf_Create_Ozf_Prod_Line_Pkg.Delete_Row(

2919:
2920: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2921: RAISE FND_API.G_EXC_ERROR;
2922: END IF;
2923: Ozf_Create_Ozf_Prod_Line_Pkg.Delete_Row(
2924: p_off_discount_product_id => p_off_discount_product_id,
2925: p_object_version_number => p_object_version_number );
2926: --
2927: -- End of API body

Line 5515: -- Delete_Relation,OZF_Create_Ozf_Prod_Line_PKG.Delete_product

5511: -- Delete_Product
5512: -- Type
5513: -- Private
5514: -- Pre-Req
5515: -- Delete_Relation,OZF_Create_Ozf_Prod_Line_PKG.Delete_product
5516: -- Parameters
5517: --
5518: -- IN
5519: -- p_api_version_number IN NUMBER Required

Line 5602: OZF_Create_Ozf_Prod_Line_PKG.Delete_product(p_offer_discount_line_id => p_offer_discount_line_id);

5598: );
5599: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5600: RAISE FND_API.G_EXC_ERROR;
5601: END IF;
5602: OZF_Create_Ozf_Prod_Line_PKG.Delete_product(p_offer_discount_line_id => p_offer_discount_line_id);
5603: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5604: RAISE FND_API.G_EXC_ERROR;
5605: END IF;
5606: