APPS.PER_RVR_SHD dependencies on PER_RI_VIEW_REPORTS

Line 48: from per_ri_view_reports

44: ,wb_view_report_instruction
45: ,object_version_number
46: ,primary_industry
47: ,enabled_flag
48: from per_ri_view_reports
49: where workbench_view_report_code = p_workbench_view_report_code;
50: --
51: l_fct_ret boolean;
52: --

Line 122: from per_ri_view_reports

118: ,wb_view_report_instruction
119: ,object_version_number
120: ,primary_industry
121: ,enabled_flag
122: from per_ri_view_reports
123: where workbench_view_report_code = p_workbench_view_report_code
124: for update nowait;
125: --
126: l_proc varchar2(72) := g_package||'lck';

Line 171: fnd_message.set_token('TABLE_NAME', 'per_ri_view_reports');

167: -- The object is locked therefore we need to supply a meaningful
168: -- error message.
169: --
170: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
171: fnd_message.set_token('TABLE_NAME', 'per_ri_view_reports');
172: fnd_message.raise_error;
173: End lck;
174: --
175: -- ----------------------------------------------------------------------------

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 191: from PER_RI_VIEW_REPORTS B

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
193: );
194:
195: update PER_RI_VIEW_REPORTS_TL T set (

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: --