APPS.OZF_OFFER_ADJUSTMENT_LINES_PKG dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 1: PACKAGE BODY OZF_OFFER_ADJUSTMENT_LINES_PKG as

1: PACKAGE BODY OZF_OFFER_ADJUSTMENT_LINES_PKG as
2: /* $Header: ozftobcb.pls 120.0 2005/06/01 01:47:44 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_OFFER_ADJUSTMENT_LINES_PKG

2: /* $Header: ozftobcb.pls 120.0 2005/06/01 01:47:44 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_OFFER_ADJUSTMENT_LINES_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_OFFER_ADJUSTMENT_LINES_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_OFFER_ADJUSTMENT_LINES_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftobcb.pls';
19:
20:
21: ----------------------------------------------------------

Line 62: INSERT INTO OZF_OFFER_ADJUSTMENT_LINES(

58:
59: px_object_version_number := 1;
60:
61:
62: INSERT INTO OZF_OFFER_ADJUSTMENT_LINES(
63: offer_adjustment_line_id,
64: offer_adjustment_id,
65: list_line_id,
66: arithmetic_operator,

Line 124: Update OZF_OFFER_ADJUSTMENT_LINES

120: p_security_group_id NUMBER)
121:
122: IS
123: BEGIN
124: Update OZF_OFFER_ADJUSTMENT_LINES
125: SET
126: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, FND_API.g_miss_num, offer_adjustment_line_id, p_offer_adjustment_line_id),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),

Line 166: DELETE FROM OZF_OFFER_ADJUSTMENT_LINES

162: PROCEDURE Delete_Row(
163: p_OFFER_ADJUSTMENT_LINE_ID NUMBER)
164: IS
165: BEGIN
166: DELETE FROM OZF_OFFER_ADJUSTMENT_LINES
167: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID;
168: If (SQL%NOTFOUND) then
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: End If;

Line 209: FROM OZF_OFFER_ADJUSTMENT_LINES

205:
206: IS
207: CURSOR C IS
208: SELECT *
209: FROM OZF_OFFER_ADJUSTMENT_LINES
210: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
211: FOR UPDATE of OFFER_ADJUSTMENT_LINE_ID NOWAIT;
212: Recinfo C%ROWTYPE;
213: BEGIN

Line 268: END OZF_OFFER_ADJUSTMENT_LINES_PKG;

264: APP_EXCEPTION.RAISE_EXCEPTION;
265: END IF;
266: END Lock_Row;
267:
268: END OZF_OFFER_ADJUSTMENT_LINES_PKG;