APPS.OZF_OFFER_ADJ_NEW_PRODUCTS_PKG dependencies on OZF_OFFER_ADJ_NEW_PRODUCTS

Line 1: PACKAGE BODY OZF_OFFER_ADJ_NEW_PRODUCTS_PKG as

1: PACKAGE BODY OZF_OFFER_ADJ_NEW_PRODUCTS_PKG as
2: /* $Header: ozftanpb.pls 120.0 2006/03/30 13:47:44 rssharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_OFFER_ADJ_NEW_PRODUCTS_PKG

2: /* $Header: ozftanpb.pls 120.0 2006/03/30 13:47:44 rssharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_OFFER_ADJ_NEW_PRODUCTS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_OFFER_ADJ_NEW_PRODUCTS_PKG';

11: -- NOTE
12: --
13: -- End of Comments
14: -- ===============================================================
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_OFFER_ADJ_NEW_PRODUCTS_PKG';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftanpb.pls';
17: ----------------------------------------------------------
18: ---- MEDIA ----
19: ----------------------------------------------------------

Line 59: INSERT INTO OZF_OFFER_ADJ_NEW_PRODUCTS(

55:
56: px_object_version_number := 1;
57:
58:
59: INSERT INTO OZF_OFFER_ADJ_NEW_PRODUCTS(
60: offer_adj_new_product_id,
61: offer_adj_new_line_id,
62: offer_adjustment_id,
63: product_context,

Line 126: Update OZF_OFFER_ADJ_NEW_PRODUCTS

122: p_object_version_number NUMBER)
123:
124: IS
125: BEGIN
126: Update OZF_OFFER_ADJ_NEW_PRODUCTS
127: SET
128: offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129: , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130: , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)

Line 169: DELETE FROM OZF_OFFER_ADJ_NEW_PRODUCTS

165: PROCEDURE Delete_Row(
166: p_OFFER_ADJ_NEW_PRODUCT_ID NUMBER)
167: IS
168: BEGIN
169: DELETE FROM OZF_OFFER_ADJ_NEW_PRODUCTS
170: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID;
171: If (SQL%NOTFOUND) then
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: End If;

Line 213: FROM OZF_OFFER_ADJ_NEW_PRODUCTS

209:
210: IS
211: CURSOR C IS
212: SELECT *
213: FROM OZF_OFFER_ADJ_NEW_PRODUCTS
214: WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
215: FOR UPDATE of OFFER_ADJ_NEW_PRODUCT_ID NOWAIT;
216: Recinfo C%ROWTYPE;
217: BEGIN

Line 275: END OZF_OFFER_ADJ_NEW_PRODUCTS_PKG;

271: APP_EXCEPTION.RAISE_EXCEPTION;
272: END IF;
273: END Lock_Row;
274:
275: END OZF_OFFER_ADJ_NEW_PRODUCTS_PKG;