8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_view_report >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_view_report
12: (p_validate in number default hr_api.g_false_num
13: ,p_workbench_view_report_code in varchar2
14: ,p_workbench_view_report_name in varchar2
15: ,p_wb_view_report_description in varchar2
16: ,p_workbench_item_code in varchar2
48: --
49: -- Convert constant values to their corresponding boolean value
50: --
51: l_validate :=
52: hr_api.constant_to_boolean
53: (p_constant_value => p_validate);
54: --
55: -- Register Surrogate ID or user key values
56: --
124: -- ----------------------------------------------------------------------------
125: -- |--------------------------< delete_view_report >--------------------------|
126: -- ----------------------------------------------------------------------------
127: PROCEDURE delete_view_report
128: (p_validate in number default hr_api.g_false_num
129: ,p_workbench_view_report_code in varchar2
130: ,p_object_version_number in number
131: ,p_return_status out nocopy varchar2
132: ) is
154: --
155: -- Convert constant values to their corresponding boolean value
156: --
157: l_validate :=
158: hr_api.constant_to_boolean
159: (p_constant_value => p_validate);
160: --
161: -- Register Surrogate ID or user key values
162: --
218: -- ----------------------------------------------------------------------------
219: -- |--------------------------< update_view_report >--------------------------|
220: -- ----------------------------------------------------------------------------
221: PROCEDURE update_view_report
222: (p_validate in number default hr_api.g_false_num
223: ,p_workbench_view_report_code in varchar2
224: ,p_workbench_view_report_name in varchar2 default hr_api.g_varchar2
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
220: -- ----------------------------------------------------------------------------
221: PROCEDURE update_view_report
222: (p_validate in number default hr_api.g_false_num
223: ,p_workbench_view_report_code in varchar2
224: ,p_workbench_view_report_name in varchar2 default hr_api.g_varchar2
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
221: PROCEDURE update_view_report
222: (p_validate in number default hr_api.g_false_num
223: ,p_workbench_view_report_code in varchar2
224: ,p_workbench_view_report_name in varchar2 default hr_api.g_varchar2
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
222: (p_validate in number default hr_api.g_false_num
223: ,p_workbench_view_report_code in varchar2
224: ,p_workbench_view_report_name in varchar2 default hr_api.g_varchar2
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
230: ,p_wb_view_report_instruction in varchar2 default hr_api.g_varchar2
223: ,p_workbench_view_report_code in varchar2
224: ,p_workbench_view_report_name in varchar2 default hr_api.g_varchar2
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
230: ,p_wb_view_report_instruction in varchar2 default hr_api.g_varchar2
231: ,p_language_code in varchar2 default hr_api.g_varchar2
224: ,p_workbench_view_report_name in varchar2 default hr_api.g_varchar2
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
230: ,p_wb_view_report_instruction in varchar2 default hr_api.g_varchar2
231: ,p_language_code in varchar2 default hr_api.g_varchar2
232: ,p_effective_date in date
225: ,p_wb_view_report_description in varchar2 default hr_api.g_varchar2
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
230: ,p_wb_view_report_instruction in varchar2 default hr_api.g_varchar2
231: ,p_language_code in varchar2 default hr_api.g_varchar2
232: ,p_effective_date in date
233: ,p_object_version_number in out nocopy number
226: ,p_workbench_item_code in varchar2 default hr_api.g_varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
230: ,p_wb_view_report_instruction in varchar2 default hr_api.g_varchar2
231: ,p_language_code in varchar2 default hr_api.g_varchar2
232: ,p_effective_date in date
233: ,p_object_version_number in out nocopy number
234: ,p_return_status out nocopy varchar2
227: ,p_workbench_view_report_type in varchar2 default hr_api.g_varchar2
228: ,p_workbench_view_report_action in varchar2 default hr_api.g_varchar2
229: ,p_workbench_view_country in varchar2 default hr_api.g_varchar2
230: ,p_wb_view_report_instruction in varchar2 default hr_api.g_varchar2
231: ,p_language_code in varchar2 default hr_api.g_varchar2
232: ,p_effective_date in date
233: ,p_object_version_number in out nocopy number
234: ,p_return_status out nocopy varchar2
235: ,p_primary_industry in varchar2 default hr_api.g_varchar2
231: ,p_language_code in varchar2 default hr_api.g_varchar2
232: ,p_effective_date in date
233: ,p_object_version_number in out nocopy number
234: ,p_return_status out nocopy varchar2
235: ,p_primary_industry in varchar2 default hr_api.g_varchar2
236: ) is
237: --
238: -- Variables for API Boolean parameters
239: l_validate boolean;
260: --
261: -- Convert constant values to their corresponding boolean value
262: --
263: l_validate :=
264: hr_api.constant_to_boolean
265: (p_constant_value => p_validate);
266: --
267: -- Register Surrogate ID or user key values
268: --