180: ,p_unemployment_cont_end_reason => p_unemployment_cont_end_reason
181: ,p_effective_date_warning => p_effective_date_warning
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_pl_sii_details'
187: ,p_hook_type => 'BP'
188: );
181: ,p_effective_date_warning => p_effective_date_warning
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_pl_sii_details'
187: ,p_hook_type => 'BP'
188: );
189: end;
252: ,p_effective_end_date => l_effective_end_date
253: ,p_effective_date_warning => p_effective_date_warning);
254:
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'create_pl_sii_details'
259: ,p_hook_type => 'AP'
260: );
253: ,p_effective_date_warning => p_effective_date_warning);
254:
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (p_module_name => 'create_pl_sii_details'
259: ,p_hook_type => 'AP'
260: );
261: end;
262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: -- Set all IN OUT and OUT parameters with out values
270: --
275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278: exception
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised
282: -- we must rollback to the savepoint
283: --
729: ,p_effective_date in date
730: ,p_datetrack_update_mode in varchar2
731: ,p_sii_details_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
730: ,p_datetrack_update_mode in varchar2
731: ,p_sii_details_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
731: ,p_sii_details_id in number
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
732: ,p_object_version_number in out nocopy number
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
733: ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
734: ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
735: ,p_pension_contribution in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
736: ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
737: ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
738: ,p_labor_contribution in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
739: ,p_health_contribution in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
740: ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
741: ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
749: ,p_effective_end_date out nocopy date
742: ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
749: ,p_effective_end_date out nocopy date
750: )
743: ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
744: ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
745: ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
746: ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
747: ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
748: ,p_effective_start_date out nocopy date
749: ,p_effective_end_date out nocopy date
750: )
751: is
888: ,p_unemployment_cont_end_reason => p_unemployment_cont_end_reason
889: ,p_object_version_number => l_object_version_number
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'update_pl_sii_details'
895: ,p_hook_type => 'BP'
896: );
889: ,p_object_version_number => l_object_version_number
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'update_pl_sii_details'
895: ,p_hook_type => 'BP'
896: );
897: end;
955: ,p_effective_end_date => l_effective_end_date
956: );
957:
958: exception
959: when hr_api.cannot_find_prog_unit then
960: hr_api.cannot_find_prog_unit_error
961: (p_module_name => 'update_pl_sii_details'
962: ,p_hook_type => 'AP'
963: );
956: );
957:
958: exception
959: when hr_api.cannot_find_prog_unit then
960: hr_api.cannot_find_prog_unit_error
961: (p_module_name => 'update_pl_sii_details'
962: ,p_hook_type => 'AP'
963: );
964: end;
965: --
966: -- When in validation only mode raise the Validate_Enabled exception
967: --
968: if p_validate then
969: raise hr_api.validate_enabled;
970: end if;
971: --
972: -- Set all IN OUT and OUT parameters with out values
973: --
977:
978: --
979: hr_utility.set_location(' Leaving:'||l_proc, 70);
980: exception
981: when hr_api.validate_enabled then
982: --
983: -- As the Validate_Enabled exception has been raised
984: -- we must rollback to the savepoint
985: --
1069: ,p_datetrack_delete_mode => p_datetrack_delete_mode
1070: ,p_object_version_number => p_object_version_number
1071: );
1072: exception
1073: when hr_api.cannot_find_prog_unit then
1074: hr_api.cannot_find_prog_unit_error
1075: (p_module_name => 'delete_pl_sii_details'
1076: ,p_hook_type => 'BP'
1077: );
1070: ,p_object_version_number => p_object_version_number
1071: );
1072: exception
1073: when hr_api.cannot_find_prog_unit then
1074: hr_api.cannot_find_prog_unit_error
1075: (p_module_name => 'delete_pl_sii_details'
1076: ,p_hook_type => 'BP'
1077: );
1078: end;
1106: ,p_effective_end_date => l_effective_end_date
1107: );
1108:
1109: exception
1110: when hr_api.cannot_find_prog_unit then
1111: hr_api.cannot_find_prog_unit_error
1112: (p_module_name => 'delete_pl_sii_details'
1113: ,p_hook_type => 'AP'
1114: );
1107: );
1108:
1109: exception
1110: when hr_api.cannot_find_prog_unit then
1111: hr_api.cannot_find_prog_unit_error
1112: (p_module_name => 'delete_pl_sii_details'
1113: ,p_hook_type => 'AP'
1114: );
1115: end;
1116: --
1117: -- When in validation only mode raise the Validate_Enabled exception
1118: --
1119: if p_validate then
1120: raise hr_api.validate_enabled;
1121: end if;
1122: --
1123: -- Set all IN OUT and OUT parameters with out values
1124: --
1129:
1130: --
1131: hr_utility.set_location(' Leaving:'||l_proc, 70);
1132: exception
1133: when hr_api.validate_enabled then
1134: --
1135: -- As the Validate_Enabled exception has been raised
1136: -- we must rollback to the savepoint
1137: --