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 1212: SELECT ams_list_headers_all_s.NEXTVAL

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

Line 1217: FROM ams_list_headers_all

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

Line 1351: insert into AMS_LIST_HEADERS_ALL (

1347: IF (AMS_DEBUG_HIGH_ON) THEN
1348: Ams_Utility_Pvt.Debug_Message(L_FULL_NAME||': The org id is ' || l_org_id);
1349: END IF;
1350:
1351: insert into AMS_LIST_HEADERS_ALL (
1352: LIST_HEADER_ID ,
1353: LAST_UPDATE_DATE ,
1354: LAST_UPDATED_BY ,
1355: CREATION_DATE ,

Line 1595: insert into AMS_LIST_HEADERS_ALL_TL (

1591: -- end ckapoor R12 enhancement for copy target group changes
1592:
1593: );
1594:
1595: insert into AMS_LIST_HEADERS_ALL_TL (
1596: LANGUAGE,
1597: SOURCE_LANG,
1598: LIST_NAME,
1599: DESCRIPTION,

Line 1621: from AMS_LIST_HEADERS_ALL_TL T

1617: from FND_LANGUAGES L
1618: where L.INSTALLED_FLAG in ('I', 'B')
1619: and not exists
1620: (select NULL
1621: from AMS_LIST_HEADERS_ALL_TL T
1622: where T.LIST_HEADER_ID = l_listheader_rec.LIST_HEADER_ID
1623: and T.LANGUAGE = L.LANGUAGE_CODE);
1624:
1625:

Line 1919: UPDATE ams_list_headers_all

1915: l_listheader_rec.no_of_rows_duplicates:=NULL;
1916: END IF;
1917:
1918:
1919: UPDATE ams_list_headers_all
1920: SET
1921: last_update_date = sysdate
1922: ,last_updated_by = FND_GLOBAL.User_Id
1923: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 2049: update AMS_LIST_HEADERS_ALL_TL set

2045: END IF;
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048:
2049: update AMS_LIST_HEADERS_ALL_TL set
2050: LIST_NAME = l_listheader_rec.LIST_NAME,
2051: DESCRIPTION = l_listheader_rec.DESCRIPTION,
2052: LAST_UPDATE_DATE = sysdate,
2053: LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 2162: -- Ams_List_Headers_All.

2158: -- Deletes from The following tables Ams_List_Src_Type_Usages,
2159: -- Ams_List_Rule_Usages,
2160: -- Ams_List_Entries,
2161: -- Ams_List_Select_Actions
2162: -- Ams_List_Headers_All.
2163: --
2164: -- HISTORY
2165: -- 05/12/1999 tdonohoe created
2166: -- End of Comments

Line 2242: DELETE FROM ams_list_headers_all

2238:
2239: DELETE FROM ams_list_select_actions
2240: WHERE list_header_id = l_list_header_id;
2241:
2242: DELETE FROM ams_list_headers_all
2243: WHERE list_header_id = l_list_header_id;
2244:
2245:
2246: -- Standard check of p_commit.

Line 2347: FROM ams_list_headers_all

2343: l_list_header_id NUMBER;
2344:
2345: CURSOR c_list_header_id IS
2346: SELECT list_header_id
2347: FROM ams_list_headers_all
2348: WHERE list_header_id = p_listheader_id
2349: AND object_version_number = p_object_version
2350: FOR UPDATE OF list_header_id NOWAIT;
2351:

Line 3035: FROM ams_list_headers_all

3031:
3032:
3033: SELECT nvl(no_of_rows_min_requested,0)
3034: INTO l_min_rows
3035: FROM ams_list_headers_all
3036: WHERE list_header_id = p_list_header_id;
3037:
3038: if l_min_rows > l_no_of_rows_active then
3039: l_new_status := 'DRAFT';

Line 3045: update ams_list_headers_all

3041: else
3042: l_new_status := 'AVAILABLE';
3043: l_new_status_id := 303;
3044: end if;
3045: update ams_list_headers_all
3046: set no_of_rows_in_list = l_no_of_rows_in_list,
3047: no_of_rows_active = l_no_of_rows_active,
3048: no_of_rows_inactive = l_no_of_rows_inactive,
3049: no_of_rows_in_ctrl_group = l_no_of_rows_in_ctrl_group,

Line 3196: update ams_list_headers_all

3192: into l_no_of_rows_prev_contacted ;
3193: close c_count_list_entries;
3194:
3195:
3196: update ams_list_headers_all
3197: set no_of_rows_prev_contacted = l_no_of_rows_prev_contacted,
3198: last_update_date = sysdate
3199: WHERE list_header_id = l_list_header_id;
3200: