23: ,p_workbench_view_report_type In Varchar2
24: ,p_workbench_view_report_action In Varchar2
25: ,p_workbench_view_country In Varchar2
26: ,p_wb_view_report_instruction In Varchar2
27: ,p_language_code In Varchar2 Default hr_api.userenv_lang
28: ,p_effective_date In Date
29: ,p_object_version_number Out Nocopy Number
30: ,p_primary_industry In Varchar2
31: ,p_enabled_flag In Varchar2 Default 'Y'
61: -- instead of p_language_code from now on, to allow an IN OUT parameter to
62: -- be passed through.
63: --
64: l_language_code := p_language_code;
65: hr_api.validate_language_code(p_language_code => l_language_code);
66: --
67: hr_utility.set_location(l_proc, 20);
68:
69: -- Process Logic
95: --
96: -- When in validation only mode raise the Validate_Enabled exception
97: --
98: If p_validate Then
99: Raise hr_api.validate_enabled;
100: End If;
101: --
102: -- Set all output arguments
103: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: --
108: Exception
109: --
110: When hr_api.validate_enabled Then
111: --
112: -- As the Validate_Enabled exception has been raised
113: -- we must rollback to the savepoint
114: --
136: --
137: Procedure update_view_report
138: ( p_validate In Boolean Default False
139: ,p_workbench_view_report_code In Varchar2
140: ,p_workbench_view_report_name In Varchar2 Default hr_api.g_varchar2
141: ,p_wb_view_report_description In Varchar2 Default hr_api.g_varchar2
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
137: Procedure update_view_report
138: ( p_validate In Boolean Default False
139: ,p_workbench_view_report_code In Varchar2
140: ,p_workbench_view_report_name In Varchar2 Default hr_api.g_varchar2
141: ,p_wb_view_report_description In Varchar2 Default hr_api.g_varchar2
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
138: ( p_validate In Boolean Default False
139: ,p_workbench_view_report_code In Varchar2
140: ,p_workbench_view_report_name In Varchar2 Default hr_api.g_varchar2
141: ,p_wb_view_report_description In Varchar2 Default hr_api.g_varchar2
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
139: ,p_workbench_view_report_code In Varchar2
140: ,p_workbench_view_report_name In Varchar2 Default hr_api.g_varchar2
141: ,p_wb_view_report_description In Varchar2 Default hr_api.g_varchar2
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
147: ,p_language_code In Varchar2 Default hr_api.userenv_lang
140: ,p_workbench_view_report_name In Varchar2 Default hr_api.g_varchar2
141: ,p_wb_view_report_description In Varchar2 Default hr_api.g_varchar2
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
147: ,p_language_code In Varchar2 Default hr_api.userenv_lang
148: ,p_effective_date In Date
141: ,p_wb_view_report_description In Varchar2 Default hr_api.g_varchar2
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
147: ,p_language_code In Varchar2 Default hr_api.userenv_lang
148: ,p_effective_date In Date
149: ,p_object_version_number In Out Nocopy Number
142: ,p_workbench_item_code In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
147: ,p_language_code In Varchar2 Default hr_api.userenv_lang
148: ,p_effective_date In Date
149: ,p_object_version_number In Out Nocopy Number
150: ,p_primary_industry In Varchar2 Default hr_api.g_varchar2
143: ,p_workbench_view_report_type In Varchar2 Default hr_api.g_varchar2
144: ,p_workbench_view_report_action In Varchar2 Default hr_api.g_varchar2
145: ,p_workbench_view_country In Varchar2 Default hr_api.g_varchar2
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
147: ,p_language_code In Varchar2 Default hr_api.userenv_lang
148: ,p_effective_date In Date
149: ,p_object_version_number In Out Nocopy Number
150: ,p_primary_industry In Varchar2 Default hr_api.g_varchar2
151: ,p_enabled_flag In Varchar2 Default 'Y'
146: ,p_wb_view_report_instruction In Varchar2 Default hr_api.g_varchar2
147: ,p_language_code In Varchar2 Default hr_api.userenv_lang
148: ,p_effective_date In Date
149: ,p_object_version_number In Out Nocopy Number
150: ,p_primary_industry In Varchar2 Default hr_api.g_varchar2
151: ,p_enabled_flag In Varchar2 Default 'Y'
152: ) Is
153: --
154: -- Declare cursors and local variables
179: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
180: -- passed through.
181: --
182: l_language_code := p_language_code;
183: hr_api.validate_language_code(p_language_code => l_language_code);
184: hr_utility.set_location(l_proc, 20);
185: --
186: --
187: -- Process Logic
217: --
218: -- When in validation only mode raise the Validate_Enabled exception
219: --
220: If p_validate Then
221: Raise hr_api.validate_enabled;
222: End If;
223: --
224: -- Set all output arguments. If p_validate was TRUE, this bit is
225: -- never reached, so p_object_version_number is passed back unchanged.
229: hr_utility.set_location(' Leaving:'||l_proc, 70);
230: --
231: Exception
232: --
233: When hr_api.validate_enabled Then
234: --
235: -- As the Validate_Enabled exception has been raised
236: -- we must rollback to the savepoint
237: --
306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: If p_validate Then
310: Raise hr_api.validate_enabled;
311: End If;
312: --
313: --
314: Exception
312: --
313: --
314: Exception
315: --
316: When hr_api.validate_enabled Then
317: --
318: -- As the Validate_Enabled exception has been raised
319: -- we must rollback to the savepoint
320: --