APPS.OZF_TIME_ALLOCATIONS_PKG dependencies on OZF_TIME_ALLOCATIONS

Line 1: PACKAGE BODY OZF_TIME_ALLOCATIONS_PKG AS

1: PACKAGE BODY OZF_TIME_ALLOCATIONS_PKG AS
2: /* $Header: ozfttalb.pls 120.2 2005/08/04 04:49:55 appldev ship $ */
3:
4: ---g_version CONSTANT CHAR(80) := '$Header: ozfttalb.pls 120.2 2005/08/04 04:49:55 appldev ship $';
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_TIME_ALLOCATIONS_PKG';

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

1: PACKAGE BODY OZF_TIME_ALLOCATIONS_PKG AS
2: /* $Header: ozfttalb.pls 120.2 2005/08/04 04:49:55 appldev ship $ */
3:
4: ---g_version CONSTANT CHAR(80) := '$Header: ozfttalb.pls 120.2 2005/08/04 04:49:55 appldev ship $';
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OZF_TIME_ALLOCATIONS_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfttalb.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 74: INSERT INTO ozf_time_allocations(

70: */
71: px_object_version_number := nvl(px_object_version_number, 1);
72:
73:
74: INSERT INTO ozf_time_allocations(
75: time_allocation_id,
76: allocation_for,
77: allocation_for_id,
78: time_id,

Line 187: Update ozf_time_allocations

183: p_attribute15 VARCHAR2
184: )
185: IS
186: BEGIN
187: Update ozf_time_allocations
188: SET
189: allocation_for = DECODE( p_allocation_for, null, allocation_for, FND_API.g_miss_char, null, p_allocation_for),
190: allocation_for_id = DECODE( p_allocation_for_id, null, allocation_for_id, FND_API.G_MISS_NUM, null, p_allocation_for_id),
191: time_id = DECODE( p_time_id, null, time_id, FND_API.G_MISS_NUM, null, p_time_id),

Line 246: DELETE FROM ozf_time_allocations

242: p_time_allocation_id NUMBER,
243: p_object_version_number NUMBER)
244: IS
245: BEGIN
246: DELETE FROM ozf_time_allocations
247: WHERE time_allocation_id = p_time_allocation_id
248: AND object_version_number = p_object_version_number;
249: If (SQL%NOTFOUND) then
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 276: FROM ozf_time_allocations

272: p_object_version_number NUMBER)
273: IS
274: CURSOR C IS
275: SELECT *
276: FROM ozf_time_allocations
277: WHERE time_allocation_id = p_time_allocation_id
278: AND object_version_number = p_object_version_number
279: FOR UPDATE OF time_allocation_id NOWAIT;
280: Recinfo C%ROWTYPE;

Line 295: END OZF_Time_Allocations_PKG;

291: END Lock_Row;
292:
293:
294:
295: END OZF_Time_Allocations_PKG;