This page (revision-2) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by kparrott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
2 26-Nov-2021 10:22 1 KB kparrott to previous
1 26-Nov-2021 10:22 1 KB kparrott to last

Page References

Incoming links Outgoing links
ASSIGNMENT LEAVE SPLITS...nobody
ASSIGNMENT LEAVE SPLITS

Version management

Difference between version and

At line 8 changed one line
This process is controlled by whether the customer has the trigger P2K_EASD_ARI in place or not. When in place and a new effective date split happens on the details of the Prime Assignment, a backend job will be launched from P2K_PEGEN.Schedule_Job using the DBMS_SCHEDULER functionality. NOTE: the record must have a date split or this will not work.
This process is controlled by whether the customer has the trigger P2K_EASD_ARI in place or not. When in place and a new effective date split happens on the details of the Prime Assignment, a backend job will be launched from P2K_PEGEN.Schedule_Job using the DBMS_SCHEDULER functionality. NOTE: the record must have a date split or this will not work.
At line 10 removed 2 lines
The job executes the procedure P2K_PEGEN.LeaveChangeCheck which will get the Status Type for the new record and for the record that expires one day prior to this new record and checks if one exists for a type of ‘A’ and one is a type of ‘L’ and if so, will call P2K_PEGEN.LeaveSplits.
P2K_PEGEN.LeaveSplits first turns off Work Flow by setting the P2K_PMWRKFLW.bypassWorkFlow flag to ‘TRUE’. Then it sets up and calls the procedure P2K_SMDSCOPY for each of the Non-Prime assignments that are not End Dated. The record is then updated with the new Change Reason and Employment Status. NOTE: This process will NOT touch future records, it will only split the record that exists at the date of the status change.
At line 12 added 2 lines
The job executes the procedure P2K_PEGEN.LeaveChangeCheck which will get the Status Type for the new record and for the record that expires one day prior to this new record and checks if one exists for a type of ‘A’ and one is a type of ‘L’ and if so, will call P2K_PEGEN.LeaveSplits. P2K_PEGEN.LeaveSplits first turns off Workflow by setting the P2K_PMWRKFLW.bypass WorkFlow flag to ‘TRUE’. Then it sets up and calls the procedure P2K_SMDSCOPY for each of the Non-Prime assignments that are not End Dated. The record is then updated with the new Change Reason and Employment Status. NOTE: This process will NOT touch future records, it will only split the record that exists at the date of the status change.
This page (revision-2) was last changed on 26-Nov-2021 10:22 by kparrottTop