149: l_organization_structure_id per_organization_Structures.organization_structure_id%TYPE;
150: l_object_version_number per_organization_structures.object_version_number%TYPE;
151: --
152: BEGIN
153: hr_utility.set_location('Entering:'|| l_proc, 10);
154: --
155: -- Issue a savepoint
156: --
157: savepoint create_organization_structure;
203:
204: --
205: --
206: --
207: hr_utility.set_location(l_proc, 20);
208: --
209: -- Process Logic
210: --
211: per_ors_ins.ins
243: ,p_organization_structure_id =>l_organization_structure_id
244: ,p_object_version_number =>l_object_version_number );
245:
246: --
247: hr_utility.set_location(l_proc, 60);
248: --
249: -- When in validation only mode raise the Validate_Enabled exception
250: --
251: IF p_validate THEN
256: --
257: p_organization_structure_id := l_organization_structure_id;
258: p_object_version_number := l_object_version_number;
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 70);
261: --
262:
263:
264:
322: -- when validation only mode is being used.)
323: --
324: p_organization_structure_id := NULL;
325: p_object_version_number := NULL;
326: hr_utility.set_location(' Leaving:'||l_proc, 80);
327: WHEN OTHERS THEN
328: --
329: -- A validation or unexpected error has occurred
330: ROLLBACK TO create_organization_structure;
332: -- set in out parameters and set out parameters
333: --
334: p_organization_structure_id := NULL;
335: p_object_version_number := NULL;
336: hr_utility.set_location(' Leaving:'||l_proc, 90);
337: RAISE;
338: --
339: END create_organization_structure;
340:
438: ,p_hook_type => 'BP'
439: );
440: end;
441: --
442: hr_utility.set_location('Entering:'|| l_proc, 10);
443: --
444: --
445: hr_utility.set_location(l_proc, 20);
446: --
441: --
442: hr_utility.set_location('Entering:'|| l_proc, 10);
443: --
444: --
445: hr_utility.set_location(l_proc, 20);
446: --
447: --
448: -- Process Logic
449: --
489: --
490: --
491: --
492: --
493: hr_utility.set_location(l_proc, 60);
494: --
495: -- When in validation only mode raise the Validate_Enabled exception
496: --
497: IF p_validate THEN
502: -- never reached, so p_object_version_number is passed back unchanged.
503: --
504: p_object_version_number := l_object_version_number;
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 70);
507: --
508:
509: begin
510: per_org_structure_bk2.update_org_structure_a
562: --
563: -- Only set output warning arguments
564: -- (Any key or derived arguments must be set to null
565: -- when validation only mode is being used.)
566: hr_utility.set_location(' Leaving:'||l_proc, 80);
567: WHEN OTHERS THEN
568: --
569: -- A validation or unexpected error has occurred
570: ROLLBACK TO update_organization_structure;
571: --
572: -- set in out parameters and set out parameters
573: --
574: p_object_version_number := l_ovn;
575: hr_utility.set_location(' Leaving:'||l_proc, 90);
576: RAISE;
577: --
578: --
579: END update_organization_structure;
621: -- =============
622: --
623: -- Need to lock main table to maintain the locking ladder order
624: --
625: hr_utility.set_location( l_proc, 30);
626: per_ors_shd.lck ( p_organization_structure_id => p_organization_structure_id,
627: p_object_version_number => p_object_version_number );
628: hr_utility.set_location( l_proc, 40);
629: per_ors_del.del ( p_organization_structure_id => p_organization_structure_id,
624: --
625: hr_utility.set_location( l_proc, 30);
626: per_ors_shd.lck ( p_organization_structure_id => p_organization_structure_id,
627: p_object_version_number => p_object_version_number );
628: hr_utility.set_location( l_proc, 40);
629: per_ors_del.del ( p_organization_structure_id => p_organization_structure_id,
630: p_object_version_number => p_object_version_number );
631: --
632: --
629: per_ors_del.del ( p_organization_structure_id => p_organization_structure_id,
630: p_object_version_number => p_object_version_number );
631: --
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 60);
634: --
635: -- When in validation only mode raise the Validate_Enabled exception
636: --
637: IF p_validate THEN
667: -- Only set output warning arguments
668: -- (Any key or derived arguments must be set to null
669: -- when validation only mode is being used.)
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 80);
672: WHEN OTHERS THEN
673: --
674: -- A validation or unexpected error has occurred
675: ROLLBACK TO delete_organization_structure;
672: WHEN OTHERS THEN
673: --
674: -- A validation or unexpected error has occurred
675: ROLLBACK TO delete_organization_structure;
676: hr_utility.set_location(' Leaving:'||l_proc, 90);
677: RAISE;
678: --
679: END delete_organization_structure;
680: --