APPS.AMS_ACT_LISTS_PKG dependencies on AMS_ACT_LISTS

Line 1: PACKAGE BODY AMS_ACT_LISTS_PKG as

1: PACKAGE BODY AMS_ACT_LISTS_PKG as
2: /* $Header: amstalsb.pls 115.8 2003/05/08 20:55:55 jieli ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_ACT_LISTS_PKG

2: /* $Header: amstalsb.pls 115.8 2003/05/08 20:55:55 jieli ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_ACT_LISTS_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 53: INSERT INTO AMS_ACT_LISTS(

49: IS
50: x_rowid VARCHAR2(30);
51: BEGIN
52: px_object_version_number := 1;
53: INSERT INTO AMS_ACT_LISTS(
54: act_list_header_id,
55: last_update_date,
56: last_updated_by,
57: creation_date,

Line 113: Update AMS_ACT_LISTS

109: p_order_number NUMBER
110: )
111: IS
112: BEGIN
113: Update AMS_ACT_LISTS
114: SET act_list_header_id = DECODE( p_act_list_header_id,
115: FND_API.g_miss_num,
116: act_list_header_id,
117: p_act_list_header_id),

Line 190: DELETE FROM AMS_ACT_LISTS

186: PROCEDURE Delete_Row(
187: p_ACT_LIST_HEADER_ID NUMBER)
188: IS
189: BEGIN
190: DELETE FROM AMS_ACT_LISTS
191: WHERE ACT_LIST_HEADER_ID = p_ACT_LIST_HEADER_ID;
192: If (SQL%NOTFOUND) then
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: End If;

Line 228: FROM AMS_ACT_LISTS

224:
225: IS
226: CURSOR C IS
227: SELECT *
228: FROM AMS_ACT_LISTS
229: WHERE ACT_LIST_HEADER_ID = p_ACT_LIST_HEADER_ID
230: FOR UPDATE of ACT_LIST_HEADER_ID NOWAIT;
231: Recinfo C%ROWTYPE;
232: BEGIN

Line 290: END AMS_ACT_LISTS_PKG;

286: APP_EXCEPTION.RAISE_EXCEPTION;
287: END IF;
288: END Lock_Row;
289:
290: END AMS_ACT_LISTS_PKG;