APPS.OZF_CREATE_OZF_PROD_LINE_PKG dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 66: INSERT INTO ozf_offer_discount_products(

62:
63: px_object_version_number := nvl(px_object_version_number, 1);
64:
65:
66: INSERT INTO ozf_offer_discount_products(
67: off_discount_product_id,
68: parent_off_disc_prod_id,
69: product_level,
70: product_id,

Line 150: INSERT INTO ozf_offer_discount_products(

146:
147: px_object_version_number := nvl(px_object_version_number, 1);
148:
149:
150: INSERT INTO ozf_offer_discount_products(
151: off_discount_product_id,
152: parent_off_disc_prod_id,
153: product_level,
154: product_id,

Line 230: Update ozf_offer_discount_products

226: p_object_version_number IN NUMBER)
227:
228: IS
229: BEGIN
230: Update ozf_offer_discount_products
231: SET
232: 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),
233: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
234: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),

Line 294: Update ozf_offer_discount_products

290: p_object_version_number IN NUMBER)
291:
292: IS
293: BEGIN
294: Update ozf_offer_discount_products
295: SET
296: 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),
297: parent_off_disc_prod_id = DECODE( p_parent_off_disc_prod_id, null, parent_off_disc_prod_id, FND_API.G_MISS_NUM, null, p_parent_off_disc_prod_id),
298: product_level = DECODE( p_product_level, null, product_level, FND_API.g_miss_char, null, p_product_level),

Line 345: DELETE FROM ozf_offer_discount_products

341: p_off_discount_product_id NUMBER,
342: p_object_version_number NUMBER)
343: IS
344: BEGIN
345: DELETE FROM ozf_offer_discount_products
346: WHERE off_discount_product_id = p_off_discount_product_id
347: AND object_version_number = p_object_version_number;
348: If (SQL%NOTFOUND) then
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 359: DELETE FROM ozf_offer_discount_products

355: p_offer_discount_line_id NUMBER
356: )
357: IS
358: BEGIN
359: DELETE FROM ozf_offer_discount_products
360: WHERE offer_discount_line_id = p_offer_discount_line_id;
361: If (SQL%NOTFOUND) then
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;

Line 386: FROM ozf_offer_discount_products

382: p_object_version_number NUMBER)
383: IS
384: CURSOR C IS
385: SELECT *
386: FROM ozf_offer_discount_products
387: WHERE off_discount_product_id = p_off_discount_product_id
388: AND object_version_number = p_object_version_number
389: FOR UPDATE OF off_discount_product_id NOWAIT;
390: Recinfo C%ROWTYPE;