APPS.OZF_DISC_LINE_PVT dependencies on OZF_CREATE_OZF_PROD_LINE_PKG

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

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

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

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

Line 2424: Ozf_Create_Ozf_Prod_Line_Pkg.Insert_Row(

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

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

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

Line 2664: Ozf_Create_Ozf_Prod_Line_Pkg.Update_Row(

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

Line 2769: OZF_Create_Ozf_Prod_Line_PKG.Delete_row(

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

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

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

Line 2924: Ozf_Create_Ozf_Prod_Line_Pkg.Delete_Row(

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

Line 5534: -- Delete_Relation,OZF_Create_Ozf_Prod_Line_PKG.Delete_product

5530: -- Delete_Product
5531: -- Type
5532: -- Private
5533: -- Pre-Req
5534: -- Delete_Relation,OZF_Create_Ozf_Prod_Line_PKG.Delete_product
5535: -- Parameters
5536: --
5537: -- IN
5538: -- p_api_version_number IN NUMBER Required

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

5617: );
5618: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5619: RAISE FND_API.G_EXC_ERROR;
5620: END IF;
5621: OZF_Create_Ozf_Prod_Line_PKG.Delete_product(p_offer_discount_line_id => p_offer_discount_line_id);
5622: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
5623: RAISE FND_API.G_EXC_ERROR;
5624: END IF;
5625: