47: ,p_applicant_assignment_id => p_applicant_assignment_id
48: ,p_offer_assignment_id => p_offer_assignment_id
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (
54: p_module_name => 'CREATE_pil_assignment'
55: ,p_hook_type => 'BP'
48: ,p_offer_assignment_id => p_offer_assignment_id
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (
54: p_module_name => 'CREATE_pil_assignment'
55: ,p_hook_type => 'BP'
56: );
82: ,p_object_version_number => l_object_version_number
83:
84: );
85: exception
86: when hr_api.cannot_find_prog_unit then
87: hr_api.cannot_find_prog_unit_error
88: (p_module_name => 'CREATE_pil_assignment'
89: ,p_hook_type => 'AP'
90: );
83:
84: );
85: exception
86: when hr_api.cannot_find_prog_unit then
87: hr_api.cannot_find_prog_unit_error
88: (p_module_name => 'CREATE_pil_assignment'
89: ,p_hook_type => 'AP'
90: );
91: --
97: --
98: -- When in validation only mode raise the Validate_Enabled exception
99: --
100: if p_validate then
101: raise hr_api.validate_enabled;
102: end if;
103: --
104: -- Set all output arguments
105: --
109:
110: --
111: exception
112: --
113: when hr_api.validate_enabled then
114: --
115: -- As the Validate_Enabled exception has been raised
116: -- we must rollback to the savepoint
117: --
142: procedure update_pil_assignment
143: (
144: p_validate in boolean default false
145: ,p_pil_assignment_id in number
146: ,p_per_in_ler_id in number default hr_api.g_number
147: ,p_applicant_assignment_id in number default hr_api.g_number
148: ,p_offer_assignment_id in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
143: (
144: p_validate in boolean default false
145: ,p_pil_assignment_id in number
146: ,p_per_in_ler_id in number default hr_api.g_number
147: ,p_applicant_assignment_id in number default hr_api.g_number
148: ,p_offer_assignment_id in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
151: --
144: p_validate in boolean default false
145: ,p_pil_assignment_id in number
146: ,p_per_in_ler_id in number default hr_api.g_number
147: ,p_applicant_assignment_id in number default hr_api.g_number
148: ,p_offer_assignment_id in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
151: --
152: -- Declare cursors and local variables
185: ,p_offer_assignment_id => p_offer_assignment_id
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'UPDATE_pil_assignment'
192: ,p_hook_type => 'BP'
193: );
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'UPDATE_pil_assignment'
192: ,p_hook_type => 'BP'
193: );
194: --
217: ,p_offer_assignment_id => p_offer_assignment_id
218: ,p_object_version_number => l_object_version_number
219: );
220: exception
221: when hr_api.cannot_find_prog_unit then
222: hr_api.cannot_find_prog_unit_error
223: (p_module_name => 'UPDATE_pil_assignment'
224: ,p_hook_type => 'AP'
225: );
218: ,p_object_version_number => l_object_version_number
219: );
220: exception
221: when hr_api.cannot_find_prog_unit then
222: hr_api.cannot_find_prog_unit_error
223: (p_module_name => 'UPDATE_pil_assignment'
224: ,p_hook_type => 'AP'
225: );
226: --
232: --
233: -- When in validation only mode raise the Validate_Enabled exception
234: --
235: if p_validate then
236: raise hr_api.validate_enabled;
237: end if;
238: --
239: -- Set all output arguments
240: --
243:
244: --
245: exception
246: --
247: when hr_api.validate_enabled then
248: --
249: -- As the Validate_Enabled exception has been raised
250: -- we must rollback to the savepoint
251: --
304: p_pil_assignment_id => p_pil_assignment_id
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'DELETE_pil_assignment'
311: ,p_hook_type => 'BP'
312: );
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'DELETE_pil_assignment'
311: ,p_hook_type => 'BP'
312: );
313: --
330: p_pil_assignment_id => p_pil_assignment_id
331: ,p_object_version_number => l_object_version_number
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'DELETE_pil_assignment'
337: ,p_hook_type => 'AP'
338: );
331: ,p_object_version_number => l_object_version_number
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'DELETE_pil_assignment'
337: ,p_hook_type => 'AP'
338: );
339: --
345: --
346: -- When in validation only mode raise the Validate_Enabled exception
347: --
348: if p_validate then
349: raise hr_api.validate_enabled;
350: end if;
351: --
352:
353: --
352:
353: --
354: exception
355: --
356: when hr_api.validate_enabled then
357: --
358: -- As the Validate_Enabled exception has been raised
359: -- we must rollback to the savepoint
360: --