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

Line 132: cursor C is select ROWID from AMS_LIST_HEADERS_ALL

128: X_APPLY_SUPPRESSION_FLAG VARCHAR2 --rmbhanda bug#4609206
129:
130:
131: ) is
132: cursor C is select ROWID from AMS_LIST_HEADERS_ALL
133: where LIST_HEADER_ID = X_LIST_HEADER_ID
134: ;
135: begin
136: insert into AMS_LIST_HEADERS_ALL (

Line 136: insert into AMS_LIST_HEADERS_ALL (

132: cursor C is select ROWID from AMS_LIST_HEADERS_ALL
133: where LIST_HEADER_ID = X_LIST_HEADER_ID
134: ;
135: begin
136: insert into AMS_LIST_HEADERS_ALL (
137: PURPOSE_CODE,
138: NO_OF_ROWS_FATIGUED,
139: NO_OF_ROWS_SUPPRESSED,
140: QUERY_TEMPLATE_ID,

Line 387: insert into AMS_LIST_HEADERS_ALL_TL (

383: X_CTRL_GEN_MODE,
384: X_APPLY_SUPPRESSION_FLAG --rmbhanda bug#4609206
385: );
386:
387: insert into AMS_LIST_HEADERS_ALL_TL (
388: LIST_HEADER_ID,
389: LAST_UPDATE_DATE,
390: LAST_UPDATE_BY,
391: CREATION_DATE,

Line 413: from AMS_LIST_HEADERS_ALL_TL T

409: from FND_LANGUAGES L
410: where L.INSTALLED_FLAG in ('I', 'B')
411: and not exists
412: (select NULL
413: from AMS_LIST_HEADERS_ALL_TL T
414: where T.LIST_HEADER_ID = X_LIST_HEADER_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416:
417: open c;

Line 667: from AMS_LIST_HEADERS_ALL

663: APPLY_SUPPRESSION_FLAG --rmbhanda bug#4609206
664:
665:
666:
667: from AMS_LIST_HEADERS_ALL
668: where LIST_HEADER_ID = X_LIST_HEADER_ID
669: for update of LIST_HEADER_ID nowait;
670: recinfo c%rowtype;
671:

Line 675: from AMS_LIST_HEADERS_ALL_TL

671:
672: cursor c1 is select
673: LIST_NAME,
674: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
675: from AMS_LIST_HEADERS_ALL_TL
676: where LIST_HEADER_ID = X_LIST_HEADER_ID
677: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
678: for update of LIST_HEADER_ID nowait;
679: begin

Line 1028: update AMS_LIST_HEADERS_ALL set

1024:
1025:
1026: ) is
1027: begin
1028: update AMS_LIST_HEADERS_ALL set
1029: PURPOSE_CODE = X_PURPOSE_CODE,
1030: NO_OF_ROWS_FATIGUED = X_NO_OF_ROWS_FATIGUED,
1031: NO_OF_ROWS_SUPPRESSED = X_NO_OF_ROWS_SUPPRESSED,
1032: QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,

Line 1157: update AMS_LIST_HEADERS_ALL_TL set

1153: if (sql%notfound) then
1154: raise no_data_found;
1155: end if;
1156:
1157: update AMS_LIST_HEADERS_ALL_TL set
1158: LIST_NAME = X_LIST_NAME,
1159: DESCRIPTION = X_DESCRIPTION,
1160: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1161: LAST_UPDATE_BY = X_LAST_UPDATED_BY,

Line 1176: delete from AMS_LIST_HEADERS_ALL_TL

1172: procedure DELETE_ROW (
1173: X_LIST_HEADER_ID in NUMBER
1174: ) is
1175: begin
1176: delete from AMS_LIST_HEADERS_ALL_TL
1177: where LIST_HEADER_ID = X_LIST_HEADER_ID;
1178:
1179: if (sql%notfound) then
1180: raise no_data_found;

Line 1183: delete from AMS_LIST_HEADERS_ALL

1179: if (sql%notfound) then
1180: raise no_data_found;
1181: end if;
1182:
1183: delete from AMS_LIST_HEADERS_ALL
1184: where LIST_HEADER_ID = X_LIST_HEADER_ID;
1185:
1186: if (sql%notfound) then
1187: raise no_data_found;

Line 1194: delete from AMS_LIST_HEADERS_ALL_TL T

1190:
1191: procedure ADD_LANGUAGE
1192: is
1193: begin
1194: delete from AMS_LIST_HEADERS_ALL_TL T
1195: where not exists
1196: (select NULL
1197: from AMS_LIST_HEADERS_ALL B
1198: where B.LIST_HEADER_ID = T.LIST_HEADER_ID

Line 1197: from AMS_LIST_HEADERS_ALL B

1193: begin
1194: delete from AMS_LIST_HEADERS_ALL_TL T
1195: where not exists
1196: (select NULL
1197: from AMS_LIST_HEADERS_ALL B
1198: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
1199: );
1200:
1201: update AMS_LIST_HEADERS_ALL_TL T set (

Line 1201: update AMS_LIST_HEADERS_ALL_TL T set (

1197: from AMS_LIST_HEADERS_ALL B
1198: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
1199: );
1200:
1201: update AMS_LIST_HEADERS_ALL_TL T set (
1202: LIST_NAME
1203: ) = (select
1204: B.LIST_NAME
1205: from AMS_LIST_HEADERS_ALL_TL B

Line 1205: from AMS_LIST_HEADERS_ALL_TL B

1201: update AMS_LIST_HEADERS_ALL_TL T set (
1202: LIST_NAME
1203: ) = (select
1204: B.LIST_NAME
1205: from AMS_LIST_HEADERS_ALL_TL B
1206: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
1207: and B.LANGUAGE = T.SOURCE_LANG)
1208: where (
1209: T.LIST_HEADER_ID,

Line 1214: from AMS_LIST_HEADERS_ALL_TL SUBB, AMS_LIST_HEADERS_ALL_TL SUBT

1210: T.LANGUAGE
1211: ) in (select
1212: SUBT.LIST_HEADER_ID,
1213: SUBT.LANGUAGE
1214: from AMS_LIST_HEADERS_ALL_TL SUBB, AMS_LIST_HEADERS_ALL_TL SUBT
1215: where SUBB.LIST_HEADER_ID = SUBT.LIST_HEADER_ID
1216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1217: and (SUBB.LIST_NAME <> SUBT.LIST_NAME
1218: ));

Line 1220: insert into AMS_LIST_HEADERS_ALL_TL (

1216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1217: and (SUBB.LIST_NAME <> SUBT.LIST_NAME
1218: ));
1219:
1220: insert into AMS_LIST_HEADERS_ALL_TL (
1221: LIST_HEADER_ID,
1222: LAST_UPDATE_DATE,
1223: LAST_UPDATE_BY,
1224: CREATION_DATE,

Line 1242: from AMS_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L

1238: B.LIST_NAME,
1239: B.DESCRIPTION,
1240: L.LANGUAGE_CODE,
1241: B.SOURCE_LANG
1242: from AMS_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L
1243: where L.INSTALLED_FLAG in ('I', 'B')
1244: and B.LANGUAGE = userenv('LANG')
1245: and not exists
1246: (select NULL

Line 1247: from AMS_LIST_HEADERS_ALL_TL T

1243: where L.INSTALLED_FLAG in ('I', 'B')
1244: and B.LANGUAGE = userenv('LANG')
1245: and not exists
1246: (select NULL
1247: from AMS_LIST_HEADERS_ALL_TL T
1248: where T.LIST_HEADER_ID = B.LIST_HEADER_ID
1249: and T.LANGUAGE = L.LANGUAGE_CODE);
1250: end ADD_LANGUAGE;
1251: