APPS.OZF_OFFER_PERFORMANCES_PKG dependencies on OZF_OFFER_PERFORMANCES

Line 1: PACKAGE BODY OZF_OFFER_PERFORMANCES_PKG as

1: PACKAGE BODY OZF_OFFER_PERFORMANCES_PKG as
2: /* $Header: ozftperb.pls 120.0 2005/06/01 02:50:06 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_OFFER_PERFORMANCES_PKG

2: /* $Header: ozftperb.pls 120.0 2005/06/01 02:50:06 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_OFFER_PERFORMANCES_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 85: INSERT INTO OZF_OFFER_PERFORMANCES(

81:
82: px_object_version_number := 1;
83:
84:
85: INSERT INTO OZF_OFFER_PERFORMANCES(
86: offer_performance_id,
87: list_header_id,
88: last_update_date,
89: last_updated_by,

Line 218: Update OZF_OFFER_PERFORMANCES

214: p_description VARCHAR2)
215:
216: IS
217: BEGIN
218: Update OZF_OFFER_PERFORMANCES
219: SET
220: offer_performance_id = DECODE( p_offer_performance_id, FND_API.g_miss_num, offer_performance_id, p_offer_performance_id),
221: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
222: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 283: DELETE FROM OZF_OFFER_PERFORMANCES

279: PROCEDURE Delete_Row(
280: p_OFFER_PERFORMANCE_ID NUMBER)
281: IS
282: BEGIN
283: DELETE FROM OZF_OFFER_PERFORMANCES
284: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID;
285: If (SQL%NOTFOUND) then
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: End If;

Line 349: FROM OZF_OFFER_PERFORMANCES

345:
346: IS
347: CURSOR C IS
348: SELECT *
349: FROM OZF_OFFER_PERFORMANCES
350: WHERE OFFER_PERFORMANCE_ID = p_OFFER_PERFORMANCE_ID
351: FOR UPDATE of OFFER_PERFORMANCE_ID NOWAIT;
352: Recinfo C%ROWTYPE;
353: BEGIN

Line 468: END OZF_OFFER_PERFORMANCES_PKG;

464: APP_EXCEPTION.RAISE_EXCEPTION;
465: END IF;
466: END Lock_Row;
467:
468: END OZF_OFFER_PERFORMANCES_PKG;