APPS.OZF_PROD_RELN_PKG dependencies on OZF_DISCOUNT_PRODUCT_RELN

Line 59: INSERT INTO ozf_discount_product_reln(

55:
56: px_object_version_number := nvl(px_object_version_number, 1);
57:
58:
59: INSERT INTO ozf_discount_product_reln(
60: discount_product_reln_id,
61: offer_discount_line_id,
62: off_discount_product_id,
63: creation_date,

Line 109: Update ozf_discount_product_reln

105:
106:
107: IS
108: BEGIN
109: Update ozf_discount_product_reln
110: SET
111: discount_product_reln_id = DECODE( p_discount_product_reln_id, null, discount_product_reln_id, FND_API.G_MISS_NUM, null, p_discount_product_reln_id),
112: offer_discount_line_id = DECODE( p_offer_discount_line_id, null, offer_discount_line_id, FND_API.G_MISS_NUM, null, p_offer_discount_line_id),
113: off_discount_product_id = DECODE( p_off_discount_product_id, null, off_discount_product_id, FND_API.G_MISS_NUM, null, p_off_discount_product_id),

Line 149: DELETE FROM ozf_discount_product_reln

145: p_discount_product_reln_id NUMBER,
146: p_object_version_number NUMBER)
147: IS
148: BEGIN
149: DELETE FROM ozf_discount_product_reln
150: WHERE discount_product_reln_id = p_discount_product_reln_id
151: AND object_version_number = p_object_version_number;
152: If (SQL%NOTFOUND) then
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 175: DELETE FROM ozf_discount_product_reln

171: p_offer_discount_line_id NUMBER
172: )
173: IS
174: BEGIN
175: DELETE FROM ozf_discount_product_reln
176: WHERE offer_discount_line_id = p_offer_discount_line_id;
177:
178: If (SQL%NOTFOUND) then
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 204: FROM ozf_discount_product_reln

200: p_object_version_number NUMBER)
201: IS
202: CURSOR C IS
203: SELECT *
204: FROM ozf_discount_product_reln
205: WHERE discount_product_reln_id = p_discount_product_reln_id
206: AND object_version_number = p_object_version_number
207: FOR UPDATE OF discount_product_reln_id NOWAIT;
208: Recinfo C%ROWTYPE;