APPS.OZF_OFFER_ADJ_NEW_LINES_PKG dependencies on OZF_OFFER_ADJ_NEW_LINES

Line 1: PACKAGE BODY OZF_OFFER_ADJ_NEW_LINES_PKG as

1: PACKAGE BODY OZF_OFFER_ADJ_NEW_LINES_PKG as
2: /* $Header: ozftanlb.pls 120.0 2006/03/30 13:49:34 rssharma noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_OFFER_ADJ_NEW_LINES_PKG

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

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

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

Line 66: INSERT INTO OZF_OFFER_ADJ_NEW_LINES(

62:
63: px_object_version_number := 1;
64:
65:
66: INSERT INTO OZF_OFFER_ADJ_NEW_LINES(
67: offer_adj_new_line_id,
68: offer_adjustment_id,
69: volume_from,
70: volume_to,

Line 154: Update OZF_OFFER_ADJ_NEW_LINES

150: p_object_version_number NUMBER)
151:
152: IS
153: BEGIN
154: Update OZF_OFFER_ADJ_NEW_LINES
155: SET
156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),

Line 204: DELETE FROM OZF_OFFER_ADJ_NEW_LINES

200: PROCEDURE Delete_Row(
201: p_OFFER_ADJ_NEW_LINE_ID NUMBER)
202: IS
203: BEGIN
204: DELETE FROM OZF_OFFER_ADJ_NEW_LINES
205: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID;
206: If (SQL%NOTFOUND) then
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: End If;

Line 253: FROM OZF_OFFER_ADJ_NEW_LINES

249:
250: IS
251: CURSOR C IS
252: SELECT *
253: FROM OZF_OFFER_ADJ_NEW_LINES
254: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID
255: FOR UPDATE of OFFER_ADJ_NEW_LINE_ID NOWAIT;
256: Recinfo C%ROWTYPE;
257: BEGIN

Line 330: END OZF_OFFER_ADJ_NEW_LINES_PKG;

326: APP_EXCEPTION.RAISE_EXCEPTION;
327: END IF;
328: END Lock_Row;
329:
330: END OZF_OFFER_ADJ_NEW_LINES_PKG;