8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< delete_case_groups >--------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE delete_case_groups
12: (p_validate in number default hr_api.g_false_num
13: ,p_case_group_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_case_groups >--------------------------|
104: -- ----------------------------------------------------------------------------
105: PROCEDURE insert_case_groups
106: (p_validate in number default hr_api.g_false_num
107: ,p_effective_date in date
108: ,p_case_group_number in varchar2
109: ,p_description in varchar2
110: ,p_advanced_pay_grade in number
147: --
148: -- Convert constant values to their corresponding boolean value
149: --
150: l_validate :=
151: hr_api.constant_to_boolean
152: (p_constant_value => p_validate);
153: --
154: -- Register Surrogate ID or user key values
155: --
229: -- ----------------------------------------------------------------------------
230: -- |--------------------------< update_case_groups >--------------------------|
231: -- ----------------------------------------------------------------------------
232: PROCEDURE update_case_groups
233: (p_validate in number default hr_api.g_false_num
234: ,p_effective_date in date
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
233: (p_validate in number default hr_api.g_false_num
234: ,p_effective_date in date
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
234: ,p_effective_date in date
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
235: ,p_case_group_id in number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
236: ,p_object_version_number in out nocopy number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
237: ,p_case_group_number in varchar2 default hr_api.g_varchar2
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
238: ,p_description in varchar2 default hr_api.g_varchar2
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
239: ,p_advanced_pay_grade in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
240: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
241: ,p_period_of_prob_advmnt in number default hr_api.g_number
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
242: ,p_period_of_time_advmnt in number default hr_api.g_number
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
243: ,p_advancement_to in number default hr_api.g_number
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
244: ,p_advancement_additional_pyt in number default hr_api.g_number
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
252: ) is
245: ,p_time_advanced_pay_grade in number default hr_api.g_number
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
252: ) is
253: --
246: ,p_time_advancement_to in number default hr_api.g_number
247: ,p_business_group_id in number default hr_api.g_number
248: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
249: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
250: ,p_SUB_CSGRP_DESCRIPTION in varchar2 default hr_api.g_varchar2
251: ,p_return_status out nocopy varchar2
252: ) is
253: --
254: -- Variables for API Boolean parameters
277: --
278: -- Convert constant values to their corresponding boolean value
279: --
280: l_validate :=
281: hr_api.constant_to_boolean
282: (p_constant_value => p_validate);
283: --
284: -- Register Surrogate ID or user key values
285: --