8: -- ----------------------------------------------------------------------------
9: -- |---------------------------< delete_vldtn_vern >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_vldtn_vern
12: (p_validate in number default hr_api.g_false_num
13: ,p_wrkplc_vldtn_ver_id in number
14: ,p_object_version_number in number
15: ,p_return_status out nocopy varchar2
16: ) is
38: --
39: -- Convert constant values to their corresponding boolean value
40: --
41: l_validate :=
42: hr_api.constant_to_boolean
43: (p_constant_value => p_validate);
44: --
45: -- Register Surrogate ID or user key values
46: --
102: -- ----------------------------------------------------------------------------
103: -- |---------------------------< insert_vldtn_vern >--------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_vldtn_vern
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_business_group_id in number
109: ,p_wrkplc_vldtn_id in number
110: ,p_version_number in number default NULL
148: --
149: -- Convert constant values to their corresponding boolean value
150: --
151: l_validate :=
152: hr_api.constant_to_boolean
153: (p_constant_value => p_validate);
154: --
155: -- Register Surrogate ID or user key values
156: --
235: -- ----------------------------------------------------------------------------
236: -- |---------------------------< update_vldtn_vern >--------------------------|
237: -- ----------------------------------------------------------------------------
238: PROCEDURE update_vldtn_vern
239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
238: PROCEDURE update_vldtn_vern
239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
239: (p_validate in number default hr_api.g_false_num
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
240: ,p_effective_date in date
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
241: ,p_business_group_id in number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
242: ,p_wrkplc_vldtn_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
243: ,p_version_number in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
244: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
245: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
246: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
247: ,p_job_group_id in number default hr_api.g_number
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
248: ,p_remuneration_job_id in number default hr_api.g_number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
249: ,p_derived_grade_id in number default hr_api.g_number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
257: ,p_object_version_number in out nocopy number
250: ,p_derived_case_group_id in number default hr_api.g_number
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
257: ,p_object_version_number in out nocopy number
258: ,p_return_status out nocopy varchar2
251: ,p_derived_subcasgrp_id in number default hr_api.g_number
252: ,p_user_enterable_grade_id in number default hr_api.g_number
253: ,p_user_enterable_case_group_id in number default hr_api.g_number
254: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
255: ,p_freeze in varchar2 default hr_api.g_varchar2
256: ,p_wrkplc_vldtn_ver_id in number
257: ,p_object_version_number in out nocopy number
258: ,p_return_status out nocopy varchar2
259: ) is
283: --
284: -- Convert constant values to their corresponding boolean value
285: --
286: l_validate :=
287: hr_api.constant_to_boolean
288: (p_constant_value => p_validate);
289: --
290: -- Register Surrogate ID or user key values
291: --