82: l_start_date date;
83: l_end_date date;
84:
85: begin
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: --
88: -- Issue a savepoint
89: --
90: savepoint create_service_history_period;
92: -- Truncate the time portion from all IN date parameters
93: --
94: l_start_date := trunc(p_start_date);
95: l_end_date := trunc(p_end_date);
96: hr_utility.set_location(l_proc, 20);
97: --
98: -- Call Before Process User Hook
99: --
100: begin
161: (p_module_name => 'create_service_history_period'
162: ,p_hook_type => 'BP'
163: );
164: end;
165: hr_utility.set_location(l_proc, 30);
166: --
167: -- Validation in addition to Row Handlers
168: --
169:
168: --
169:
170:
171:
172: hr_utility.set_location(l_proc, 40);
173: --
174: -- Process Logic
175: --
176:
234: ,p_shp_information19 => p_shp_information19
235: ,p_shp_information20 => p_shp_information20
236: );
237:
238: hr_utility.set_location(l_proc, 50);
239: --
240: -- Call After Process User Hook
241: --
242: begin
305: (p_module_name => 'create_service_history_period'
306: ,p_hook_type => 'AP'
307: );
308: end;
309: hr_utility.set_location(l_proc, 60);
310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then
318: --
319: p_service_history_period_id := l_service_history_period_id;
320: p_object_version_number := l_object_version_number;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
333: -- when validation only mode is being used.)
334: --
335: p_service_history_period_id := null;
336: p_object_version_number := null;
337: hr_utility.set_location(' Leaving:'||l_proc, 80);
338: when others then
339: --
340: -- A validation or unexpected error has occured
341: --
341: --
342: rollback to create_service_history_period;
343: p_service_history_period_id := null;
344: p_object_version_number := null;
345: hr_utility.set_location(' Leaving:'||l_proc, 90);
346: raise;
347: end create_service_history_period;
348: --
349: -- ----------------------------------------------------------------------------
419: l_start_date date;
420: l_end_date date;
421:
422: begin
423: hr_utility.set_location('Entering:'|| l_proc, 10);
424: --
425: -- Issue a savepoint
426: --
427: savepoint update_service_history_period;
429: -- Truncate the time portion from all IN date parameters
430: --
431: l_start_date := trunc(p_start_date);
432: l_end_date := trunc(p_end_date);
433: hr_utility.set_location(l_proc, 20);
434: --
435: -- Call Before Process User Hook
436: --
437: begin
499: (p_module_name => 'update_service_history_period'
500: ,p_hook_type => 'BP'
501: );
502: end;
503: hr_utility.set_location(l_proc, 30);
504: --
505: -- Validation in addition to Row Handlers
506: --
507:
506: --
507:
508:
509:
510: hr_utility.set_location(l_proc, 40);
511: --
512: -- Process Logic
513: --
514: l_object_version_number := p_object_version_number;
572: ,p_shp_information19 => p_shp_information19
573: ,p_shp_information20 => p_shp_information20
574: );
575:
576: hr_utility.set_location(l_proc, 50);
577: --
578: -- Call After Process User Hook
579: --
580: begin
642: (p_module_name => 'update_service_history_period'
643: ,p_hook_type => 'AP'
644: );
645: end;
646: hr_utility.set_location(l_proc, 60);
647: --
648: -- When in validation only mode raise the Validate_Enabled exception
649: --
650: if p_validate then
654: -- Set all output arguments
655: --
656: p_object_version_number := l_object_version_number;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc, 70);
659: exception
660: when hr_api.validate_enabled then
661: --
662: -- As the Validate_Enabled exception has been raised
668: -- (Any key or derived arguments must be set to null
669: -- when validation only mode is being used.)
670: --
671: p_object_version_number := null;
672: hr_utility.set_location(' Leaving:'||l_proc, 80);
673: when others then
674: --
675: -- A validation or unexpected error has occured
676: --
675: -- A validation or unexpected error has occured
676: --
677: rollback to update_service_history_period;
678: p_object_version_number := l_object_version_number;
679: hr_utility.set_location(' Leaving:'||l_proc, 90);
680: raise;
681: end update_service_history_period;
682: --
683: -- ----------------------------------------------------------------------------
696:
697: l_proc varchar2(72) := g_package||'delete_service_history_period';
698:
699: begin
700: hr_utility.set_location('Entering:'|| l_proc, 10);
701: --
702: -- Issue a savepoint
703: --
704: savepoint delete_service_history_period;
702: -- Issue a savepoint
703: --
704: savepoint delete_service_history_period;
705: --
706: hr_utility.set_location(l_proc, 20);
707: --
708: -- Call Before Process User Hook
709: --
710: begin
718: (p_module_name => 'delete_service_history_period'
719: ,p_hook_type => 'BP'
720: );
721: end;
722: hr_utility.set_location(l_proc, 30);
723: --
724: -- Validation in addition to Row Handlers
725: --
726:
725: --
726:
727:
728:
729: hr_utility.set_location(l_proc, 40);
730: --
731: -- Process Logic
732: --
733:
736: p_service_history_period_id => p_service_history_period_id
737: ,p_object_version_number => p_object_version_number
738: );
739:
740: hr_utility.set_location(l_proc, 50);
741: --
742: -- Call After Process User Hook
743: --
744: begin
752: (p_module_name => 'delete_service_history_period'
753: ,p_hook_type => 'AP'
754: );
755: end;
756: hr_utility.set_location(l_proc, 60);
757: --
758: -- When in validation only mode raise the Validate_Enabled exception
759: --
760: if p_validate then
763: --
764: -- Set all output arguments
765: --
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 70);
768: exception
769: when hr_api.validate_enabled then
770: --
771: -- As the Validate_Enabled exception has been raised
776: -- Only set output warning arguments
777: -- (Any key or derived arguments must be set to null
778: -- when validation only mode is being used.)
779: --
780: hr_utility.set_location(' Leaving:'||l_proc, 80);
781: when others then
782: --
783: -- A validation or unexpected error has occured
784: --
782: --
783: -- A validation or unexpected error has occured
784: --
785: rollback to delete_service_history_period;
786: hr_utility.set_location(' Leaving:'||l_proc, 90);
787: raise;
788: end delete_service_history_period;
789: --
790: end pqp_shp_api;