[Home] [Help]
547: -- Description:
548: -- This API covers the first step in terminating a period of placement and
549: -- all current assignments for a cwk, identified by person_id and date_start.
550: --
551: -- You can use the API to set the actual termination date, the last standard
552: -- process date, the new assignment status and the new person type.
553: --
554: -- Note: If you want to select only one current assignment to terminate you
555: -- should use the 'actual_termination_cwk_asg' API.
580: -- Element entries for the assignment that have an element
581: -- termination rule of 'Final Close' are not modified by this API.
582: -- These entries are modified by the 'final_process_placement' API.
583: --
584: -- For a US legislation, the element termination rule of 'Last Standard
585: -- Process' is not used. You must set the p_last_standard_process_date
586: -- parameter to null.
587: --
588: -- For non-US legislations, element entries for the
581: -- termination rule of 'Final Close' are not modified by this API.
582: -- These entries are modified by the 'final_process_placement' API.
583: --
584: -- For a US legislation, the element termination rule of 'Last Standard
585: -- Process' is not used. You must set the p_last_standard_process_date
586: -- parameter to null.
587: --
588: -- For non-US legislations, element entries for the
589: -- assignment that have an element termination rule of 'Last Standard
585: -- Process' is not used. You must set the p_last_standard_process_date
586: -- parameter to null.
587: --
588: -- For non-US legislations, element entries for the
589: -- assignment that have an element termination rule of 'Last Standard
590: -- Process' are date effectively deleted using the value specified
591: -- by p_last_standard_process_date. If no value is specified
592: -- the API defaults the date according to the following rules:
593: -- If no assignments include a payroll, the entries are deleted as
587: --
588: -- For non-US legislations, element entries for the
589: -- assignment that have an element termination rule of 'Last Standard
590: -- Process' are date effectively deleted using the value specified
591: -- by p_last_standard_process_date. If no value is specified
592: -- the API defaults the date according to the following rules:
593: -- If no assignments include a payroll, the entries are deleted as
594: -- of the actual termination date.
595: -- If one assignment includes a payroll, the entries are deleted
608: -- There must be no date-effective changes to the Person record after the
609: -- actual_termination_date.
610: -- There must be no employee assignments in this period of placement with an
611: -- initial start date on or after the actual_termination_date.
612: -- For a US legislation the last standard process date must be null.
613: -- For non-US legislations the last standard process date must be on or
614: -- after the actual termination date.
615: -- The person type, p_person_type_id, must exist for the same business group
616: -- as the person, must be active and must have a system type of EX_CWK.
609: -- actual_termination_date.
610: -- There must be no employee assignments in this period of placement with an
611: -- initial start date on or after the actual_termination_date.
612: -- For a US legislation the last standard process date must be null.
613: -- For non-US legislations the last standard process date must be on or
614: -- after the actual termination date.
615: -- The person type, p_person_type_id, must exist for the same business group
616: -- as the person, must be active and must have a system type of EX_CWK.
617: -- The assignment status, p_assignment_status_type_id, must exist for
630: -- p_date_start Yes date Date placement started.
631: -- p_object_version_number Yes number Version number of the
632: -- period of placement.
633: -- p_actual_termination_date Yes date Actual termination date
634: -- p_last_standard_process_date No date Last standard process date
635: -- p_person_type_id No number Person type
636: -- p_assignment_status_type_id No number Assignment status
637: --
638: -- Post Success:
644: -- the new version number of the
645: -- updated period of placement record.
646: -- If p_validate is true, set to the
647: -- same value you passed in.
648: -- p_last_standard_process_date date If p_validate is false, set to
649: -- the derived last standard process
650: -- date. If p_validate is true, set
651: -- to the same value you passed in.
652: -- p_supervisor_warning boolean Set to true if this person is a
645: -- updated period of placement record.
646: -- If p_validate is true, set to the
647: -- same value you passed in.
648: -- p_last_standard_process_date date If p_validate is false, set to
649: -- the derived last standard process
650: -- date. If p_validate is true, set
651: -- to the same value you passed in.
652: -- p_supervisor_warning boolean Set to true if this person is a
653: -- supervisor for another assignment,
710: ,p_person_id in number
711: ,p_date_start in date
712: ,p_object_version_number in out nocopy number
713: ,p_actual_termination_date in date
714: ,p_last_standard_process_date in out nocopy date
715: ,p_person_type_id in number default hr_api.g_number
716: ,p_assignment_status_type_id in number default hr_api.g_number
717: ,p_termination_reason in varchar2 default hr_api.g_varchar2
718: ,p_supervisor_warning out nocopy boolean
741: -- should use the 'final_process_cwk_asg' API.
742: --
743: -- If a final process date is not specified, the API derived the value.
744: -- For a US legislation, it uses the actual termination date.
745: -- For non-US legislations, it uses the last standard process date.
746: --
747: -- If you want to change the final process date after it has been
748: -- entered, you must cancel the termination and then reapply the termination
749: -- as of the new date.
767: -- date.
768: -- For a US legislation there must be no COBRA coverage benefits after
769: -- the final process date.
770: -- For non-US legislations the final process date must not be earlier than
771: -- the last standard process date.
772: --
773: -- In Parameters:
774: -- Name Reqd Type Description
775: -- p_validate No boolean If true, the database
886: * @param p_assignment_status_type_id Status of a contingent worker in a
887: * specific assignment.
888: * @param p_actual_termination_date Actual termination date.
889: * @param p_final_process_date Obsolete parameter, do not use.
890: * @param p_last_standard_process_date Obsolete parameter, do not use.
891: * @param p_termination_reason Termination Reason. Valid values are defined by
892: * the HR_CWK_TERMINATION_REASONS lookup type.
893: * @param p_projected_termination_date Projected termination date.
894: * @param p_attribute_category This context value determines which flexfield
1005: payroll support for contingent workers is introduced. Setting them has
1006: no impact.
1007: */
1008: ,p_final_process_date in out nocopy date
1009: ,p_last_standard_process_date in out nocopy date
1010:
1011: ,p_termination_reason in varchar2 default hr_api.g_varchar2
1012: ,p_projected_termination_date in date default hr_api.g_date
1013: ,p_attribute_category in varchar2 default hr_api.g_varchar2