APPS.AMS_ACT_LIST_GROUPS_PKG dependencies on AMS_ACT_LIST_GROUPS

Line 1: PACKAGE BODY AMS_ACT_LIST_GROUPS_PKG as

1: PACKAGE BODY AMS_ACT_LIST_GROUPS_PKG as
2: /* $Header: amstlgpb.pls 115.4 2002/11/22 08:54:30 jieli ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_ACT_LIST_GROUPS_PKG

2: /* $Header: amstlgpb.pls 115.4 2002/11/22 08:54:30 jieli ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_ACT_LIST_GROUPS_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 76: INSERT INTO AMS_ACT_LIST_GROUPS(

72:
73: px_object_version_number := 1;
74:
75:
76: INSERT INTO AMS_ACT_LIST_GROUPS(
77: act_list_group_id,
78: act_list_used_by_id,
79: arc_act_list_used_by,
80: group_code,

Line 170: Update AMS_ACT_LIST_GROUPS

166: p_quota_reset NUMBER)
167:
168: IS
169: BEGIN
170: Update AMS_ACT_LIST_GROUPS
171: SET
172: act_list_group_id = DECODE( p_act_list_group_id, FND_API.g_miss_num, act_list_group_id, p_act_list_group_id),
173: act_list_used_by_id = DECODE( p_act_list_used_by_id, FND_API.g_miss_num, act_list_used_by_id, p_act_list_used_by_id),
174: arc_act_list_used_by = DECODE( p_arc_act_list_used_by, FND_API.g_miss_char, arc_act_list_used_by, p_arc_act_list_used_by),

Line 224: DELETE FROM AMS_ACT_LIST_GROUPS

220: PROCEDURE Delete_Row(
221: p_ACT_LIST_GROUP_ID NUMBER)
222: IS
223: BEGIN
224: DELETE FROM AMS_ACT_LIST_GROUPS
225: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID;
226: If (SQL%NOTFOUND) then
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: End If;

Line 277: FROM AMS_ACT_LIST_GROUPS

273:
274: IS
275: CURSOR C IS
276: SELECT *
277: FROM AMS_ACT_LIST_GROUPS
278: WHERE ACT_LIST_GROUP_ID = p_ACT_LIST_GROUP_ID
279: FOR UPDATE of ACT_LIST_GROUP_ID NOWAIT;
280: Recinfo C%ROWTYPE;
281: BEGIN

Line 366: END AMS_ACT_LIST_GROUPS_PKG;

362: APP_EXCEPTION.RAISE_EXCEPTION;
363: END IF;
364: END Lock_Row;
365:
366: END AMS_ACT_LIST_GROUPS_PKG;