68: ,p_status => p_status
69: ,p_effective_date => trunc(p_effective_date)
70: );
71: exception
72: when hr_API.cannot_find_prog_unit then
73: hr_API.cannot_find_prog_unit_error
74: (
75: p_module_name => 'CREATE_COPY_ENTITY_TXN'
76: ,p_hook_type => 'BP'
69: ,p_effective_date => trunc(p_effective_date)
70: );
71: exception
72: when hr_API.cannot_find_prog_unit then
73: hr_API.cannot_find_prog_unit_error
74: (
75: p_module_name => 'CREATE_COPY_ENTITY_TXN'
76: ,p_hook_type => 'BP'
77: );
123: ,p_object_version_number => l_object_version_number
124: ,p_effective_date => trunc(p_effective_date)
125: );
126: exception
127: when hr_API.cannot_find_prog_unit then
128: hr_API.cannot_find_prog_unit_error
129: (p_module_name => 'CREATE_COPY_ENTITY_TXN'
130: ,p_hook_type => 'AP'
131: );
124: ,p_effective_date => trunc(p_effective_date)
125: );
126: exception
127: when hr_API.cannot_find_prog_unit then
128: hr_API.cannot_find_prog_unit_error
129: (p_module_name => 'CREATE_COPY_ENTITY_TXN'
130: ,p_hook_type => 'AP'
131: );
132: --
138: --
139: -- When in validation only mode raise the Validate_Enabled exception
140: --
141: if p_validate then
142: raise hr_API.validate_enabled;
143: end if;
144: --
145: -- Set all output arguments
146: --
150: hr_utility.set_location(' Leaving:'||l_proc, 70);
151: --
152: exception
153: --
154: when hr_API.validate_enabled then
155: --
156: -- As the Validate_Enabled exception has been raised
157: -- we must rollback to the savepoint
158: --
182: --
183: procedure update_COPY_ENTITY_TXN
184: (p_validate in boolean default false
185: ,p_copy_entity_txn_id in number
186: ,p_transaction_category_id in number default hr_API.g_number
187: ,p_txn_category_attribute_id in number default hr_API.g_number
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
183: procedure update_COPY_ENTITY_TXN
184: (p_validate in boolean default false
185: ,p_copy_entity_txn_id in number
186: ,p_transaction_category_id in number default hr_API.g_number
187: ,p_txn_category_attribute_id in number default hr_API.g_number
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
184: (p_validate in boolean default false
185: ,p_copy_entity_txn_id in number
186: ,p_transaction_category_id in number default hr_API.g_number
187: ,p_txn_category_attribute_id in number default hr_API.g_number
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
185: ,p_copy_entity_txn_id in number
186: ,p_transaction_category_id in number default hr_API.g_number
187: ,p_txn_category_attribute_id in number default hr_API.g_number
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
186: ,p_transaction_category_id in number default hr_API.g_number
187: ,p_txn_category_attribute_id in number default hr_API.g_number
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
187: ,p_txn_category_attribute_id in number default hr_API.g_number
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
188: ,p_context_business_group_id in number default hr_api.g_number
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
189: ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
197: ,p_increment_by in number default hr_API.g_number
190: ,p_context in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
197: ,p_increment_by in number default hr_API.g_number
198: ,p_status in varchar2 default hr_API.g_varchar2
191: ,p_action_date in date default hr_API.g_date
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
197: ,p_increment_by in number default hr_API.g_number
198: ,p_status in varchar2 default hr_API.g_varchar2
199: ,p_object_version_number in out nocopy number
192: ,p_src_effective_date in date default hr_API.g_date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
197: ,p_increment_by in number default hr_API.g_number
198: ,p_status in varchar2 default hr_API.g_varchar2
199: ,p_object_version_number in out nocopy number
200: ,p_effective_date in date
193: ,p_number_of_copies in number default hr_API.g_number
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
197: ,p_increment_by in number default hr_API.g_number
198: ,p_status in varchar2 default hr_API.g_varchar2
199: ,p_object_version_number in out nocopy number
200: ,p_effective_date in date
201: ) is
194: ,p_display_name in varchar2 default hr_API.g_varchar2
195: ,p_replacement_type_cd in varchar2 default hr_API.g_varchar2
196: ,p_start_with in varchar2 default hr_API.g_varchar2
197: ,p_increment_by in number default hr_API.g_number
198: ,p_status in varchar2 default hr_API.g_varchar2
199: ,p_object_version_number in out nocopy number
200: ,p_effective_date in date
201: ) is
202: --
242: ,p_object_version_number => p_object_version_number
243: ,p_effective_date => trunc(p_effective_date)
244: );
245: exception
246: when hr_API.cannot_find_prog_unit then
247: hr_API.cannot_find_prog_unit_error
248: (p_module_name => 'UPDATE_COPY_ENTITY_TXN'
249: ,p_hook_type => 'BP'
250: );
243: ,p_effective_date => trunc(p_effective_date)
244: );
245: exception
246: when hr_API.cannot_find_prog_unit then
247: hr_API.cannot_find_prog_unit_error
248: (p_module_name => 'UPDATE_COPY_ENTITY_TXN'
249: ,p_hook_type => 'BP'
250: );
251: --
296: ,p_object_version_number => l_object_version_number
297: ,p_effective_date => trunc(p_effective_date)
298: );
299: exception
300: when hr_API.cannot_find_prog_unit then
301: hr_API.cannot_find_prog_unit_error
302: (p_module_name => 'UPDATE_COPY_ENTITY_TXN'
303: ,p_hook_type => 'AP'
304: );
297: ,p_effective_date => trunc(p_effective_date)
298: );
299: exception
300: when hr_API.cannot_find_prog_unit then
301: hr_API.cannot_find_prog_unit_error
302: (p_module_name => 'UPDATE_COPY_ENTITY_TXN'
303: ,p_hook_type => 'AP'
304: );
305: --
311: --
312: -- When in validation only mode raise the Validate_Enabled exception
313: --
314: if p_validate then
315: raise hr_API.validate_enabled;
316: end if;
317: --
318: -- Set all output arguments
319: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: --
324: exception
325: --
326: when hr_API.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --
388: ,p_object_version_number => p_object_version_number
389: ,p_effective_date => trunc(p_effective_date)
390: );
391: exception
392: when hr_API.cannot_find_prog_unit then
393: hr_API.cannot_find_prog_unit_error
394: (p_module_name => 'DELETE_COPY_ENTITY_TXN'
395: ,p_hook_type => 'BP'
396: );
389: ,p_effective_date => trunc(p_effective_date)
390: );
391: exception
392: when hr_API.cannot_find_prog_unit then
393: hr_API.cannot_find_prog_unit_error
394: (p_module_name => 'DELETE_COPY_ENTITY_TXN'
395: ,p_hook_type => 'BP'
396: );
397: --
416: ,p_object_version_number => l_object_version_number
417: ,p_effective_date => trunc(p_effective_date)
418: );
419: exception
420: when hr_API.cannot_find_prog_unit then
421: hr_API.cannot_find_prog_unit_error
422: (p_module_name => 'DELETE_COPY_ENTITY_TXN'
423: ,p_hook_type => 'AP'
424: );
417: ,p_effective_date => trunc(p_effective_date)
418: );
419: exception
420: when hr_API.cannot_find_prog_unit then
421: hr_API.cannot_find_prog_unit_error
422: (p_module_name => 'DELETE_COPY_ENTITY_TXN'
423: ,p_hook_type => 'AP'
424: );
425: --
431: --
432: -- When in validation only mode raise the Validate_Enabled exception
433: --
434: if p_validate then
435: raise hr_API.validate_enabled;
436: end if;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 70);
439: --
438: hr_utility.set_location(' Leaving:'||l_proc, 70);
439: --
440: exception
441: --
442: when hr_API.validate_enabled then
443: --
444: -- As the Validate_Enabled exception has been raised
445: -- we must rollback to the savepoint
446: --