APPS.AMS_CAT_ACTIVITIES_PKG dependencies on AMS_CAT_ACTIVITIES

Line 1: PACKAGE BODY AMS_CAT_ACTIVITIES_PKG as

1: PACKAGE BODY AMS_CAT_ACTIVITIES_PKG as
2: /* $Header: amstcacb.pls 115.4 2002/12/27 11:38:08 cgoyal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_CAT_ACTIVITIES_PKG

2: /* $Header: amstcacb.pls 115.4 2002/12/27 11:38:08 cgoyal ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_CAT_ACTIVITIES_PKG
7: -- Purpose
8: --
9: -- History
10: -- 30-Jan-2001 abhola Created

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_CAT_ACTIVITIES_PKG';

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

Line 80: INSERT INTO AMS_CAT_ACTIVITIES(

76:
77: px_object_version_number := 1;
78:
79:
80: INSERT INTO AMS_CAT_ACTIVITIES(
81: cat_activity_id,
82: object_version_number,
83: category_id,
84: activity_id,

Line 183: Update AMS_CAT_ACTIVITIES

179: p_attribute15 VARCHAR2)
180:
181: IS
182: BEGIN
183: Update AMS_CAT_ACTIVITIES
184: SET
185: cat_activity_id = DECODE( p_cat_activity_id, FND_API.g_miss_num, cat_activity_id, p_cat_activity_id),
186: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
187: category_id = DECODE( p_category_id, FND_API.g_miss_num, category_id, p_category_id),

Line 241: DELETE FROM AMS_CAT_ACTIVITIES

237: p_CAT_ACTIVITY_ID NUMBER,
238: p_object_version_number NUMBER)
239: IS
240: BEGIN
241: DELETE FROM AMS_CAT_ACTIVITIES
242: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
243: AND object_version_number = p_object_version_number;
244: If (SQL%NOTFOUND) then
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 298: FROM AMS_CAT_ACTIVITIES

294:
295: IS
296: CURSOR C IS
297: SELECT *
298: FROM AMS_CAT_ACTIVITIES
299: WHERE CAT_ACTIVITY_ID = p_CAT_ACTIVITY_ID
300: FOR UPDATE of CAT_ACTIVITY_ID NOWAIT;
301: Recinfo C%ROWTYPE;
302: BEGIN

Line 398: END AMS_CAT_ACTIVITIES_PKG;

394: APP_EXCEPTION.RAISE_EXCEPTION;
395: END IF;
396: END Lock_Row;
397:
398: END AMS_CAT_ACTIVITIES_PKG;