23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE delete_case_groups
27: (p_validate in number default hr_api.g_false_num
28: ,p_case_group_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_case_groups
56: (p_validate in number default hr_api.g_false_num
57: ,p_effective_date in date
58: ,p_case_group_number in varchar2
59: ,p_description in varchar2
60: ,p_advanced_pay_grade in number
96: --
97: -- {End of comments}
98: -- ----------------------------------------------------------------------------
99: PROCEDURE update_case_groups
100: (p_validate in number default hr_api.g_false_num
101: ,p_effective_date in date
102: ,p_case_group_id in number
103: ,p_object_version_number in out nocopy number
104: ,p_case_group_number in varchar2 default hr_api.g_varchar2
100: (p_validate in number default hr_api.g_false_num
101: ,p_effective_date in date
102: ,p_case_group_id in number
103: ,p_object_version_number in out nocopy number
104: ,p_case_group_number in varchar2 default hr_api.g_varchar2
105: ,p_description in varchar2 default hr_api.g_varchar2
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
101: ,p_effective_date in date
102: ,p_case_group_id in number
103: ,p_object_version_number in out nocopy number
104: ,p_case_group_number in varchar2 default hr_api.g_varchar2
105: ,p_description in varchar2 default hr_api.g_varchar2
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
102: ,p_case_group_id in number
103: ,p_object_version_number in out nocopy number
104: ,p_case_group_number in varchar2 default hr_api.g_varchar2
105: ,p_description in varchar2 default hr_api.g_varchar2
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
103: ,p_object_version_number in out nocopy number
104: ,p_case_group_number in varchar2 default hr_api.g_varchar2
105: ,p_description in varchar2 default hr_api.g_varchar2
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
104: ,p_case_group_number in varchar2 default hr_api.g_varchar2
105: ,p_description in varchar2 default hr_api.g_varchar2
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
105: ,p_description in varchar2 default hr_api.g_varchar2
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
106: ,p_advanced_pay_grade in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
107: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
108: ,p_period_of_prob_advmnt in number default hr_api.g_number
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
116: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
109: ,p_period_of_time_advmnt in number default hr_api.g_number
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
116: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
117: ,p_SUB_CSGRP_DESCRIPTION in VARCHAR2 default hr_api.g_varchar2
110: ,p_advancement_to in number default hr_api.g_number
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
116: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
117: ,p_SUB_CSGRP_DESCRIPTION in VARCHAR2 default hr_api.g_varchar2
118: ,p_return_status out nocopy varchar2
111: ,p_advancement_additional_pyt in number default hr_api.g_number
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
116: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
117: ,p_SUB_CSGRP_DESCRIPTION in VARCHAR2 default hr_api.g_varchar2
118: ,p_return_status out nocopy varchar2
119: );
112: ,p_time_advanced_pay_grade in number default hr_api.g_number
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
116: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
117: ,p_SUB_CSGRP_DESCRIPTION in VARCHAR2 default hr_api.g_varchar2
118: ,p_return_status out nocopy varchar2
119: );
120: end pqh_de_case_groups_swi;
113: ,p_time_advancement_to in number default hr_api.g_number
114: ,p_business_group_id in number default hr_api.g_number
115: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
116: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
117: ,p_SUB_CSGRP_DESCRIPTION in VARCHAR2 default hr_api.g_varchar2
118: ,p_return_status out nocopy varchar2
119: );
120: end pqh_de_case_groups_swi;