APPS.AMS_LIST_HEADERS_ALL_PKG dependencies on AMS_LIST_HEADERS_ALL_TL

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 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 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 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 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 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,