eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LISTHEADER_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 516: 'ams_list_headers_all',

512: IF ( p_validation_mode = JTF_PLSQL_API.g_create
513: AND p_listheader_rec.list_header_id IS NOT NULL) THEN
514:
515: IF AMS_Utility_PVT.check_uniqueness(
516: 'ams_list_headers_all',
517: 'list_header_id = ' || p_listheader_rec.list_header_id
518: ) = FND_API.g_false
519: THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 870: l_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE;

866: x_return_status OUT NOCOPY VARCHAR2
867: ) IS
868:
869: l_dummy NUMBER;
870: l_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE;
871:
872: CURSOR C (p_list_header_id varchar2) IS
873: SELECT COUNT(1)
874: FROM AMS_LIST_HEADERS_ALL

Line 874: FROM AMS_LIST_HEADERS_ALL

870: l_list_header_id AMS_LIST_HEADERS_ALL.LIST_HEADER_ID%TYPE;
871:
872: CURSOR C (p_list_header_id varchar2) IS
873: SELECT COUNT(1)
874: FROM AMS_LIST_HEADERS_ALL
875: WHERE LIST_HEADER_ID = p_list_header_id;
876:
877: -- list header sequence #
878: CURSOR listheader_seq IS

Line 879: SELECT ams_list_headers_all_s.nextval

875: WHERE LIST_HEADER_ID = p_list_header_id;
876:
877: -- list header sequence #
878: CURSOR listheader_seq IS
879: SELECT ams_list_headers_all_s.nextval
880: FROM DUAL;
881:
882: BEGIN
883:

Line 1209: SELECT ams_list_headers_all_s.NEXTVAL

1205: l_list_count NUMBER;
1206: l_main_gen_time DATE := null;
1207:
1208: CURSOR c_list_seq IS
1209: SELECT ams_list_headers_all_s.NEXTVAL
1210: FROM DUAL;
1211:
1212: CURSOR c_list_count(p_list_header_id IN NUMBER) IS
1213: SELECT COUNT(*)

Line 1214: FROM ams_list_headers_all

1210: FROM DUAL;
1211:
1212: CURSOR c_list_count(p_list_header_id IN NUMBER) IS
1213: SELECT COUNT(*)
1214: FROM ams_list_headers_all
1215: WHERE list_header_id = p_list_header_id;
1216: L_OBJECT_TYPE VARCHAR2(10) := 'LIST';
1217:
1218: CURSOR c_custom_setup_id(c_list_type in varchar2) IS

Line 1341: insert into AMS_LIST_HEADERS_ALL (

1337: RAISE FND_API.G_EXC_ERROR;
1338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END IF;
1341: insert into AMS_LIST_HEADERS_ALL (
1342: LIST_HEADER_ID ,
1343: LAST_UPDATE_DATE ,
1344: LAST_UPDATED_BY ,
1345: CREATION_DATE ,

Line 1582: insert into AMS_LIST_HEADERS_ALL_TL (

1578: -- end ckapoor R12 enhancement for copy target group changes
1579:
1580: );
1581:
1582: insert into AMS_LIST_HEADERS_ALL_TL (
1583: LANGUAGE,
1584: SOURCE_LANG,
1585: LIST_NAME,
1586: DESCRIPTION,

Line 1608: from AMS_LIST_HEADERS_ALL_TL T

1604: from FND_LANGUAGES L
1605: where L.INSTALLED_FLAG in ('I', 'B')
1606: and not exists
1607: (select NULL
1608: from AMS_LIST_HEADERS_ALL_TL T
1609: where T.LIST_HEADER_ID = l_listheader_rec.LIST_HEADER_ID
1610: and T.LANGUAGE = L.LANGUAGE_CODE);
1611:
1612:

Line 1906: UPDATE ams_list_headers_all

1902: l_listheader_rec.no_of_rows_duplicates:=NULL;
1903: END IF;
1904:
1905:
1906: UPDATE ams_list_headers_all
1907: SET
1908: last_update_date = sysdate
1909: ,last_updated_by = FND_GLOBAL.User_Id
1910: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 2036: update AMS_LIST_HEADERS_ALL_TL set

2032: END IF;
2033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2034: END IF;
2035:
2036: update AMS_LIST_HEADERS_ALL_TL set
2037: LIST_NAME = l_listheader_rec.LIST_NAME,
2038: DESCRIPTION = l_listheader_rec.DESCRIPTION,
2039: LAST_UPDATE_DATE = sysdate,
2040: LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 2149: -- Ams_List_Headers_All.

2145: -- Deletes from The following tables Ams_List_Src_Type_Usages,
2146: -- Ams_List_Rule_Usages,
2147: -- Ams_List_Entries,
2148: -- Ams_List_Select_Actions
2149: -- Ams_List_Headers_All.
2150: --
2151: -- HISTORY
2152: -- 05/12/1999 tdonohoe created
2153: -- End of Comments

Line 2229: DELETE FROM ams_list_headers_all

2225:
2226: DELETE FROM ams_list_select_actions
2227: WHERE list_header_id = l_list_header_id;
2228:
2229: DELETE FROM ams_list_headers_all
2230: WHERE list_header_id = l_list_header_id;
2231:
2232:
2233: -- Standard check of p_commit.

Line 2334: FROM ams_list_headers_all

2330: l_list_header_id NUMBER;
2331:
2332: CURSOR c_list_header_id IS
2333: SELECT list_header_id
2334: FROM ams_list_headers_all
2335: WHERE list_header_id = p_listheader_id
2336: AND object_version_number = p_object_version
2337: FOR UPDATE OF list_header_id NOWAIT;
2338:

Line 3022: FROM ams_list_headers_all

3018:
3019:
3020: SELECT nvl(no_of_rows_min_requested,0)
3021: INTO l_min_rows
3022: FROM ams_list_headers_all
3023: WHERE list_header_id = p_list_header_id;
3024:
3025: if l_min_rows > l_no_of_rows_active then
3026: l_new_status := 'DRAFT';

Line 3032: update ams_list_headers_all

3028: else
3029: l_new_status := 'AVAILABLE';
3030: l_new_status_id := 303;
3031: end if;
3032: update ams_list_headers_all
3033: set no_of_rows_in_list = l_no_of_rows_in_list,
3034: no_of_rows_active = l_no_of_rows_active,
3035: no_of_rows_inactive = l_no_of_rows_inactive,
3036: no_of_rows_in_ctrl_group = l_no_of_rows_in_ctrl_group,

Line 3183: update ams_list_headers_all

3179: into l_no_of_rows_prev_contacted ;
3180: close c_count_list_entries;
3181:
3182:
3183: update ams_list_headers_all
3184: set no_of_rows_prev_contacted = l_no_of_rows_prev_contacted,
3185: last_update_date = sysdate
3186: WHERE list_header_id = l_list_header_id;
3187: