APPS.PER_RI_VIEW_REPORT_API dependencies on PER_RI_VIEW_REPORTS

Line 37: l_object_version_number per_ri_view_reports.object_version_number%TYPE;

33: --
34: -- Declare cursors and local variables
35: --
36: l_proc Varchar2(72) := g_package||'create_view_report';
37: l_object_version_number per_ri_view_reports.object_version_number%TYPE;
38: l_language_code per_ri_view_reports_tl.language%TYPE;
39: l_effective_date Date;
40: l_workbench_item_creation_date Date;
41: l_workbench_item_code per_ri_view_reports.workbench_item_code%TYPE;

Line 38: l_language_code per_ri_view_reports_tl.language%TYPE;

34: -- Declare cursors and local variables
35: --
36: l_proc Varchar2(72) := g_package||'create_view_report';
37: l_object_version_number per_ri_view_reports.object_version_number%TYPE;
38: l_language_code per_ri_view_reports_tl.language%TYPE;
39: l_effective_date Date;
40: l_workbench_item_creation_date Date;
41: l_workbench_item_code per_ri_view_reports.workbench_item_code%TYPE;
42: --

Line 41: l_workbench_item_code per_ri_view_reports.workbench_item_code%TYPE;

37: l_object_version_number per_ri_view_reports.object_version_number%TYPE;
38: l_language_code per_ri_view_reports_tl.language%TYPE;
39: l_effective_date Date;
40: l_workbench_item_creation_date Date;
41: l_workbench_item_code per_ri_view_reports.workbench_item_code%TYPE;
42: --
43: Begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 71: -- Insert non-translatable rows into PER_RI_VIEW_REPORTS first

67: hr_utility.set_location(l_proc, 20);
68:
69: -- Process Logic
70: --
71: -- Insert non-translatable rows into PER_RI_VIEW_REPORTS first
72: per_rvr_ins.ins
73: (p_workbench_view_report_code => p_workbench_view_report_code
74: ,p_workbench_item_code => p_workbench_item_code
75: ,p_workbench_view_report_type => p_workbench_view_report_type

Line 86: -- Now insert translatable rows in PER_RI_VIEW_REPORTS_TL table

82: );
83:
84:
85: --
86: -- Now insert translatable rows in PER_RI_VIEW_REPORTS_TL table
87: per_rvt_ins.ins_tl
88: (p_workbench_view_report_code =>p_workbench_view_report_code
89: ,p_workbench_view_report_name =>p_workbench_view_report_name
90: ,p_wb_view_report_description =>p_wb_view_report_description

Line 157: l_object_version_number per_ri_view_reports.object_version_number%TYPE;

153: --
154: -- Declare cursors and local variables
155: --
156: l_proc VARCHAR2(72) := g_package||'update_view_report';
157: l_object_version_number per_ri_view_reports.object_version_number%TYPE;
158: l_language_code per_ri_view_reports_tl.language%TYPE;
159: l_workbench_item_creation_date Date;
160: l_effective_date DATE;
161:

Line 158: l_language_code per_ri_view_reports_tl.language%TYPE;

154: -- Declare cursors and local variables
155: --
156: l_proc VARCHAR2(72) := g_package||'update_view_report';
157: l_object_version_number per_ri_view_reports.object_version_number%TYPE;
158: l_language_code per_ri_view_reports_tl.language%TYPE;
159: l_workbench_item_creation_date Date;
160: l_effective_date DATE;
161:
162: l_temp_ovn number := p_object_version_number;

Line 191: -- Insert non-translatable rows in PER_RI_VIEW_REPORTS Table

187: -- Process Logic
188: --
189: l_object_version_number := p_object_version_number;
190: --
191: -- Insert non-translatable rows in PER_RI_VIEW_REPORTS Table
192: --
193: per_rvr_upd.upd
194: (p_workbench_view_report_code => p_workbench_view_report_code
195: ,p_workbench_item_code => p_workbench_item_code

Line 205: -- Now insert translatable rows in PER_RI_VIEW_REPORTS_TL table

201: ,p_primary_industry => p_primary_industry
202: ,p_enabled_flag => p_enabled_flag
203: );
204: --
205: -- Now insert translatable rows in PER_RI_VIEW_REPORTS_TL table
206:
207: per_rvt_upd.upd_tl
208: (p_workbench_view_report_code => p_workbench_view_report_code
209: ,p_workbench_view_report_name => p_workbench_view_report_name