APPS.AMS_LISTENTRY_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 71: FROM ams_list_headers_all

67:
68: --getting the primary key and arc qualifer of the entity which owns this list.
69: CURSOR c_header_dets(header_id IN NUMBER)IS
70: SELECT list_used_by_id,arc_list_used_by
71: FROM ams_list_headers_all
72: WHERE list_header_id = header_id;
73:
74: l_list_used_by_id NUMBER;
75: l_arc_used_by VARCHAR2(30);

Line 333: 'ams_list_headers_all',

329:
330: -------------------------- List Header Id ------------------------
331: IF p_entry_rec.list_header_id <> FND_API.g_miss_num THEN
332: IF AMS_Utility_PVT.check_fk_exists(
333: 'ams_list_headers_all',
334: 'list_header_id',
335: p_entry_rec.list_header_id
336: ) = FND_API.g_false
337: THEN

Line 813: FROM ams_list_headers_all

809: l_created_by NUMBER; --batoleti added this var. For bug# 6688996
810: /* batoleti. Bug# 6688996. Added the below cursor */
811: CURSOR cur_get_created_by (x_list_header_id IN NUMBER) IS
812: SELECT created_by
813: FROM ams_list_headers_all
814: WHERE list_header_id= x_list_header_id;
815:
816:
817: BEGIN

Line 4714: --taken from ams_list_headers_all table.

4710:
4711: l_api_name CONSTANT VARCHAR2(30) := 'Update_ListEntry_Source_Code';
4712: l_api_version CONSTANT NUMBER := 1.0;
4713:
4714: --taken from ams_list_headers_all table.
4715: l_list_used_by_id NUMBER;
4716: l_arc_list_used_by VARCHAR2(30);
4717:
4718:

Line 4725: From ams_list_headers_all

4721: l_source_id NUMBER;
4722:
4723: Cursor C_Header_Dets Is Select list_used_by_id,
4724: arc_list_used_by
4725: From ams_list_headers_all
4726: where list_header_id = p_list_id;
4727:
4728: Cursor C_Current_Code IS select max(Source_Code)
4729: from ams_list_entries