APPS.AMS_LIST_PURGE_PVT dependencies on AMS_LIST_PURGE_PVT

Line 1: PACKAGE BODY AMS_List_Purge_PVT AS

1: PACKAGE BODY AMS_List_Purge_PVT AS
2: /* $Header: amsvimcb.pls 120.5 2006/04/05 06:12:05 bmuthukr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_List_Purge_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvimcb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_List_Purge_PVT';

1: PACKAGE BODY AMS_List_Purge_PVT AS
2: /* $Header: amsvimcb.pls 120.5 2006/04/05 06:12:05 bmuthukr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_List_Purge_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvimcb.pls';
6:
7:
8:

Line 966: PROCEDURE delete_list_info(p_id_tbl IN ams_list_purge_pvt.l_id_tbl%type,

962: );
963:
964: END Increase_Usage;
965:
966: PROCEDURE delete_list_info(p_id_tbl IN ams_list_purge_pvt.l_id_tbl%type,
967: x_return_status OUT NOCOPY VARCHAR2,
968: x_msg_count OUT NOCOPY NUMBER,
969: x_msg_data OUT NOCOPY VARCHAR2) is
970: BEGIN

Line 1075: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;

1071: l_conc_request_id number;
1072: l_children_done boolean := false;
1073: --TYPE l_num_tbl IS table of number index by binary_integer;
1074: --l_header_id_tbl l_num_tbl;
1075: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;
1076: type l_char_tbl is table of varchar2(1000) index by binary_integer;
1077: l_list_name_tbl l_char_tbl;
1078:
1079: BEGIN

Line 1282: PROCEDURE delete_entries_soft (p_list_header_id_tbl IN AMS_LIST_PURGE_PVT.l_list_header_id_tbl%type,

1278: x_errbuf := SQLERRM;
1279: RAISE;
1280: END delete_list_worker;
1281:
1282: PROCEDURE delete_entries_soft (p_list_header_id_tbl IN AMS_LIST_PURGE_PVT.l_list_header_id_tbl%type,
1283: x_return_status OUT NOCOPY VARCHAR2,
1284: x_msg_count OUT NOCOPY NUMBER,
1285: x_msg_data OUT NOCOPY VARCHAR2) is
1286:

Line 1326: PROCEDURE delete_entries_online(p_list_header_id_tbl IN AMS_LIST_PURGE_PVT.l_list_header_id_tbl%type,

1322: raise;
1323: END delete_entries_soft;
1324:
1325:
1326: PROCEDURE delete_entries_online(p_list_header_id_tbl IN AMS_LIST_PURGE_PVT.l_list_header_id_tbl%type,
1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,
1329: x_msg_data OUT NOCOPY VARCHAR2) is
1330:

Line 1331: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;

1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,
1329: x_msg_data OUT NOCOPY VARCHAR2) is
1330:
1331: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;
1332:
1333: BEGIN
1334: x_return_status := FND_API.G_RET_STS_SUCCESS;
1335:

Line 1389: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;

1385:
1386: --TYPE l_num_tbl IS table of number index by binary_integer;
1387: --l_header_id_tbl l_num_tbl;
1388:
1389: l_header_id_tbl ams_list_purge_pvt.l_id_tbl%type;
1390:
1391: type l_char_tbl is table of varchar2(1000) index by binary_integer;
1392: l_list_name_tbl l_char_tbl;
1393: l_start_date date;

Line 1626: END AMS_List_Purge_PVT;

1622: x_errbuf := SQLERRM;
1623: RAISE;
1624: END purge_entries_worker;
1625:
1626: END AMS_List_Purge_PVT;