587: ,p_request_id => p_request_id
588: ,p_cwb_audit_id => l_cwb_audit_id
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'create_audit_entry'
594: ,p_hook_type => 'BP'
595: );
588: ,p_cwb_audit_id => l_cwb_audit_id
589: );
590: exception
591: when hr_api.cannot_find_prog_unit then
592: hr_api.cannot_find_prog_unit_error
593: (p_module_name => 'create_audit_entry'
594: ,p_hook_type => 'BP'
595: );
596: end;
644: ,p_cwb_audit_id => l_cwb_audit_id
645: ,p_object_version_number => l_object_version_number
646: );
647: exception
648: when hr_api.cannot_find_prog_unit then
649: hr_api.cannot_find_prog_unit_error
650: (p_module_name => 'create_group_budget'
651: ,p_hook_type => 'AP'
652: );
645: ,p_object_version_number => l_object_version_number
646: );
647: exception
648: when hr_api.cannot_find_prog_unit then
649: hr_api.cannot_find_prog_unit_error
650: (p_module_name => 'create_group_budget'
651: ,p_hook_type => 'AP'
652: );
653: end;
654: --
655: -- When in validation only mode raise the Validate_Enabled exception
656: --
657: if p_validate then
658: raise hr_api.validate_enabled;
659: end if;
660: --
661: -- Set all IN OUT and OUT parameters with out values
662: --
665: if g_debug then
666: hr_utility.set_location(' Leaving:'||l_proc, 70);
667: end if;
668: exception
669: when hr_api.validate_enabled then
670: --
671: -- As the Validate_Enabled exception has been raised
672: -- we must rollback to the savepoint
673: --
700: ,p_group_per_in_ler_id in number
701: ,p_group_pl_id in number
702: ,p_lf_evt_ocrd_dt in date
703: ,p_pl_id in number
704: ,p_group_oipl_id in number default hr_api.g_number
705: ,p_audit_type_cd in varchar2
706: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
702: ,p_lf_evt_ocrd_dt in date
703: ,p_pl_id in number
704: ,p_group_oipl_id in number default hr_api.g_number
705: ,p_audit_type_cd in varchar2
706: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
703: ,p_pl_id in number
704: ,p_group_oipl_id in number default hr_api.g_number
705: ,p_audit_type_cd in varchar2
706: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
704: ,p_group_oipl_id in number default hr_api.g_number
705: ,p_audit_type_cd in varchar2
706: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
705: ,p_audit_type_cd in varchar2
706: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
706: ,p_old_val_varchar in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
714: ,p_supporting_information in varchar2 default hr_api.g_varchar2
707: ,p_new_val_varchar in varchar2 default hr_api.g_varchar2
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
714: ,p_supporting_information in varchar2 default hr_api.g_varchar2
715: ,p_request_id in number default hr_api.g_number
708: ,p_old_val_number in number default hr_api.g_number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
714: ,p_supporting_information in varchar2 default hr_api.g_varchar2
715: ,p_request_id in number default hr_api.g_number
716: ,p_object_version_number in out nocopy number
709: ,p_new_val_number in number default hr_api.g_number
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
714: ,p_supporting_information in varchar2 default hr_api.g_varchar2
715: ,p_request_id in number default hr_api.g_number
716: ,p_object_version_number in out nocopy number
717: ) is
710: ,p_old_val_date in date default hr_api.g_date
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
714: ,p_supporting_information in varchar2 default hr_api.g_varchar2
715: ,p_request_id in number default hr_api.g_number
716: ,p_object_version_number in out nocopy number
717: ) is
718: --
711: ,p_new_val_date in date default hr_api.g_date
712: ,p_date_stamp in date default hr_api.g_date
713: ,p_change_made_by_person_id in number default hr_api.g_number
714: ,p_supporting_information in varchar2 default hr_api.g_varchar2
715: ,p_request_id in number default hr_api.g_number
716: ,p_object_version_number in out nocopy number
717: ) is
718: --
719: -- Declare cursors and local variables
773: ,p_request_id => p_request_id
774: ,p_object_version_number => l_object_version_number
775: );
776: exception
777: when hr_api.cannot_find_prog_unit then
778: hr_api.cannot_find_prog_unit_error
779: (p_module_name => 'update_audit_entry'
780: ,p_hook_type => 'BP'
781: );
774: ,p_object_version_number => l_object_version_number
775: );
776: exception
777: when hr_api.cannot_find_prog_unit then
778: hr_api.cannot_find_prog_unit_error
779: (p_module_name => 'update_audit_entry'
780: ,p_hook_type => 'BP'
781: );
782: end;
864: ,p_request_id => p_request_id
865: ,p_object_version_number => l_object_version_number
866: );
867: exception
868: when hr_api.cannot_find_prog_unit then
869: hr_api.cannot_find_prog_unit_error
870: (p_module_name => 'update_audit_entry'
871: ,p_hook_type => 'AP'
872: );
865: ,p_object_version_number => l_object_version_number
866: );
867: exception
868: when hr_api.cannot_find_prog_unit then
869: hr_api.cannot_find_prog_unit_error
870: (p_module_name => 'update_audit_entry'
871: ,p_hook_type => 'AP'
872: );
873: end;
874: --
875: -- When in validation only mode raise the Validate_Enabled exception
876: --
877: if p_validate then
878: raise hr_api.validate_enabled;
879: end if;
880: --
881: -- Update is successful. So call the budget summary update.
882: --
887: if g_debug then
888: hr_utility.set_location(' Leaving:'||l_proc, 80);
889: end if;
890: exception
891: when hr_api.validate_enabled then
892: --
893: -- As the Validate_Enabled exception has been raised
894: -- we must rollback to the savepoint
895: --
953: (p_cwb_audit_id => p_cwb_audit_id
954: ,p_object_version_number => l_object_version_number
955: );
956: exception
957: when hr_api.cannot_find_prog_unit then
958: hr_api.cannot_find_prog_unit_error
959: (p_module_name => 'delete_audit_entry'
960: ,p_hook_type => 'BP'
961: );
954: ,p_object_version_number => l_object_version_number
955: );
956: exception
957: when hr_api.cannot_find_prog_unit then
958: hr_api.cannot_find_prog_unit_error
959: (p_module_name => 'delete_audit_entry'
960: ,p_hook_type => 'BP'
961: );
962: end;
979: (p_cwb_audit_id => p_cwb_audit_id
980: ,p_object_version_number => l_object_version_number
981: );
982: exception
983: when hr_api.cannot_find_prog_unit then
984: hr_api.cannot_find_prog_unit_error
985: (p_module_name => 'delete_audit_entry'
986: ,p_hook_type => 'AP'
987: );
980: ,p_object_version_number => l_object_version_number
981: );
982: exception
983: when hr_api.cannot_find_prog_unit then
984: hr_api.cannot_find_prog_unit_error
985: (p_module_name => 'delete_audit_entry'
986: ,p_hook_type => 'AP'
987: );
988: end;
989: --
990: -- When in validation only mode raise the Validate_Enabled exception
991: --
992: if p_validate then
993: raise hr_api.validate_enabled;
994: end if;
995: --
996: if g_debug then
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
996: if g_debug then
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
998: end if;
999: exception
1000: when hr_api.validate_enabled then
1001: --
1002: -- As the Validate_Enabled exception has been raised
1003: -- we must rollback to the savepoint
1004: --