[Home] [Help]
69: l_effective_start_date pay_run_types_f.effective_start_date%TYPE;
70: l_effective_end_date pay_run_types_f.effective_end_date%TYPE;
71: --
72: begin
73: hr_utility.set_location('Entering:'|| l_proc, 10);
74: --
75: -- Issue a savepoint
76: --
77: savepoint create_run_type;
83: --
84: -- Truncate the time portion from all IN date parameters
85: --
86: l_effective_date := trunc(p_effective_date);
87: hr_utility.set_location(l_proc, 20);
88: --
89: -- Call Before Process User Hook
90: --
91: begin
136: (p_module_name => 'create_run_type'
137: ,p_hook_type => 'BP'
138: );
139: end;
140: hr_utility.set_location(l_proc, 30);
141: --
142: -- Validation in addition to Row Handlers
143: --
144: hr_utility.set_location(l_proc, 40);
140: hr_utility.set_location(l_proc, 30);
141: --
142: -- Validation in addition to Row Handlers
143: --
144: hr_utility.set_location(l_proc, 40);
145: --
146: -- Process Logic
147: --
148: -- Call the row handler
191: ,p_effective_start_date => l_effective_start_date
192: ,p_effective_end_date => l_effective_end_date
193: );
194: --
195: hr_utility.set_location(l_proc, 50);
196: --
197: -- Create the translation rows
198: --
199: pay_rtt_ins.ins_tl(p_language_code => l_language_code
256: (p_module_name => 'create_run_type_a'
257: ,p_hook_type => 'AP'
258: );
259: end;
260: hr_utility.set_location(l_proc, 60);
261: --
262: -- When in validation only mode raise the Validate_Enabled exception
263: --
264: if p_validate then
271: p_effective_start_date := l_effective_start_date;
272: p_effective_end_date := l_effective_end_date;
273: p_object_version_number := l_object_version_number;
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 70);
276: exception
277: when hr_api.validate_enabled then
278: --
279: -- As the Validate_Enabled exception has been raised
288: p_run_type_id := null;
289: p_object_version_number := null;
290: p_effective_start_date := null;
291: p_effective_end_date := null;
292: hr_utility.set_location(' Leaving:'||l_proc, 80);
293: when others then
294: --
295: -- A validation or unexpected error has occured
296: --
295: -- A validation or unexpected error has occured
296: --
297: rollback to create_run_type;
298: raise;
299: hr_utility.set_location(' Leaving:'||l_proc, 90);
300: end create_run_type;
301: --
302: -- ----------------------------------------------------------------------------
303: -- |--------------------------< update_run_type >-----------------------------|
365: --
366: l_object_version_number pay_run_types_f.object_version_number%TYPE;
367: --
368: begin
369: hr_utility.set_location('Entering:'|| l_proc, 10);
370: --
371: -- Issue a savepoint and assign in-out parameters to local variable
372: --
373: l_object_version_number := p_object_version_number;
380: --
381: -- Truncate the time portion from all IN date parameters
382: --
383: l_effective_date := trunc(p_effective_date);
384: hr_utility.set_location(l_proc, 20);
385: --
386: -- Call Before Process User Hook
387: --
388: begin
434: (p_module_name => 'update_run_type'
435: ,p_hook_type => 'BP'
436: );
437: end;
438: hr_utility.set_location(l_proc, 30);
439: --
440: -- Validation in addition to Row Handlers
441: --
442: hr_utility.set_location(l_proc, 40);
438: hr_utility.set_location(l_proc, 30);
439: --
440: -- Validation in addition to Row Handlers
441: --
442: hr_utility.set_location(l_proc, 40);
443: --
444: -- Process Logic
445: --
446: -- Call the row handler
486: ,p_effective_start_date => l_effective_start_date
487: ,p_effective_end_date => l_effective_end_date
488: );
489: --
490: hr_utility.set_location(l_proc, 50);
491: --
492: -- Call the upd tl table
493: --
494: pay_rtt_upd.upd_tl
550: (p_module_name => 'update_run_type_a'
551: ,p_hook_type => 'AP'
552: );
553: end;
554: hr_utility.set_location(l_proc, 60);
555: --
556: -- When in validation only mode raise the Validate_Enabled exception
557: --
558: if p_validate then
564: p_effective_start_date := l_effective_start_date;
565: p_effective_end_date := l_effective_end_date;
566: p_object_version_number := p_object_version_number;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 70);
569: exception
570: when hr_api.validate_enabled then
571: --
572: -- As the Validate_Enabled exception has been raised
580: --
581: p_object_version_number := l_object_version_number;
582: p_effective_start_date := null;
583: p_effective_end_date := null;
584: hr_utility.set_location(' Leaving:'||l_proc, 80);
585: when others then
586: --
587: -- A validation or unexpected error has occured
588: --
587: -- A validation or unexpected error has occured
588: --
589: rollback to update_run_type;
590: raise;
591: hr_utility.set_location(' Leaving:'||l_proc, 90);
592: end update_run_type;
593: -- ----------------------------------------------------------------------------
594: -- |----------------------------< delete_run_type >---------------------------|
595: -- ----------------------------------------------------------------------------
618: l_validation_end_date date;
619: l_object_version_number pay_run_types_f.object_version_number%type;
620: --
621: begin
622: hr_utility.set_location('Entering:'|| l_proc, 5);
623: --
624: -- Issue a savepoint and assign in-out parameters to local variable
625: --
626: savepoint delete_run_type;
625: --
626: savepoint delete_run_type;
627: l_object_version_number := p_object_version_number;
628: --
629: hr_utility.set_location(l_proc, 10);
630: --
631: l_effective_date := trunc(p_effective_date);
632: --
633: -- Call Before Process User Hook
648: ,p_hook_type => 'BP'
649: );
650: end;
651: --
652: hr_utility.set_location(l_proc, 20);
653: --
654: -- Validation in addition to Row Handlers
655: --
656: hr_utility.set_location(l_proc, 30);
652: hr_utility.set_location(l_proc, 20);
653: --
654: -- Validation in addition to Row Handlers
655: --
656: hr_utility.set_location(l_proc, 30);
657: --
658: -- Lock the non-translated table row handler for ZAP datetrack delete mode
659: --
660: if p_datetrack_delete_mode = hr_api.g_zap then
683: ,p_effective_start_date => l_effective_start_date
684: ,p_effective_end_date => l_effective_end_date
685: );
686: --
687: hr_utility.set_location(l_proc, 50);
688: --
689: -- Call After Process User Hook
690: --
691: begin
700: ,p_effective_end_date => l_effective_end_date
701: );
702: --
703: end;
704: hr_utility.set_location(l_proc, 60);
705: --
706: -- When in validation only mode raise the Validate_Enabled exception
707: --
708: if p_validate then
714: p_object_version_number := p_object_version_number;
715: p_effective_start_date := l_effective_start_date;
716: p_effective_end_date := l_effective_end_date;
717: --
718: hr_utility.set_location(l_proc, 70);
719: exception
720: when hr_api.validate_enabled then
721: --
722: -- As the Validate_Enabled exception has been raised
737: -- A validation or unexpected error has occurred
738: --
739: ROLLBACK TO delete_run_type;
740: raise;
741: hr_utility.set_location(' Leaving:'||l_proc, 80);
742: --
743: end delete_run_type;
744: -- ----------------------------------------------------------------------------
745: end pay_run_type_api;