97: p_primary_flag => p_primary_flag,
98: p_category_usage_id => p_category_usage_id
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'create_act_cat_inclusion_b'
104: ,p_hook_type => 'BP'
105: );
98: p_category_usage_id => p_category_usage_id
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'create_act_cat_inclusion_b'
104: ,p_hook_type => 'BP'
105: );
106: end;
180: p_category_usage_id => p_category_usage_id
181: );
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_act_cat_inclusion_a'
187: ,p_hook_type => 'AP'
188: );
181: );
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_act_cat_inclusion_a'
187: ,p_hook_type => 'AP'
188: );
189: end;
190: --
191: -- When in validation only mode raise the Validate_Enabled exception
192: --
193: if p_validate then
194: raise hr_api.validate_enabled;
195: end if;
196: --
197: -- Set all output arguments
198: --
200: p_object_version_number := l_object_version_number;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised
207: -- we must rollback to the savepoint
208: --
231: (p_validate in boolean default false
232: ,p_effective_date in date
233: ,p_activity_version_id in number
234: ,p_activity_category in varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
233: ,p_activity_version_id in number
234: ,p_activity_category in varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
234: ,p_activity_category in varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
262: ) is
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
262: ) is
263: --
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
262: ) is
263: --
264: -- Declare cursors and local variables
316: p_category_usage_id => p_category_usage_id
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'update_act_cat_inclusion_b'
323: ,p_hook_type => 'BP'
324: );
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'update_act_cat_inclusion_b'
323: ,p_hook_type => 'BP'
324: );
325: end;
397: p_primary_flag => p_primary_flag,
398: p_category_usage_id => p_category_usage_id
399: );
400: exception
401: when hr_api.cannot_find_prog_unit then
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'update_act_cat_inclusion'
404: ,p_hook_type => 'AP'
405: );
398: p_category_usage_id => p_category_usage_id
399: );
400: exception
401: when hr_api.cannot_find_prog_unit then
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'update_act_cat_inclusion'
404: ,p_hook_type => 'AP'
405: );
406: end;
407: --
408: -- When in validation only mode raise the Validate_Enabled exception
409: --
410: if p_validate then
411: raise hr_api.validate_enabled;
412: end if;
413: --
414: -- Set all output arguments
415: --
416: -- p_object_version_number := l_object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: exception
420: when hr_api.validate_enabled then
421: --
422: -- As the Validate_Enabled exception has been raised
423: -- we must rollback to the savepoint
424: --
472: p_category_usage_id => p_category_usage_id,
473: p_object_version_number => p_object_version_number);
474:
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'delete_act_cat_inclusion_b '
479: ,p_hook_type => 'BP'
480: );
473: p_object_version_number => p_object_version_number);
474:
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'delete_act_cat_inclusion_b '
479: ,p_hook_type => 'BP'
480: );
481: end;
497: (p_activity_version_id => p_activity_version_id ,
498: p_category_usage_id => p_category_usage_id,
499: p_object_version_number => p_object_version_number);
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: (p_module_name => 'delete_act_cat_inclusion_a '
504: ,p_hook_type => 'AP'
505: );
498: p_category_usage_id => p_category_usage_id,
499: p_object_version_number => p_object_version_number);
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: (p_module_name => 'delete_act_cat_inclusion_a '
504: ,p_hook_type => 'AP'
505: );
506: end;
507: --
508: -- When in validation only mode raise the Validate_Enabled exception
509: --
510: if p_validate then
511: raise hr_api.validate_enabled;
512: end if;
513: --
514: -- Set all output arguments
515: --
515: --
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 170);
518: exception
519: when hr_api.validate_enabled then
520: --
521: -- As the Validate_Enabled exception has been raised
522: -- we must rollback to the savepoint
523: --