APPS.PER_RVT_SHD dependencies on PER_RI_VIEW_REPORTS

Line 43: from per_ri_view_reports_tl

39: ,language
40: ,workbench_view_report_name
41: ,wb_view_report_description
42: ,source_lang
43: from per_ri_view_reports_tl
44: where workbench_view_report_code = p_workbench_view_report_code
45: and language = p_language;
46: --
47: l_fct_ret boolean;

Line 110: from per_ri_view_reports_tl

106: ,language
107: ,workbench_view_report_name
108: ,wb_view_report_description
109: ,source_lang
110: from per_ri_view_reports_tl
111: where workbench_view_report_code = p_workbench_view_report_code
112: and language = p_language
113: for update nowait;
114: --

Line 156: fnd_message.set_token('TABLE_NAME', 'per_ri_view_reports_tl');

152: -- The object is locked therefore we need to supply a meaningful
153: -- error message.
154: --
155: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
156: fnd_message.set_token('TABLE_NAME', 'per_ri_view_reports_tl');
157: fnd_message.raise_error;
158: End lck;
159: --
160: -- ----------------------------------------------------------------------------

Line 173: delete from PER_RI_VIEW_REPORTS_TL T

169: -- ----------------------------------------------------------------------------
170: PROCEDURE add_language IS
171: Begin
172: --
173: delete from PER_RI_VIEW_REPORTS_TL T
174: where not exists
175: (select NULL
176: from PER_RI_VIEW_REPORTS B
177: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE

Line 176: from PER_RI_VIEW_REPORTS B

172: --
173: delete from PER_RI_VIEW_REPORTS_TL T
174: where not exists
175: (select NULL
176: from PER_RI_VIEW_REPORTS B
177: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE
178: );
179:
180: update PER_RI_VIEW_REPORTS_TL T set (

Line 180: update PER_RI_VIEW_REPORTS_TL T set (

176: from PER_RI_VIEW_REPORTS B
177: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE
178: );
179:
180: update PER_RI_VIEW_REPORTS_TL T set (
181: WORKBENCH_VIEW_REPORT_NAME,
182: WB_VIEW_REPORT_DESCRIPTION
183: ) = (select
184: B.WORKBENCH_VIEW_REPORT_NAME,

Line 186: from PER_RI_VIEW_REPORTS_TL B

182: WB_VIEW_REPORT_DESCRIPTION
183: ) = (select
184: B.WORKBENCH_VIEW_REPORT_NAME,
185: B.WB_VIEW_REPORT_DESCRIPTION
186: from PER_RI_VIEW_REPORTS_TL B
187: where B.WORKBENCH_VIEW_REPORT_CODE = T.WORKBENCH_VIEW_REPORT_CODE
188: and B.LANGUAGE = T.SOURCE_LANG)
189: where (
190: T.WORKBENCH_VIEW_REPORT_CODE,

Line 195: from PER_RI_VIEW_REPORTS_TL SUBB, PER_RI_VIEW_REPORTS_TL SUBT

191: T.LANGUAGE
192: ) in (select
193: SUBT.WORKBENCH_VIEW_REPORT_CODE,
194: SUBT.LANGUAGE
195: from PER_RI_VIEW_REPORTS_TL SUBB, PER_RI_VIEW_REPORTS_TL SUBT
196: where SUBB.WORKBENCH_VIEW_REPORT_CODE = SUBT.WORKBENCH_VIEW_REPORT_CODE
197: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
198: and (SUBB.WORKBENCH_VIEW_REPORT_NAME <> SUBT.WORKBENCH_VIEW_REPORT_NAME
199: or SUBB.WB_VIEW_REPORT_DESCRIPTION <> SUBT.WB_VIEW_REPORT_DESCRIPTION

Line 202: insert into PER_RI_VIEW_REPORTS_TL (

198: and (SUBB.WORKBENCH_VIEW_REPORT_NAME <> SUBT.WORKBENCH_VIEW_REPORT_NAME
199: or SUBB.WB_VIEW_REPORT_DESCRIPTION <> SUBT.WB_VIEW_REPORT_DESCRIPTION
200: ));
201:
202: insert into PER_RI_VIEW_REPORTS_TL (
203: WORKBENCH_VIEW_REPORT_CODE,
204: WORKBENCH_VIEW_REPORT_NAME,
205: WB_VIEW_REPORT_DESCRIPTION,
206: LAST_UPDATE_DATE,

Line 224: from PER_RI_VIEW_REPORTS_TL B, FND_LANGUAGES L

220: B.CREATED_BY,
221: B.CREATION_DATE,
222: L.LANGUAGE_CODE,
223: B.SOURCE_LANG
224: from PER_RI_VIEW_REPORTS_TL B, FND_LANGUAGES L
225: where L.INSTALLED_FLAG in ('I', 'B')
226: and B.LANGUAGE = userenv('LANG')
227: and not exists
228: (select NULL

Line 229: from PER_RI_VIEW_REPORTS_TL T

225: where L.INSTALLED_FLAG in ('I', 'B')
226: and B.LANGUAGE = userenv('LANG')
227: and not exists
228: (select NULL
229: from PER_RI_VIEW_REPORTS_TL T
230: where T.WORKBENCH_VIEW_REPORT_CODE = B.WORKBENCH_VIEW_REPORT_CODE
231: and T.LANGUAGE = L.LANGUAGE_CODE);
232: --
233: End add_language;