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.AMW_OPINION_COMPONTS_PKG dependencies on AMW_OPINION_COMPONTS_TL

Line 45: insert into AMW_OPINION_COMPONTS_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into AMW_OPINION_COMPONTS_TL (
46: OPINION_COMPONENT_ID,
47: OPINION_COMPONENT_NAME,
48: CREATED_BY,
49: CREATION_DATE,

Line 73: from AMW_OPINION_COMPONTS_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from AMW_OPINION_COMPONTS_TL T
74: where T.OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76: end INSERT_ROW;
77:

Line 101: from AMW_OPINION_COMPONTS_TL

97:
98: cursor c1 is select
99: OPINION_COMPONENT_NAME,
100: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
101: from AMW_OPINION_COMPONTS_TL
102: where OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID
103: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
104: for update of OPINION_COMPONENT_ID nowait;
105: begin

Line 171: update AMW_OPINION_COMPONTS_TL set

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: update AMW_OPINION_COMPONTS_TL set
172: OPINION_COMPONENT_NAME = X_OPINION_COMPONENT_NAME,
173: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
174: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
175: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 189: delete from AMW_OPINION_COMPONTS_TL

185: procedure DELETE_ROW (
186: X_OPINION_COMPONENT_ID in NUMBER
187: ) is
188: begin
189: delete from AMW_OPINION_COMPONTS_TL
190: where OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 207: delete from AMW_OPINION_COMPONTS_TL T

203:
204: procedure ADD_LANGUAGE
205: is
206: begin
207: delete from AMW_OPINION_COMPONTS_TL T
208: where not exists
209: (select NULL
210: from AMW_OPINION_COMPONTS_B B
211: where B.OPINION_COMPONENT_ID = T.OPINION_COMPONENT_ID

Line 214: update AMW_OPINION_COMPONTS_TL T set (

210: from AMW_OPINION_COMPONTS_B B
211: where B.OPINION_COMPONENT_ID = T.OPINION_COMPONENT_ID
212: );
213:
214: update AMW_OPINION_COMPONTS_TL T set (
215: OPINION_COMPONENT_NAME
216: ) = (select
217: B.OPINION_COMPONENT_NAME
218: from AMW_OPINION_COMPONTS_TL B

Line 218: from AMW_OPINION_COMPONTS_TL B

214: update AMW_OPINION_COMPONTS_TL T set (
215: OPINION_COMPONENT_NAME
216: ) = (select
217: B.OPINION_COMPONENT_NAME
218: from AMW_OPINION_COMPONTS_TL B
219: where B.OPINION_COMPONENT_ID = T.OPINION_COMPONENT_ID
220: and B.LANGUAGE = T.SOURCE_LANG)
221: where (
222: T.OPINION_COMPONENT_ID,

Line 227: from AMW_OPINION_COMPONTS_TL SUBB, AMW_OPINION_COMPONTS_TL SUBT

223: T.LANGUAGE
224: ) in (select
225: SUBT.OPINION_COMPONENT_ID,
226: SUBT.LANGUAGE
227: from AMW_OPINION_COMPONTS_TL SUBB, AMW_OPINION_COMPONTS_TL SUBT
228: where SUBB.OPINION_COMPONENT_ID = SUBT.OPINION_COMPONENT_ID
229: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
230: and (SUBB.OPINION_COMPONENT_NAME <> SUBT.OPINION_COMPONENT_NAME
231: or (SUBB.OPINION_COMPONENT_NAME is null and SUBT.OPINION_COMPONENT_NAME is not null)

Line 235: insert into AMW_OPINION_COMPONTS_TL (

231: or (SUBB.OPINION_COMPONENT_NAME is null and SUBT.OPINION_COMPONENT_NAME is not null)
232: or (SUBB.OPINION_COMPONENT_NAME is not null and SUBT.OPINION_COMPONENT_NAME is null)
233: ));
234:
235: insert into AMW_OPINION_COMPONTS_TL (
236: OPINION_COMPONENT_ID,
237: OPINION_COMPONENT_NAME,
238: CREATED_BY,
239: CREATION_DATE,

Line 259: from AMW_OPINION_COMPONTS_TL B, FND_LANGUAGES L

255: B.SECURITY_GROUP_ID,
256: B.OBJECT_VERSION_NUMBER,
257: L.LANGUAGE_CODE,
258: B.SOURCE_LANG
259: from AMW_OPINION_COMPONTS_TL B, FND_LANGUAGES L
260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL

Line 264: from AMW_OPINION_COMPONTS_TL T

260: where L.INSTALLED_FLAG in ('I', 'B')
261: and B.LANGUAGE = userenv('LANG')
262: and not exists
263: (select NULL
264: from AMW_OPINION_COMPONTS_TL T
265: where T.OPINION_COMPONENT_ID = B.OPINION_COMPONENT_ID
266: and T.LANGUAGE = L.LANGUAGE_CODE);
267: end ADD_LANGUAGE;
268:

Line 344: from AMW_OPINION_COMPONTS_TL

340: -- Translate char last_update_date to date
341: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
342:
343: select last_updated_by, last_update_date into db_luby, db_ludate
344: from AMW_OPINION_COMPONTS_TL
345: where opinion_component_id = X_OPINION_COMPONENT_ID and language = userenv('LANG');
346:
347: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
348: then update AMW_OPINION_COMPONTS_TL set

Line 348: then update AMW_OPINION_COMPONTS_TL set

344: from AMW_OPINION_COMPONTS_TL
345: where opinion_component_id = X_OPINION_COMPONENT_ID and language = userenv('LANG');
346:
347: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
348: then update AMW_OPINION_COMPONTS_TL set
349: opinion_component_name = nvl(X_OPINION_COMPONENT_NAME, opinion_component_name),
350: source_lang = userenv('LANG'),
351: last_update_date = f_ludate,
352: last_updated_by = f_luby,