[Home] [Help]
3069: x_return_status := FND_API.G_RET_STS_SUCCESS;
3070:
3071:
3072: ------------------------ lock -------------------------
3073: Ozf_Prod_Reln_Pkg.Lock_Row(l_discount_product_reln_id,p_object_version);
3074:
3075:
3076: -------------------- finish --------------------------
3077: FND_MSG_PUB.count_and_get(
3717:
3718: -- Debug Message
3719: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
3720:
3721: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Insert_Row)
3722: Ozf_Prod_Reln_Pkg.Insert_Row(
3723: px_discount_product_reln_id => l_discount_product_reln_id,
3724: p_offer_discount_line_id => l_prod_reln_rec.offer_discount_line_id,
3725: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3718: -- Debug Message
3719: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
3720:
3721: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Insert_Row)
3722: Ozf_Prod_Reln_Pkg.Insert_Row(
3723: px_discount_product_reln_id => l_discount_product_reln_id,
3724: p_offer_discount_line_id => l_prod_reln_rec.offer_discount_line_id,
3725: p_off_discount_product_id => l_prod_reln_rec.off_discount_product_id,
3726: p_creation_date => SYSDATE,
3950:
3951: -- Debug Message
3952: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
3953:
3954: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Update_Row)
3955: Ozf_Prod_Reln_Pkg.Update_Row(
3956: p_discount_product_reln_id => p_prod_reln_rec.discount_product_reln_id,
3957: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3958: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3951: -- Debug Message
3952: -- OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
3953:
3954: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Update_Row)
3955: Ozf_Prod_Reln_Pkg.Update_Row(
3956: p_discount_product_reln_id => p_prod_reln_rec.discount_product_reln_id,
3957: p_offer_discount_line_id => p_prod_reln_rec.offer_discount_line_id,
3958: p_off_discount_product_id => p_prod_reln_rec.off_discount_product_id,
3959: p_last_update_date => SYSDATE,
4109: --
4110: -- Debug Message
4111: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
4112:
4113: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Delete_Row)
4114: Ozf_Prod_Reln_Pkg.Delete_Row(
4115: p_discount_product_reln_id => p_discount_product_reln_id,
4116: p_object_version_number => p_object_version_number );
4117: --
4110: -- Debug Message
4111: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
4112:
4113: -- Invoke table handler(Ozf_Prod_Reln_Pkg.Delete_Row)
4114: Ozf_Prod_Reln_Pkg.Delete_Row(
4115: p_discount_product_reln_id => p_discount_product_reln_id,
4116: p_object_version_number => p_object_version_number );
4117: --
4118: -- End of API body
5378: -- Delete_Relation
5379: -- Type
5380: -- Private
5381: -- Pre-Req
5382: -- Ozf_Prod_Reln_Pkg.Delete
5383: -- Parameters
5384: --
5385: -- IN
5386: -- p_api_version_number IN NUMBER Required
5446: -- Initialize API return status to SUCCESS
5447: x_return_status := FND_API.G_RET_STS_SUCCESS;
5448:
5449:
5450: Ozf_Prod_Reln_Pkg.Delete(
5451: p_offer_discount_line_id => p_offer_discount_line_id
5452: );
5453:
5454: