48: ,p_select_flag => p_select_flag
49: ,p_effective_date => trunc(p_effective_date)
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (
55: p_module_name => 'CREATE_COPY_ENTITY_PREF'
56: ,p_hook_type => 'BP'
49: ,p_effective_date => trunc(p_effective_date)
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (
55: p_module_name => 'CREATE_COPY_ENTITY_PREF'
56: ,p_hook_type => 'BP'
57: );
83: ,p_object_version_number => l_object_version_number
84: ,p_effective_date => trunc(p_effective_date)
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_COPY_ENTITY_PREF'
90: ,p_hook_type => 'AP'
91: );
84: ,p_effective_date => trunc(p_effective_date)
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_COPY_ENTITY_PREF'
90: ,p_hook_type => 'AP'
91: );
92: --
98: --
99: -- When in validation only mode raise the Validate_Enabled exception
100: --
101: if p_validate then
102: raise hr_api.validate_enabled;
103: end if;
104: --
105: -- Set all output arguments
106: --
110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: --
112: exception
113: --
114: when hr_api.validate_enabled then
115: --
116: -- As the Validate_Enabled exception has been raised
117: -- we must rollback to the savepoint
118: --
142: --
143: procedure update_copy_entity_pref
144: (p_validate in boolean default false
145: ,p_copy_entity_pref_id in number
146: ,p_table_route_id in number default hr_api.g_number
147: ,p_copy_entity_txn_id in number default hr_api.g_number
148: ,p_select_flag in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
143: procedure update_copy_entity_pref
144: (p_validate in boolean default false
145: ,p_copy_entity_pref_id in number
146: ,p_table_route_id in number default hr_api.g_number
147: ,p_copy_entity_txn_id in number default hr_api.g_number
148: ,p_select_flag in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
151: ) is
144: (p_validate in boolean default false
145: ,p_copy_entity_pref_id in number
146: ,p_table_route_id in number default hr_api.g_number
147: ,p_copy_entity_txn_id in number default hr_api.g_number
148: ,p_select_flag in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
151: ) is
152: --
182: ,p_object_version_number => p_object_version_number
183: ,p_effective_date => trunc(p_effective_date)
184: );
185: exception
186: when hr_api.cannot_find_prog_unit then
187: hr_api.cannot_find_prog_unit_error
188: (p_module_name => 'UPDATE_COPY_ENTITY_PREF'
189: ,p_hook_type => 'BP'
190: );
183: ,p_effective_date => trunc(p_effective_date)
184: );
185: exception
186: when hr_api.cannot_find_prog_unit then
187: hr_api.cannot_find_prog_unit_error
188: (p_module_name => 'UPDATE_COPY_ENTITY_PREF'
189: ,p_hook_type => 'BP'
190: );
191: --
216: ,p_object_version_number => l_object_version_number
217: ,p_effective_date => trunc(p_effective_date)
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'UPDATE_COPY_ENTITY_PREF'
223: ,p_hook_type => 'AP'
224: );
217: ,p_effective_date => trunc(p_effective_date)
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'UPDATE_COPY_ENTITY_PREF'
223: ,p_hook_type => 'AP'
224: );
225: --
231: --
232: -- When in validation only mode raise the Validate_Enabled exception
233: --
234: if p_validate then
235: raise hr_api.validate_enabled;
236: end if;
237: --
238: -- Set all output arguments
239: --
242: hr_utility.set_location(' Leaving:'||l_proc, 70);
243: --
244: exception
245: --
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised
249: -- we must rollback to the savepoint
250: --
306: ,p_object_version_number => p_object_version_number
307: ,p_effective_date => trunc(p_effective_date)
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'DELETE_COPY_ENTITY_PREF'
313: ,p_hook_type => 'BP'
314: );
307: ,p_effective_date => trunc(p_effective_date)
308: );
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'DELETE_COPY_ENTITY_PREF'
313: ,p_hook_type => 'BP'
314: );
315: --
334: ,p_object_version_number => l_object_version_number
335: ,p_effective_date => trunc(p_effective_date)
336: );
337: exception
338: when hr_api.cannot_find_prog_unit then
339: hr_api.cannot_find_prog_unit_error
340: (p_module_name => 'DELETE_COPY_ENTITY_PREF'
341: ,p_hook_type => 'AP'
342: );
335: ,p_effective_date => trunc(p_effective_date)
336: );
337: exception
338: when hr_api.cannot_find_prog_unit then
339: hr_api.cannot_find_prog_unit_error
340: (p_module_name => 'DELETE_COPY_ENTITY_PREF'
341: ,p_hook_type => 'AP'
342: );
343: --
349: --
350: -- When in validation only mode raise the Validate_Enabled exception
351: --
352: if p_validate then
353: raise hr_api.validate_enabled;
354: end if;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: --
356: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: --
358: exception
359: --
360: when hr_api.validate_enabled then
361: --
362: -- As the Validate_Enabled exception has been raised
363: -- we must rollback to the savepoint
364: --