70: ,p_sub_csgrp_description => p_sub_csgrp_description
71: );
72:
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (p_module_name => 'CREATE_CASE_GROUPS'
77: ,p_hook_type => 'BP'
78: );
71: );
72:
73: exception
74: when hr_api.cannot_find_prog_unit then
75: hr_api.cannot_find_prog_unit_error
76: (p_module_name => 'CREATE_CASE_GROUPS'
77: ,p_hook_type => 'BP'
78: );
79: end;
130: );
131:
132:
133: exception
134: when hr_api.cannot_find_prog_unit then
135: hr_api.cannot_find_prog_unit_error
136: (p_module_name => 'CREATE_CASE_GROUPS'
137: ,p_hook_type => 'AP'
138: );
131:
132:
133: exception
134: when hr_api.cannot_find_prog_unit then
135: hr_api.cannot_find_prog_unit_error
136: (p_module_name => 'CREATE_CASE_GROUPS'
137: ,p_hook_type => 'AP'
138: );
139: end;
140: --
141: -- When in validation only mode raise the Validate_Enabled exception
142: --
143: if p_validate then
144: raise hr_api.validate_enabled;
145: end if;
146: --
147: -- Set all output arguments
148: --
151:
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 70);
154: exception
155: when hr_api.validate_enabled then
156: --
157: -- As the Validate_Enabled exception has been raised
158: -- we must rollback to the savepoint
159: --
186: (p_validate in boolean default false
187: ,p_effective_date in date
188: ,p_case_group_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
187: ,p_effective_date in date
188: ,p_case_group_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
188: ,p_case_group_id in number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
190: ,p_case_group_number in varchar2 default hr_api.g_varchar2
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
191: ,p_description in varchar2 default hr_api.g_varchar2
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
192: ,p_advanced_pay_grade in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
193: ,p_entries_in_minute in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
194: ,p_period_of_prob_advmnt in number default hr_api.g_number
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
195: ,p_period_of_time_advmnt in number default hr_api.g_number
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
196: ,p_advancement_to in number default hr_api.g_number
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
197: ,p_advancement_additional_pyt in number default hr_api.g_number
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:
198: ,p_time_advanced_pay_grade in number default hr_api.g_number
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:
206: l_proc varchar2(72) := g_package||'Update_CASE_GROUPS';
199: ,p_time_advancement_to in number default hr_api.g_number
200: ,p_business_group_id in number default hr_api.g_number
201: ,p_time_advn_units in varchar2 default hr_api.g_varchar2
202: ,p_prob_advn_units in varchar2 default hr_api.g_varchar2
203: ,p_sub_csgrp_description In Varchar2 default hr_api.g_varchar2
204: ) is
205:
206: l_proc varchar2(72) := g_package||'Update_CASE_GROUPS';
207: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
243: );
244:
245:
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_CASE_GROUPS'
250: ,p_hook_type => 'BP'
251: );
244:
245:
246: exception
247: when hr_api.cannot_find_prog_unit then
248: hr_api.cannot_find_prog_unit_error
249: (p_module_name => 'UPDATE_CASE_GROUPS'
250: ,p_hook_type => 'BP'
251: );
252: end;
295: ,p_prob_advn_units => p_prob_advn_units
296: ,p_sub_csgrp_description => p_sub_csgrp_description );
297:
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'UPDATE_CASE_GROUPS'
302: ,p_hook_type => 'AP'
303: );
296: ,p_sub_csgrp_description => p_sub_csgrp_description );
297:
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'UPDATE_CASE_GROUPS'
302: ,p_hook_type => 'AP'
303: );
304: end;
305: --
306: -- When in validation only mode raise the Validate_Enabled exception
307: --
308: if p_validate then
309: raise hr_api.validate_enabled;
310: end if;
311: --
312: -- Set all output arguments
313: --
316:
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 70);
319: exception
320: when hr_api.validate_enabled then
321: --
322: -- As the Validate_Enabled exception has been raised
323: -- we must rollback to the savepoint
324: --
369: ,p_object_version_number => p_object_version_number);
370:
371:
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'delete_CASE_GROUPS'
376: ,p_hook_type => 'BP');
377: end;
370:
371:
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'delete_CASE_GROUPS'
376: ,p_hook_type => 'BP');
377: end;
378: --
391: (p_CASE_GROUP_Id => p_CASE_GROUP_Id
392: ,p_object_version_number => p_object_version_number);
393:
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'DELETE_CASE_GROUPS'
398: ,p_hook_type => 'AP');
399: end;
392: ,p_object_version_number => p_object_version_number);
393:
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'DELETE_CASE_GROUPS'
398: ,p_hook_type => 'AP');
399: end;
400: --
400: --
401: -- When in validation only mode raise the Validate_Enabled exception
402: --
403: if p_validate then
404: raise hr_api.validate_enabled;
405: end if;
406: --
407: -- Set all output arguments
408: --
407: -- Set all output arguments
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
414: -- we must rollback to the savepoint
415: --