[Home] [Help]
889:
890: l_Create_NSI BOOLEAN;--Flag to Control Creation of NSI Record
891: l_Multiple_NSI BOOLEAN;--Flag to Control Creation of Multiple NSI Record
892: l_Asg_NSI_Rec_Count NUMBER;
893: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
894: l_utab_row_value VARCHAR2(100);
895: l_utab_cib_value VARCHAR2(100);
896: l_Starter_Flag VARCHAR2(50);
897:
1541: -- Create Archive Assignment Action for Assignment
1542: IF l_Prev_Assignment_ID IS NULL
1543: OR l_Prev_Assignment_ID <> l_Assignment_ID
1544: OR l_asg_act_id IS NULL THEN
1545: SELECT pay_assignment_actions_s.NEXTVAL
1546: INTO l_asg_act_id
1547: FROM dual;
1548: --
1549: -- Create the archive assignment action
1745: and nl_ee_nsi1.effective_date < lp_nsi_process_date;
1746: v_csr_ee_prev_nsi csr_ee_prev_nsi%ROWTYPE;
1747:
1748:
1749: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1750: l_action_info_id pay_action_information.action_information_id%TYPE;
1751: l_ovn pay_action_information.object_version_number%TYPE;
1752: l_withdrawn_action_count NUMBER :=0;
1753: BEGIN
1767: p_Withdraw_New_Hire:= TRUE;
1768: END IF;
1769: -- Create Archive Assignment Action for Assignment
1770: IF l_asg_act_id IS NULL THEN
1771: SELECT pay_assignment_actions_s.NEXTVAL
1772: INTO l_asg_act_id
1773: FROM dual;
1774: --
1775: -- Create the archive assignment action
1970:
1971:
1972: l_action_info_id pay_action_information.action_information_id%TYPE;
1973: l_ovn pay_action_information.object_version_number%TYPE;
1974: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE;
1975:
1976: l_Create_NSI BOOLEAN;--Flag to Control Creation of NSI Record
1977: v_Skip_Asg BOOLEAN;--Flag to control if processed asg can be skipped
1978: l_Withdraw_New_Hire BOOLEAN;--Flag returned by Withdraw Asg Proc if a Notif a=1 is withdrawn