APPS.AMS_LIST_ENTRIES_PKG dependencies on AMS_LIST_ENTRIES

Line 1: PACKAGE BODY AMS_LIST_ENTRIES_PKG as

1: PACKAGE BODY AMS_LIST_ENTRIES_PKG as
2: /* $Header: amstlieb.pls 115.14 2003/04/25 22:44:46 vbhandar ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_LIST_ENTRIES_PKG

2: /* $Header: amstlieb.pls 115.14 2003/04/25 22:44:46 vbhandar ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_LIST_ENTRIES_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 435: INSERT INTO AMS_LIST_ENTRIES(

431:
432: px_object_version_number := 1;
433:
434:
435: INSERT INTO AMS_LIST_ENTRIES(
436: list_entry_id,
437: list_header_id,
438: last_update_date,
439: last_updated_by,

Line 1606: Update AMS_LIST_ENTRIES

1602: )
1603:
1604: IS
1605: BEGIN
1606: Update AMS_LIST_ENTRIES
1607: SET
1608: list_entry_id = DECODE( p_list_entry_id, FND_API.g_miss_num, list_entry_id, p_list_entry_id),
1609: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
1610: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 2019: DELETE FROM AMS_LIST_ENTRIES

2015: PROCEDURE Delete_Row(
2016: p_LIST_ENTRY_ID NUMBER)
2017: IS
2018: BEGIN
2019: DELETE FROM AMS_LIST_ENTRIES
2020: WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID;
2021: If (SQL%NOTFOUND) then
2022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2023: End If;

Line 2424: FROM AMS_LIST_ENTRIES

2420:
2421: IS
2422: CURSOR C IS
2423: SELECT *
2424: FROM AMS_LIST_ENTRIES
2425: WHERE LIST_ENTRY_ID = p_LIST_ENTRY_ID
2426: FOR UPDATE of LIST_ENTRY_ID NOWAIT;
2427: Recinfo C%ROWTYPE;
2428: BEGIN

Line 3566: END AMS_LIST_ENTRIES_PKG;

3562: APP_EXCEPTION.RAISE_EXCEPTION;
3563: END IF;
3564: END Lock_Row;
3565:
3566: END AMS_LIST_ENTRIES_PKG;