88: --
89:
90: --
91: BEGIN
92: hr_utility.set_location('Entering:'|| l_proc, 10);
93: --
94: -- Truncate the time portion from all IN date parameters
95: --
96: l_effective_date := trunc(p_effective_date);
127: end;
128:
129: --
130: --
131: hr_utility.set_location(l_proc, 20);
132: --
133: -- Process Logic
134: --
135: per_osv_ins.ins
148: ,p_object_version_number => l_object_version_number
149: ,p_gap_warning => p_gap_warning
150: );
151: --
152: hr_utility.set_location(l_proc, 60);
153:
154: begin
155:
156: per_org_structure_version_bk1.create_org_structure_version_a
208: RAISE hr_api.validate_enabled;
209: END IF;
210: --
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: --
214:
215: EXCEPTION
216: --
226: -- when validation only mode is being used.)
227: --
228: p_org_structure_version_id := NULL;
229: p_object_version_number := NULL;
230: hr_utility.set_location(' Leaving:'||l_proc, 80);
231: WHEN OTHERS THEN
232: --
233: -- A validation or unexpected error has occurred
234: ROLLBACK TO create_org_structure_version;
237: --
238: p_org_structure_version_id := NULL;
239: p_object_version_number := NULL;
240: p_gap_warning := false;
241: hr_utility.set_location(' Leaving:'||l_proc, 90);
242: RAISE;
243: --
244: END create_org_structure_version;
245:
303: ,p_hook_type => 'BP'
304: );
305: end;
306: --
307: hr_utility.set_location('Entering:'|| l_proc, 10);
308: --
309: --
310: hr_utility.set_location(l_proc, 20);
311: --
306: --
307: hr_utility.set_location('Entering:'|| l_proc, 10);
308: --
309: --
310: hr_utility.set_location(l_proc, 20);
311: --
312: --
313: -- Process Logic
314: --
333: --
334: --
335: --
336: --
337: hr_utility.set_location(l_proc, 60);
338: --
339: -- When in validation only mode raise the Validate_Enabled exception
340: --
341: IF p_validate THEN
346: -- never reached, so p_object_version_number is passed back unchanged.
347: --
348: p_object_version_number := l_object_version_number;
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 70);
351: --
352:
353: begin
354: per_org_structure_version_bk2.update_org_structure_version_a
387: -- Only set output warning arguments
388: -- (Any key or derived arguments must be set to null
389: -- when validation only mode is being used.)
390:
391: hr_utility.set_location(' Leaving:'||l_proc, 80);
392: WHEN OTHERS THEN
393: --
394: -- A validation or unexpected error has occurred
395: ROLLBACK TO update_org_structure_version;
397: -- set in out parameters and set out parameters
398: --
399: p_object_version_number := l_ovn;
400: p_gap_warning := false;
401: hr_utility.set_location(' Leaving:'||l_proc, 90);
402: RAISE;
403: --
404: --
405: END update_org_structure_version;
447: -- =============
448: --
449: -- Need to lock main table to maintain the locking ladder order
450: --
451: hr_utility.set_location( l_proc, 30);
452: per_osv_shd.lck (p_org_structure_version_id => p_org_structure_version_id,
453: p_object_version_number => p_object_version_number );
454: --
455: hr_utility.set_location( l_proc, 40);
451: hr_utility.set_location( l_proc, 30);
452: per_osv_shd.lck (p_org_structure_version_id => p_org_structure_version_id,
453: p_object_version_number => p_object_version_number );
454: --
455: hr_utility.set_location( l_proc, 40);
456: per_osv_del.del ( p_org_structure_version_id => p_org_structure_version_id,
457: p_object_version_number => p_object_version_number );
458: --
459: --
456: per_osv_del.del ( p_org_structure_version_id => p_org_structure_version_id,
457: p_object_version_number => p_object_version_number );
458: --
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 60);
461: --
462: -- When in validation only mode raise the Validate_Enabled exception
463: --
464: IF p_validate THEN
494: -- Only set output warning arguments
495: -- (Any key or derived arguments must be set to null
496: -- when validation only mode is being used.)
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 80);
499: WHEN OTHERS THEN
500: --
501: -- A validation or unexpected error has occurred
502: ROLLBACK TO delete_org_structure_version;
499: WHEN OTHERS THEN
500: --
501: -- A validation or unexpected error has occurred
502: ROLLBACK TO delete_org_structure_version;
503: hr_utility.set_location(' Leaving:'||l_proc, 90);
504: RAISE;
505: --
506: end delete_org_structure_version;
507: --