APPS.OZF_ACCOUNT_ALLOCATIONS_PKG dependencies on OZF_ACCOUNT_ALLOCATIONS

Line 1: PACKAGE BODY OZF_ACCOUNT_ALLOCATIONS_PKG AS

1: PACKAGE BODY OZF_ACCOUNT_ALLOCATIONS_PKG AS
2: /* $Header: ozftaalb.pls 120.0 2005/05/31 23:14:58 appldev noship $ */
3:
4: ---g_version CONSTANT CHAR(80) := '$Header: ozftaalb.pls 120.0 2005/05/31 23:14:58 appldev noship $';
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_ACCOUNT_ALLOCATIONS_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_ACCOUNT_ALLOCATIONS_PKG';

1: PACKAGE BODY OZF_ACCOUNT_ALLOCATIONS_PKG AS
2: /* $Header: ozftaalb.pls 120.0 2005/05/31 23:14:58 appldev noship $ */
3:
4: ---g_version CONSTANT CHAR(80) := '$Header: ozftaalb.pls 120.0 2005/05/31 23:14:58 appldev noship $';
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_ACCOUNT_ALLOCATIONS_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftaalb.pls';
7:
8: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
9: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 80: INSERT INTO ozf_account_allocations(

76: END IF;
77:
78: px_object_version_number := nvl(px_object_version_number, 1);
79:
80: INSERT INTO ozf_account_allocations(
81: account_allocation_id,
82: allocation_for,
83: allocation_for_id,
84: cust_account_id,

Line 218: Update ozf_account_allocations

214: p_attribute15 VARCHAR2
215: )
216: IS
217: BEGIN
218: Update ozf_account_allocations
219: SET
220: account_allocation_id = DECODE( p_account_allocation_id, null, account_allocation_id, FND_API.G_MISS_NUM, null, p_account_allocation_id),
221: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
222: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),

Line 286: DELETE FROM ozf_account_allocations

282: p_account_allocation_id NUMBER,
283: p_object_version_number NUMBER)
284: IS
285: BEGIN
286: DELETE FROM ozf_account_allocations
287: WHERE account_allocation_id = p_account_allocation_id
288: AND object_version_number = p_object_version_number;
289: If (SQL%NOTFOUND) then
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 316: FROM ozf_account_allocations

312: p_object_version_number NUMBER)
313: IS
314: CURSOR C IS
315: SELECT *
316: FROM ozf_account_allocations
317: WHERE account_allocation_id = p_account_allocation_id
318: AND object_version_number = p_object_version_number
319: FOR UPDATE OF account_allocation_id NOWAIT;
320: Recinfo C%ROWTYPE;

Line 335: END Ozf_Account_Allocations_PKG;

331: END Lock_Row;
332:
333:
334:
335: END Ozf_Account_Allocations_PKG;