207: nvl(end_date-ame_util.oneSecond,SYSDATE);
208:
209: Begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: hr_api.mandatory_arg_error(p_api_name => l_proc
212: ,p_argument => 'APPROVAL_GROUP_ID'
213: ,p_argument_value => p_approval_group_id
214: );
215: -- Check if the group item has members of approver type other than 'PER'
319: and p_effective_date between t.start_date
320: and (t.end_date - ame_util.oneSecond);
321: Begin
322: hr_utility.set_location('Entering:'||l_proc,10);
323: hr_api.mandatory_arg_error(p_api_name => l_proc
324: ,p_argument => 'APPROVAL_GROUP_ID'
325: ,p_argument_value => p_approval_group_id
326: );
327: -- Check if the approval_group exists
385: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_NAME';
386:
387: Begin
388: hr_utility.set_location('Entering:'||l_proc,10);
389: hr_api.mandatory_arg_error(p_api_name => l_proc
390: ,p_argument => 'PARAMETER_NAME'
391: ,p_argument_value => p_parameter_name
392: );
393: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
467: and rownum < 2;
468:
469: Begin
470: hr_utility.set_location('Entering:'||l_proc,10);
471: hr_api.mandatory_arg_error(p_api_name => l_proc
472: ,p_argument => 'PARAMETER'
473: ,p_argument_value => p_parameter
474: );
475: -- Check if the parameter corresponds to a valid group in ame_approval_groups
565: --
566: l_proc varchar2(72) := g_package || 'CHK_ORDER_NUMBER';
567: Begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: hr_api.mandatory_arg_error(p_api_name => l_proc
570: ,p_argument => 'ORDER_NUMBER'
571: ,p_argument_value => p_order_number
572: );
573: -- check if order_number is negative
634: and t.parameter = p_parameter
635: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
636: Begin
637: hr_utility.set_location('Entering:'||l_proc,10);
638: hr_api.mandatory_arg_error(p_api_name => l_proc
639: ,p_argument => 'APPROVAL_GROUP_ID'
640: ,p_argument_value => p_approval_group_id
641: );
642: hr_api.mandatory_arg_error(p_api_name => l_proc
638: hr_api.mandatory_arg_error(p_api_name => l_proc
639: ,p_argument => 'APPROVAL_GROUP_ID'
640: ,p_argument_value => p_approval_group_id
641: );
642: hr_api.mandatory_arg_error(p_api_name => l_proc
643: ,p_argument => 'PARAMETER_NAME'
644: ,p_argument_value => p_parameter_name
645: );
646: hr_api.mandatory_arg_error(p_api_name => l_proc
642: hr_api.mandatory_arg_error(p_api_name => l_proc
643: ,p_argument => 'PARAMETER_NAME'
644: ,p_argument_value => p_parameter_name
645: );
646: hr_api.mandatory_arg_error(p_api_name => l_proc
647: ,p_argument => 'PARAMETER'
648: ,p_argument_value => p_parameter
649: );
650: -- check if the row represents a unique member for a group.
737: --
738: -- ORDER_NUMBER is non-updateable if the group is seeded
739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc
745: ,p_argument => 'ORDER_NUMBER'
738: -- ORDER_NUMBER is non-updateable if the group is seeded
739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc
745: ,p_argument => 'ORDER_NUMBER'
746: ,p_base_table => ame_gpi_shd.g_tab_nam
739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc
745: ,p_argument => 'ORDER_NUMBER'
746: ,p_base_table => ame_gpi_shd.g_tab_nam
747: );
747: );
748: end if;
749: -- APPROVAL_GROUP_ID is non-updateable.
750:
751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
753: hr_api.argument_changed_error
754: (p_api_name => l_proc
755: ,p_argument => 'APPROVAL_GROUP_ID'
748: end if;
749: -- APPROVAL_GROUP_ID is non-updateable.
750:
751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
753: hr_api.argument_changed_error
754: (p_api_name => l_proc
755: ,p_argument => 'APPROVAL_GROUP_ID'
756: ,p_base_table => ame_gpi_shd.g_tab_nam
749: -- APPROVAL_GROUP_ID is non-updateable.
750:
751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
753: hr_api.argument_changed_error
754: (p_api_name => l_proc
755: ,p_argument => 'APPROVAL_GROUP_ID'
756: ,p_base_table => ame_gpi_shd.g_tab_nam
757: );
758: end if;
759:
760: -- PARAMETER_NAME is non-updateable.
761:
762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
764: hr_api.argument_changed_error
765: (p_api_name => l_proc
766: ,p_argument => 'PARAMETER_NAME'
759:
760: -- PARAMETER_NAME is non-updateable.
761:
762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
764: hr_api.argument_changed_error
765: (p_api_name => l_proc
766: ,p_argument => 'PARAMETER_NAME'
767: ,p_base_table => ame_gpi_shd.g_tab_nam
760: -- PARAMETER_NAME is non-updateable.
761:
762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
764: hr_api.argument_changed_error
765: (p_api_name => l_proc
766: ,p_argument => 'PARAMETER_NAME'
767: ,p_base_table => ame_gpi_shd.g_tab_nam
768: );
769: end if;
770:
771: -- PARAMETER is non-updateable.
772:
773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
775: hr_api.argument_changed_error
776: (p_api_name => l_proc
777: ,p_argument => 'PARAMETER'
770:
771: -- PARAMETER is non-updateable.
772:
773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
775: hr_api.argument_changed_error
776: (p_api_name => l_proc
777: ,p_argument => 'PARAMETER'
778: ,p_base_table => ame_gpi_shd.g_tab_nam
771: -- PARAMETER is non-updateable.
772:
773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
775: hr_api.argument_changed_error
776: (p_api_name => l_proc
777: ,p_argument => 'PARAMETER'
778: ,p_base_table => ame_gpi_shd.g_tab_nam
779: );
812: --
813: -- {End Of Comments}
814: -- ----------------------------------------------------------------------------
815: Procedure dt_update_validate
816: (p_approval_group_id in number default hr_api.g_number
817: ,p_datetrack_mode in varchar2
818: ,p_validation_start_date in date
819: ,p_validation_end_date in date
820: ) Is
824: Begin
825: --
826: -- Ensure that the p_datetrack_mode argument is not null
827: --
828: hr_api.mandatory_arg_error
829: (p_api_name => l_proc
830: ,p_argument => 'datetrack_mode'
831: ,p_argument_value => p_datetrack_mode
832: );
834: -- Mode will be valid, as this is checked at the start of the upd.
835: --
836: -- Ensure the arguments are not null
837: --
838: hr_api.mandatory_arg_error
839: (p_api_name => l_proc
840: ,p_argument => 'validation_start_date'
841: ,p_argument_value => p_validation_start_date
842: );
840: ,p_argument => 'validation_start_date'
841: ,p_argument_value => p_validation_start_date
842: );
843: --
844: /*hr_api.mandatory_arg_error
845: (p_api_name => l_proc
846: ,p_argument => 'validation_end_date'
847: ,p_argument_value => p_validation_end_date
848: );*/
906: Begin
907: --
908: -- Ensure that the p_datetrack_mode argument is not null
909: --
910: hr_api.mandatory_arg_error
911: (p_api_name => l_proc
912: ,p_argument => 'datetrack_mode'
913: ,p_argument_value => p_datetrack_mode
914: );
915: --
916: -- Only perform the validation if the datetrack mode is either
917: -- DELETE or ZAP
918: --
919: If (p_datetrack_mode = hr_api.g_delete or
920: p_datetrack_mode = hr_api.g_zap) then
921: --
922: --
923: -- Ensure the arguments are not null
916: -- Only perform the validation if the datetrack mode is either
917: -- DELETE or ZAP
918: --
919: If (p_datetrack_mode = hr_api.g_delete or
920: p_datetrack_mode = hr_api.g_zap) then
921: --
922: --
923: -- Ensure the arguments are not null
924: --
921: --
922: --
923: -- Ensure the arguments are not null
924: --
925: hr_api.mandatory_arg_error
926: (p_api_name => l_proc
927: ,p_argument => 'validation_start_date'
928: ,p_argument_value => p_validation_start_date
929: );
927: ,p_argument => 'validation_start_date'
928: ,p_argument_value => p_validation_start_date
929: );
930: --
931: /*hr_api.mandatory_arg_error
932: (p_api_name => l_proc
933: ,p_argument => 'validation_end_date'
934: ,p_argument_value => p_validation_end_date
935: );*/
933: ,p_argument => 'validation_end_date'
934: ,p_argument_value => p_validation_end_date
935: );*/
936: --
937: hr_api.mandatory_arg_error
938: (p_api_name => l_proc
939: ,p_argument => 'approval_group_item_id'
940: ,p_argument_value => p_approval_group_item_id
941: );