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.PO_DOC_STYLE_LINES_PKG dependencies on PO_DOC_STYLE_LINES_TL

Line 30: from PO_DOC_STYLE_LINES_TL

26: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'DD/MM/YYYY'), sysdate);
27:
28: select DECODE(LAST_UPDATED_BY, -1, 1, LAST_UPDATED_BY), LAST_UPDATE_DATE
29: into db_luby, db_ludate
30: from PO_DOC_STYLE_LINES_TL
31: where style_id = X_STYLE_ID
32: and document_subtype = X_DOCUMENT_SUBTYPE
33: and language = userenv('LANG') ;
34:

Line 39: update po_doc_style_lines_tl

35: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
36: db_ludate, X_CUSTOM_MODE)) then
37:
38:
39: update po_doc_style_lines_tl
40: set source_lang = userenv('LANG')
41: ,display_name = X_DISPLAY_NAME
42: ,last_updated_by = f_luby
43: ,last_update_login = 0

Line 82: update po_doc_style_lines_tl

78: if (sql%notfound) then
79: raise no_data_found;
80: end if;
81:
82: update po_doc_style_lines_tl
83: set source_lang = userenv('LANG')
84: ,display_name = X_DISPLAY_NAME
85: ,last_updated_by = X_LAST_UPDATED_BY
86: ,last_update_login = X_LAST_UPDATE_LOGIN

Line 128: insert into po_doc_style_lines_tl (

124: ,X_LAST_UPDATE_LOGIN
125: ,X_LAST_UPDATE_DATE);
126:
127:
128: insert into po_doc_style_lines_tl (
129: style_id
130: ,document_subtype
131: ,language
132: ,source_lang

Line 154: from po_doc_style_lines_tl t

150: from fnd_languages l
151: where l.installed_flag in ('I', 'B')
152: and not exists
153: (select null
154: from po_doc_style_lines_tl t
155: where t.language = l.language_code
156: and t.style_id = X_STYLE_ID
157: and t.document_subtype =X_DOCUMENT_SUBTYPE);
158:

Line 186: from po_doc_style_lines_tl

182: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'DD/MM/YYYY'), sysdate);
183:
184: select LAST_UPDATED_BY, LAST_UPDATE_DATE
185: into db_luby, db_ludate
186: from po_doc_style_lines_tl
187: where style_id = X_STYLE_ID
188: and document_subtype =X_DOCUMENT_SUBTYPE
189: and language = userenv('LANG') ;
190:

Line 223: delete from po_doc_style_lines_tl T

219: IS
220:
221: begin
222:
223: delete from po_doc_style_lines_tl T
224: where not exists
225: (select NULL
226: from po_doc_style_lines_b B
227: where B.STYLE_ID = T.STYLE_ID

Line 230: update po_doc_style_lines_tl T

226: from po_doc_style_lines_b B
227: where B.STYLE_ID = T.STYLE_ID
228: and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE);
229:
230: update po_doc_style_lines_tl T
231: set (
232: DISPLAY_NAME
233: ) = (select
234: DISPLAY_NAME

Line 235: from po_doc_style_lines_tl B

231: set (
232: DISPLAY_NAME
233: ) = (select
234: DISPLAY_NAME
235: from po_doc_style_lines_tl B
236: where B.STYLE_ID = T.STYLE_ID
237: and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (

Line 245: from po_doc_style_lines_tl SUBB,

241: T.LANGUAGE
242: ) in (select
243: SUBT.STYLE_ID,
244: SUBT.LANGUAGE
245: from po_doc_style_lines_tl SUBB,
246: po_doc_style_lines_tl SUBT
247: where SUBB.STYLE_ID = SUBT.STYLE_ID
248: and SUBB.DOCUMENT_SUBTYPE = SUBT.DOCUMENT_SUBTYPE
249: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 246: po_doc_style_lines_tl SUBT

242: ) in (select
243: SUBT.STYLE_ID,
244: SUBT.LANGUAGE
245: from po_doc_style_lines_tl SUBB,
246: po_doc_style_lines_tl SUBT
247: where SUBB.STYLE_ID = SUBT.STYLE_ID
248: and SUBB.DOCUMENT_SUBTYPE = SUBT.DOCUMENT_SUBTYPE
249: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
250: and SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 254: insert into po_doc_style_lines_tl (

250: and SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
251: );
252: --Bug5237451: Last_update_date was not updated properly
253:
254: insert into po_doc_style_lines_tl (
255: style_id
256: ,document_subtype
257: ,language
258: ,source_lang

Line 275: from fnd_languages l, po_doc_style_lines_tl B

271: ,B.LAST_UPDATE_DATE
272: ,B.CREATION_DATE --Bug5237451
273: ,B.CREATED_BY
274: ,B.LAST_UPDATED_BY
275: from fnd_languages l, po_doc_style_lines_tl B
276: where l.installed_flag in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select null

Line 280: from po_doc_style_lines_tl t

276: where l.installed_flag in ('I', 'B')
277: and B.LANGUAGE = userenv('LANG')
278: and not exists
279: (select null
280: from po_doc_style_lines_tl t
281: where t.language = l.language_code
282: and t.style_id = B.STYLE_ID
283: and t.document_subtype =B.DOCUMENT_SUBTYPE);
284: