APPS.PER_RVR_SHD dependencies on PER_RI_VIEW_REPORTS_TL

Line 188: delete from PER_RI_VIEW_REPORTS_TL T

184: -- ----------------------------------------------------------------------------
185: PROCEDURE add_language IS
186: Begin
187: --
188: delete from PER_RI_VIEW_REPORTS_TL T
189: where not exists
190: (select NULL
191: from PER_RI_VIEW_REPORTS B
192: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE

Line 195: update PER_RI_VIEW_REPORTS_TL T set (

191: from PER_RI_VIEW_REPORTS B
192: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE
193: );
194:
195: update PER_RI_VIEW_REPORTS_TL T set (
196: WORKBENCH_VIEW_REPORT_NAME,
197: WB_VIEW_REPORT_DESCRIPTION
198: ) = (select
199: B.WORKBENCH_VIEW_REPORT_NAME,

Line 201: from PER_RI_VIEW_REPORTS_TL B

197: WB_VIEW_REPORT_DESCRIPTION
198: ) = (select
199: B.WORKBENCH_VIEW_REPORT_NAME,
200: B.WB_VIEW_REPORT_DESCRIPTION
201: from PER_RI_VIEW_REPORTS_TL B
202: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE
203: and B.LANGUAGE = T.SOURCE_LANG)
204: where (
205: T.WORKBENCH_VIEW_REPORT_CODE,

Line 210: from PER_RI_VIEW_REPORTS_TL SUBB, PER_RI_VIEW_REPORTS_TL SUBT

206: T.LANGUAGE
207: ) in (select
208: SUBT.WORKBENCH_VIEW_REPORT_CODE,
209: SUBT.LANGUAGE
210: from PER_RI_VIEW_REPORTS_TL SUBB, PER_RI_VIEW_REPORTS_TL SUBT
211: where SUBB.WORKBENCH_VIEW_REPORT_CODE = SUBT.WORKBENCH_VIEW_REPORT_CODE
212: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
213: and (SUBB.WORKBENCH_VIEW_REPORT_NAME <> SUBT.WORKBENCH_VIEW_REPORT_NAME
214: or SUBB.WB_VIEW_REPORT_DESCRIPTION <> SUBT.WB_VIEW_REPORT_DESCRIPTION

Line 217: insert into PER_RI_VIEW_REPORTS_TL (

213: and (SUBB.WORKBENCH_VIEW_REPORT_NAME <> SUBT.WORKBENCH_VIEW_REPORT_NAME
214: or SUBB.WB_VIEW_REPORT_DESCRIPTION <> SUBT.WB_VIEW_REPORT_DESCRIPTION
215: ));
216:
217: insert into PER_RI_VIEW_REPORTS_TL (
218: WORKBENCH_VIEW_REPORT_CODE,
219: WORKBENCH_VIEW_REPORT_NAME,
220: WB_VIEW_REPORT_DESCRIPTION,
221: LAST_UPDATE_DATE,

Line 239: from PER_RI_VIEW_REPORTS_TL B, FND_LANGUAGES L

235: B.CREATED_BY,
236: B.CREATION_DATE,
237: L.LANGUAGE_CODE,
238: B.SOURCE_LANG
239: from PER_RI_VIEW_REPORTS_TL B, FND_LANGUAGES L
240: where L.INSTALLED_FLAG in ('I', 'B')
241: and B.LANGUAGE = userenv('LANG')
242: and not exists
243: (select NULL

Line 244: from PER_RI_VIEW_REPORTS_TL T

240: where L.INSTALLED_FLAG in ('I', 'B')
241: and B.LANGUAGE = userenv('LANG')
242: and not exists
243: (select NULL
244: from PER_RI_VIEW_REPORTS_TL T
245: where T.WORKBENCH_VIEW_REPORT_CODE = B.WORKBENCH_VIEW_REPORT_CODE
246: and T.LANGUAGE = L.LANGUAGE_CODE);
247: End add_language;
248: --