23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE delete_vldtn_vern
27: (p_validate in number default hr_api.g_false_num
28: ,p_wrkplc_vldtn_ver_id in number
29: ,p_object_version_number in number
30: ,p_return_status out nocopy varchar2
31: );
52: --
53: -- {End of comments}
54: -- ----------------------------------------------------------------------------
55: PROCEDURE insert_vldtn_vern
56: (p_validate in number default hr_api.g_false_num
57: ,p_effective_date in date
58: ,p_business_group_id in number
59: ,p_wrkplc_vldtn_id in number
60: ,p_version_number in number default NULL
97: --
98: -- {End of comments}
99: -- ----------------------------------------------------------------------------
100: PROCEDURE update_vldtn_vern
101: (p_validate in number default hr_api.g_false_num
102: ,p_effective_date in date
103: ,p_business_group_id in number
104: ,p_wrkplc_vldtn_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
100: PROCEDURE update_vldtn_vern
101: (p_validate in number default hr_api.g_false_num
102: ,p_effective_date in date
103: ,p_business_group_id in number
104: ,p_wrkplc_vldtn_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
101: (p_validate in number default hr_api.g_false_num
102: ,p_effective_date in date
103: ,p_business_group_id in number
104: ,p_wrkplc_vldtn_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
102: ,p_effective_date in date
103: ,p_business_group_id in number
104: ,p_wrkplc_vldtn_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
103: ,p_business_group_id in number
104: ,p_wrkplc_vldtn_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
104: ,p_wrkplc_vldtn_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
105: ,p_version_number in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
106: ,p_remuneration_job_description in varchar2 default hr_api.g_varchar2
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
107: ,p_tariff_contract_code in varchar2 default hr_api.g_varchar2
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
108: ,p_tariff_group_code in varchar2 default hr_api.g_varchar2
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
116: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
109: ,p_job_group_id in number default hr_api.g_number
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
116: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
117: ,p_freeze in varchar2 default hr_api.g_varchar2
110: ,p_remuneration_job_id in number default hr_api.g_number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
116: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
117: ,p_freeze in varchar2 default hr_api.g_varchar2
118: ,p_wrkplc_vldtn_ver_id in number
111: ,p_derived_grade_id in number default hr_api.g_number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
116: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
117: ,p_freeze in varchar2 default hr_api.g_varchar2
118: ,p_wrkplc_vldtn_ver_id in number
119: ,p_object_version_number in out nocopy number
112: ,p_derived_case_group_id in number default hr_api.g_number
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
116: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
117: ,p_freeze in varchar2 default hr_api.g_varchar2
118: ,p_wrkplc_vldtn_ver_id in number
119: ,p_object_version_number in out nocopy number
120: ,p_return_status out nocopy varchar2
113: ,p_derived_subcasgrp_id in number default hr_api.g_number
114: ,p_user_enterable_grade_id in number default hr_api.g_number
115: ,p_user_enterable_case_group_id in number default hr_api.g_number
116: ,p_user_enterable_subcasgrp_id in number default hr_api.g_number
117: ,p_freeze in varchar2 default hr_api.g_varchar2
118: ,p_wrkplc_vldtn_ver_id in number
119: ,p_object_version_number in out nocopy number
120: ,p_return_status out nocopy varchar2
121: );