[Home] [Help]
439: WHEN OTHERS THEN
440: hr_utility.set_location('SQLERRM '||SQLERRM,350);
441:
442: -- Return cursor that selects no rows
443: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
444: END RANGE_CODE;
445:
446: /*-------------------------------------------------------------------------------
447: |Name : ARCHIVE_NL_NSI_EE_DETAILS |
722: PAY_NL_SI_PKG.Get_Si_Status(lp_assignment_id,lp_effective_date,'ZW') zw_si_status
723: ,PAY_NL_SI_PKG.Get_Si_Status(lp_assignment_id,lp_effective_date,'WW') ww_si_status
724: ,PAY_NL_SI_PKG.Get_Si_Status(lp_assignment_id,lp_effective_date,'WAO') wao_si_status
725: ,PAY_NL_SI_PKG.Get_Si_Status(lp_assignment_id,lp_effective_date,'ZFW') zfw_si_status
726: FROM dual ;
727: v_csr_ee_siinfo csr_ee_siinfo%ROWTYPE;
728:
729: -- Cursor to Determine the SI Provider for the Various SI Types
730: -- as on Effective Date
743: ,DECODE(lp_zw_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'ZW',lp_assignment_id)) zw_er_org_id
744: ,DECODE(lp_ww_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'WEWE',lp_assignment_id)) ww_er_org_id
745: ,DECODE(lp_wao_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'WAOD',lp_assignment_id)) wao_er_org_id
746: ,DECODE(lp_zfw_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'ZFW',lp_assignment_id)) zfw_er_org_id
747: FROM DUAL;
748: v_csr_ee_si_prov_info csr_ee_si_prov_info%ROWTYPE;
749:
750:
751: --Select EE Info : Name/SOFI Number
931: l_last_nsi_min_notify_date := p_lst_nsi_process_date;
932:
933: SELECT LEAST(NVL(v_csr_ee_lat_nsi.notify_a_date,v_csr_ee_lat_nsi.notify_b_date),
934: NVL(v_csr_ee_lat_nsi.notify_b_date,v_csr_ee_lat_nsi.notify_a_date))
935: INTO l_last_nsi_min_notify_date FROM DUAL;
936: END IF;
937: hr_utility.set_location(' l_last_nsi_min_notify_date '||l_last_nsi_min_notify_date,350);
938:
939: --Determine EE Termination Details
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
1550: --
1551: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);
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
1776: --
1777: hr_nonrun_asact.insact(l_asg_act_id,p_assignment_id, p_payroll_action_id,p_chunk,NULL);
1891: AND pose.org_structure_version_id =lp_structure_version_id
1892: START WITH pose.organization_id_parent=lp_employer_id
1893: AND pose.org_structure_version_id =lp_structure_version_id
1894: UNION
1895: SELECT lp_employer_id FROM DUAL
1896: )
1897: and scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
1898: and ((lp_nsi_process_date >= paa.effective_start_date AND lp_nsi_process_date <= paa.effective_end_date)
1899: or (lp_nsi_process_date >= pap.effective_start_date AND lp_nsi_process_date <= pap.effective_end_date))
1917: ,DECODE(lp_zw_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'ZW',lp_assignment_id)) zw_er_org_id
1918: ,DECODE(lp_ww_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'WEWE',lp_assignment_id)) ww_er_org_id
1919: ,DECODE(lp_wao_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'WAOD',lp_assignment_id)) wao_er_org_id
1920: ,DECODE(lp_zfw_si_status,null,null,HR_NL_ORG_INFO.Get_ER_SI_Prov_HR_Org_ID(lp_organization_id,'ZFW',lp_assignment_id)) zfw_er_org_id
1921: FROM DUAL;
1922: v_csr_ee_si_prov_info csr_ee_si_prov_info%ROWTYPE;
1923:
1924: --Select the Last NSI Record Proces Date for comparison
1925: --to determine if a NSI Record needs to be generated or not