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_LIST_HEADERS_ALL_PKG dependencies on AMS_LIST_HEADERS_ALL

Line 1: package body AMS_LIST_HEADERS_ALL_PKG as

1: package body AMS_LIST_HEADERS_ALL_PKG as
2: /* $Header: amstlshb.pls 120.1 2006/06/26 12:19:58 bmuthukr noship $ */
3: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
4: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
5: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

Line 107: cursor C is select ROWID from AMS_LIST_HEADERS_ALL

103: X_LAST_UPDATE_LOGIN in NUMBER,
104: X_NO_OF_ROWS_PREV_CONTACTED in NUMBER,
105: X_APPLY_TRAFFIC_COP in VARCHAR2
106: ) is
107: cursor C is select ROWID from AMS_LIST_HEADERS_ALL
108: where LIST_HEADER_ID = X_LIST_HEADER_ID
109: ;
110: begin
111: insert into AMS_LIST_HEADERS_ALL (

Line 111: insert into AMS_LIST_HEADERS_ALL (

107: cursor C is select ROWID from AMS_LIST_HEADERS_ALL
108: where LIST_HEADER_ID = X_LIST_HEADER_ID
109: ;
110: begin
111: insert into AMS_LIST_HEADERS_ALL (
112: COUNTRY,
113: USER_STATUS_ID,
114: QUANTUM,
115: RELEASE_CONTROL_ALG_ID,

Line 305: insert into AMS_LIST_HEADERS_ALL_TL (

301: X_NO_OF_ROWS_PREV_CONTACTED,
302: X_APPLY_TRAFFIC_COP
303: );
304:
305: insert into AMS_LIST_HEADERS_ALL_TL (
306: LIST_NAME,
307: DESCRIPTION,
308: LAST_UPDATE_LOGIN,
309: LIST_HEADER_ID,

Line 331: from AMS_LIST_HEADERS_ALL_TL T

327: from FND_LANGUAGES L
328: where L.INSTALLED_FLAG in ('I', 'B')
329: and not exists
330: (select NULL
331: from AMS_LIST_HEADERS_ALL_TL T
332: where T.LIST_HEADER_ID = X_LIST_HEADER_ID
333: and T.LANGUAGE = L.LANGUAGE_CODE);
334:
335: open c;

Line 529: from AMS_LIST_HEADERS_ALL

525: REPEAT_EXCLUDE_TYPE,
526: ROW_SELECTION_TYPE,
527: NO_OF_ROWS_PREV_CONTACTED ,
528: APPLY_TRAFFIC_COP
529: from AMS_LIST_HEADERS_ALL
530: where LIST_HEADER_ID = X_LIST_HEADER_ID
531: for update of LIST_HEADER_ID nowait;
532: recinfo c%rowtype;
533:

Line 538: from AMS_LIST_HEADERS_ALL_TL

534: cursor c1 is select
535: LIST_NAME,
536: DESCRIPTION,
537: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
538: from AMS_LIST_HEADERS_ALL_TL
539: where LIST_HEADER_ID = X_LIST_HEADER_ID
540: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
541: for update of LIST_HEADER_ID nowait;
542: begin

Line 836: update AMS_LIST_HEADERS_ALL set

832: X_NO_OF_ROWS_PREV_CONTACTED in NUMBER,
833: X_APPLY_TRAFFIC_COP in VARCHAR2
834: ) is
835: begin
836: update AMS_LIST_HEADERS_ALL set
837: COUNTRY = X_COUNTRY,
838: USER_STATUS_ID = X_USER_STATUS_ID,
839: QUANTUM = X_QUANTUM,
840: RELEASE_CONTROL_ALG_ID = X_RELEASE_CONTROL_ALG_ID,

Line 935: update AMS_LIST_HEADERS_ALL_TL set

931: if (sql%notfound) then
932: raise no_data_found;
933: end if;
934:
935: update AMS_LIST_HEADERS_ALL_TL set
936: LIST_NAME = X_LIST_NAME,
937: DESCRIPTION = X_DESCRIPTION,
938: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
939: LAST_UPDATE_BY = X_LAST_UPDATED_BY,

Line 954: delete from AMS_LIST_HEADERS_ALL_TL

950: procedure DELETE_ROW (
951: X_LIST_HEADER_ID in NUMBER
952: ) is
953: begin
954: delete from AMS_LIST_HEADERS_ALL_TL
955: where LIST_HEADER_ID = X_LIST_HEADER_ID;
956:
957: if (sql%notfound) then
958: raise no_data_found;

Line 961: delete from AMS_LIST_HEADERS_ALL

957: if (sql%notfound) then
958: raise no_data_found;
959: end if;
960:
961: delete from AMS_LIST_HEADERS_ALL
962: where LIST_HEADER_ID = X_LIST_HEADER_ID;
963:
964: if (sql%notfound) then
965: raise no_data_found;

Line 972: delete from AMS_LIST_HEADERS_ALL_TL T

968:
969: procedure ADD_LANGUAGE
970: is
971: begin
972: delete from AMS_LIST_HEADERS_ALL_TL T
973: where not exists
974: (select NULL
975: from AMS_LIST_HEADERS_ALL B
976: where B.LIST_HEADER_ID = T.LIST_HEADER_ID

Line 975: from AMS_LIST_HEADERS_ALL B

971: begin
972: delete from AMS_LIST_HEADERS_ALL_TL T
973: where not exists
974: (select NULL
975: from AMS_LIST_HEADERS_ALL B
976: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
977: );
978:
979: update AMS_LIST_HEADERS_ALL_TL T set (

Line 979: update AMS_LIST_HEADERS_ALL_TL T set (

975: from AMS_LIST_HEADERS_ALL B
976: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
977: );
978:
979: update AMS_LIST_HEADERS_ALL_TL T set (
980: LIST_NAME,
981: DESCRIPTION
982: ) = (select
983: B.LIST_NAME,

Line 985: from AMS_LIST_HEADERS_ALL_TL B

981: DESCRIPTION
982: ) = (select
983: B.LIST_NAME,
984: B.DESCRIPTION
985: from AMS_LIST_HEADERS_ALL_TL B
986: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
987: and B.LANGUAGE = T.SOURCE_LANG)
988: where (
989: T.LIST_HEADER_ID,

Line 994: from AMS_LIST_HEADERS_ALL_TL SUBB, AMS_LIST_HEADERS_ALL_TL SUBT

990: T.LANGUAGE
991: ) in (select
992: SUBT.LIST_HEADER_ID,
993: SUBT.LANGUAGE
994: from AMS_LIST_HEADERS_ALL_TL SUBB, AMS_LIST_HEADERS_ALL_TL SUBT
995: where SUBB.LIST_HEADER_ID = SUBT.LIST_HEADER_ID
996: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
997: and (SUBB.LIST_NAME <> SUBT.LIST_NAME
998: or (SUBB.LIST_NAME is null and SUBT.LIST_NAME is not null)

Line 1005: insert into AMS_LIST_HEADERS_ALL_TL (

1001: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
1002: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
1003: ));
1004:
1005: insert into AMS_LIST_HEADERS_ALL_TL (
1006: LIST_NAME,
1007: DESCRIPTION,
1008: LAST_UPDATE_LOGIN,
1009: LIST_HEADER_ID,

Line 1027: from AMS_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L

1023: B.CREATION_DATE,
1024: B.CREATED_BY,
1025: L.LANGUAGE_CODE,
1026: B.SOURCE_LANG
1027: from AMS_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L
1028: where L.INSTALLED_FLAG in ('I', 'B')
1029: and B.LANGUAGE = userenv('LANG')
1030: and not exists
1031: (select NULL

Line 1032: from AMS_LIST_HEADERS_ALL_TL T

1028: where L.INSTALLED_FLAG in ('I', 'B')
1029: and B.LANGUAGE = userenv('LANG')
1030: and not exists
1031: (select NULL
1032: from AMS_LIST_HEADERS_ALL_TL T
1033: where T.LIST_HEADER_ID = B.LIST_HEADER_ID
1034: and T.LANGUAGE = L.LANGUAGE_CODE);
1035: end ADD_LANGUAGE;
1036:

Line 1147: from ams_list_headers_all

1143: l_row_id varchar2(100);
1144:
1145: cursor c_chk_col_exists is
1146: select 'x'
1147: from ams_list_headers_all
1148: where list_header_id = p_list_header_id;
1149:
1150: CURSOR c_obj_verno IS
1151: SELECT object_version_number, last_updated_by

Line 1152: FROM ams_list_headers_all

1148: where list_header_id = p_list_header_id;
1149:
1150: CURSOR c_obj_verno IS
1151: SELECT object_version_number, last_updated_by
1152: FROM ams_list_headers_all
1153: where list_header_id = p_list_header_id;
1154:
1155:
1156: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;

Line 1186: AMS_LIST_HEADERS_ALL_PKG.INSERT_ROW(

1182: open c_chk_col_exists;
1183: fetch c_chk_col_exists into l_dummy_char;
1184: if c_chk_col_exists%notfound then
1185: close c_chk_col_exists;
1186: AMS_LIST_HEADERS_ALL_PKG.INSERT_ROW(
1187: X_ROWID => l_row_id ,
1188: X_LIST_HEADER_ID => P_LIST_HEADER_ID ,
1189: X_COUNTRY => P_COUNTRY ,
1190: X_USER_STATUS_ID => P_USER_STATUS_ID ,

Line 1298: AMS_LIST_HEADERS_ALL_PKG.UPDATE_ROW (

1294: if (l_last_updated_by in (1,2,0) OR
1295: NVL(p_custom_mode,'PRESERVE')='FORCE') THEN
1296:
1297:
1298: AMS_LIST_HEADERS_ALL_PKG.UPDATE_ROW (
1299: X_LIST_HEADER_ID => P_LIST_HEADER_ID ,
1300: X_COUNTRY => P_COUNTRY ,
1301: X_USER_STATUS_ID => P_USER_STATUS_ID ,
1302: X_QUANTUM => P_QUANTUM ,

Line 1409: from ams_list_headers_all_tl

1405: ) is
1406:
1407: cursor c_last_update_by is
1408: select last_update_by
1409: from ams_list_headers_all_tl
1410: where list_header_id = x_list_header_id
1411: and userenv('LANG') = language;
1412:
1413: l_last_update_by number;

Line 1421: update ams_list_headers_all_tl

1417: fetch c_last_update_by into l_last_update_by;
1418: close c_last_update_by;
1419:
1420: if (l_last_update_by in (1,2,0) OR nvl(x_custom_mode,'PRESERVE')='FORCE') THEN
1421: update ams_list_headers_all_tl
1422: set list_name = nvl(x_list_name, list_name),
1423: description = nvl(x_description,description),
1424: source_lang = userenv('LANG'),
1425: last_update_date = sysdate,

Line 1434: end AMS_LIST_HEADERS_ALL_PKG;

1430: end if;
1431:
1432: end TRANSLATE_ROW;
1433:
1434: end AMS_LIST_HEADERS_ALL_PKG;