[Home] [Help]
690: -- Description:
691: -- This API covers the first step in terminating a period of placement and
692: -- all current assignments for a cwk, identified by person_id and date_start.
693: --
694: -- You can use the API to set the actual termination date, the last standard
695: -- process date, the new assignment status and the new person type.
696: --
697: -- Note: If you want to select only one current assignment to terminate you
698: -- should use the 'actual_termination_cwk_asg' API.
723: -- Element entries for the assignment that have an element
724: -- termination rule of 'Final Close' are not modified by this API.
725: -- These entries are modified by the 'final_process_placement' API.
726: --
727: -- For a US legislation, the element termination rule of 'Last Standard
728: -- Process' is not used. You must set the p_last_standard_process_date
729: -- parameter to null.
730: --
731: -- For non-US legislations, element entries for the
724: -- termination rule of 'Final Close' are not modified by this API.
725: -- These entries are modified by the 'final_process_placement' API.
726: --
727: -- For a US legislation, the element termination rule of 'Last Standard
728: -- Process' is not used. You must set the p_last_standard_process_date
729: -- parameter to null.
730: --
731: -- For non-US legislations, element entries for the
732: -- assignment that have an element termination rule of 'Last Standard
728: -- Process' is not used. You must set the p_last_standard_process_date
729: -- parameter to null.
730: --
731: -- For non-US legislations, element entries for the
732: -- assignment that have an element termination rule of 'Last Standard
733: -- Process' are date effectively deleted using the value specified
734: -- by p_last_standard_process_date. If no value is specified
735: -- the API defaults the date according to the following rules:
736: -- If no assignments include a payroll, the entries are deleted as
730: --
731: -- For non-US legislations, element entries for the
732: -- assignment that have an element termination rule of 'Last Standard
733: -- Process' are date effectively deleted using the value specified
734: -- by p_last_standard_process_date. If no value is specified
735: -- the API defaults the date according to the following rules:
736: -- If no assignments include a payroll, the entries are deleted as
737: -- of the actual termination date.
738: -- If one assignment includes a payroll, the entries are deleted
751: -- There must be no date-effective changes to the Person record after the
752: -- actual_termination_date.
753: -- There must be no employee assignments in this period of placement with an
754: -- initial start date on or after the actual_termination_date.
755: -- For a US legislation the last standard process date must be null.
756: -- For non-US legislations the last standard process date must be on or
757: -- after the actual termination date.
758: -- The person type, p_person_type_id, must exist for the same business group
759: -- as the person, must be active and must have a system type of EX_CWK.
752: -- actual_termination_date.
753: -- There must be no employee assignments in this period of placement with an
754: -- initial start date on or after the actual_termination_date.
755: -- For a US legislation the last standard process date must be null.
756: -- For non-US legislations the last standard process date must be on or
757: -- after the actual termination date.
758: -- The person type, p_person_type_id, must exist for the same business group
759: -- as the person, must be active and must have a system type of EX_CWK.
760: -- The assignment status, p_assignment_status_type_id, must exist for
773: -- p_date_start Yes date Date placement started.
774: -- p_object_version_number Yes number Version number of the
775: -- period of placement.
776: -- p_actual_termination_date Yes date Actual termination date
777: -- p_last_standard_process_date No date Last standard process date
778: -- p_person_type_id No number Person type
779: -- p_assignment_status_type_id No number Assignment status
780: --
781: -- Post Success:
787: -- the new version number of the
788: -- updated period of placement record.
789: -- If p_validate is true, set to the
790: -- same value you passed in.
791: -- p_last_standard_process_date date If p_validate is false, set to
792: -- the derived last standard process
793: -- date. If p_validate is true, set
794: -- to the same value you passed in.
795: -- p_supervisor_warning boolean Set to true if this person is a
788: -- updated period of placement record.
789: -- If p_validate is true, set to the
790: -- same value you passed in.
791: -- p_last_standard_process_date date If p_validate is false, set to
792: -- the derived last standard process
793: -- date. If p_validate is true, set
794: -- to the same value you passed in.
795: -- p_supervisor_warning boolean Set to true if this person is a
796: -- supervisor for another assignment,
853: ,p_person_id in number
854: ,p_date_start in date
855: ,p_object_version_number in out nocopy number
856: ,p_actual_termination_date in date
857: ,p_last_standard_process_date in out nocopy date
858: ,p_person_type_id in number default hr_api.g_number
859: ,p_assignment_status_type_id in number default hr_api.g_number
860: ,p_termination_reason in varchar2 default hr_api.g_varchar2
861: ,p_supervisor_warning out nocopy boolean
884: -- should use the 'final_process_cwk_asg' API.
885: --
886: -- If a final process date is not specified, the API derived the value.
887: -- For a US legislation, it uses the actual termination date.
888: -- For non-US legislations, it uses the last standard process date.
889: --
890: -- If you want to change the final process date after it has been
891: -- entered, you must cancel the termination and then reapply the termination
892: -- as of the new date.
910: -- date.
911: -- For a US legislation there must be no COBRA coverage benefits after
912: -- the final process date.
913: -- For non-US legislations the final process date must not be earlier than
914: -- the last standard process date.
915: --
916: -- In Parameters:
917: -- Name Reqd Type Description
918: -- p_validate No boolean If true, the database
1029: * @param p_assignment_status_type_id Status of a contingent worker in a
1030: * specific assignment.
1031: * @param p_actual_termination_date Actual termination date.
1032: * @param p_final_process_date Obsolete parameter, do not use.
1033: * @param p_last_standard_process_date Obsolete parameter, do not use.
1034: * @param p_termination_reason Termination Reason. Valid values are defined by
1035: * the HR_CWK_TERMINATION_REASONS lookup type.
1036: * @param p_projected_termination_date Projected termination date.
1037: * @param p_attribute_category This context value determines which flexfield
1148: payroll support for contingent workers is introduced. Setting them has
1149: no impact.
1150: */
1151: ,p_final_process_date in out nocopy date
1152: ,p_last_standard_process_date in out nocopy date
1153:
1154: ,p_termination_reason in varchar2 default hr_api.g_varchar2
1155: ,p_projected_termination_date in date default hr_api.g_date
1156: ,p_attribute_category in varchar2 default hr_api.g_varchar2