APPS.OZF_PRODUCT_ALLOCATIONS_PKG dependencies on OZF_PRODUCT_ALLOCATIONS

Line 1: PACKAGE BODY OZF_PRODUCT_ALLOCATIONS_PKG AS

1: PACKAGE BODY OZF_PRODUCT_ALLOCATIONS_PKG AS
2: /* $Header: ozftpalb.pls 120.0 2005/06/01 03:16:19 appldev noship $ */
3:
4: ---g_version CONSTANT CHAR(80) := '$Header: ozftpalb.pls 120.0 2005/06/01 03:16:19 appldev noship $';
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_PRODUCT_ALLOCATIONS_PKG';

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

1: PACKAGE BODY OZF_PRODUCT_ALLOCATIONS_PKG AS
2: /* $Header: ozftpalb.pls 120.0 2005/06/01 03:16:19 appldev noship $ */
3:
4: ---g_version CONSTANT CHAR(80) := '$Header: ozftpalb.pls 120.0 2005/06/01 03:16:19 appldev noship $';
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_PRODUCT_ALLOCATIONS_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftpalb.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 75: INSERT INTO ozf_product_allocations(

71: END IF;
72:
73: px_object_version_number := nvl(px_object_version_number, 1);
74:
75: INSERT INTO ozf_product_allocations(
76: product_allocation_id,
77: allocation_for,
78: allocation_for_id,
79: fund_id,

Line 198: Update ozf_product_allocations

194: p_attribute15 VARCHAR2
195: )
196: IS
197: BEGIN
198: Update ozf_product_allocations
199: SET
200: product_allocation_id = DECODE( p_product_allocation_id, null, product_allocation_id, FND_API.G_MISS_NUM, null, p_product_allocation_id),
201: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
202: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),

Line 261: DELETE FROM ozf_product_allocations

257: p_product_allocation_id NUMBER,
258: p_object_version_number NUMBER)
259: IS
260: BEGIN
261: DELETE FROM ozf_product_allocations
262: WHERE product_allocation_id = p_product_allocation_id
263: AND object_version_number = p_object_version_number;
264: If (SQL%NOTFOUND) then
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 291: FROM ozf_product_allocations

287: p_object_version_number NUMBER)
288: IS
289: CURSOR C IS
290: SELECT *
291: FROM ozf_product_allocations
292: WHERE product_allocation_id = p_product_allocation_id
293: AND object_version_number = p_object_version_number
294: FOR UPDATE OF product_allocation_id NOWAIT;
295: Recinfo C%ROWTYPE;

Line 310: END Ozf_Product_Allocations_PKG;

306: END Lock_Row;
307:
308:
309:
310: END Ozf_Product_Allocations_PKG;