[Home] [Help]
176:
177: CURSOR csr_arch_ref_no
178: IS
179: SELECT 1
180: FROM pay_action_information pai
181: ,pay_payroll_actions ppa
182: WHERE pai.action_information_category = 'IN_PF_BUSINESS_NUMBER'
183: AND pai.action_context_type = 'PA'
184: AND pai.action_information2 = g_arc_ref_no
381: CLOSE csr_pf_people;
382:
383: pay_in_utils.set_location(g_debug,'Assignment Id : '||p_assignment_id,15);
384:
385: pay_action_information_api.create_action_information
386: (p_action_context_id => p_arc_asg_action_id
387: ,p_action_context_type => 'AAP'
388: ,p_action_information_category => 'IN_PF_PERSON_DTLS'
389: ,p_source_id => p_run_asg_action_id
560:
561: CURSOR csr_chk_vpf(p_class VARCHAR2 )
562: IS
563: SELECT COUNT(*)
564: FROM pay_action_information
565: WHERE action_context_id = p_arc_asg_action_id
566: AND action_information1 = p_business_number
567: AND action_information_category = 'IN_PF_SALARY'
568: AND action_context_type = 'AAP'
593: pay_in_utils.set_location(g_debug,'balance_name: '||c_rec.balance_name,20);
594: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
595:
596: IF result_val <> 0 THEN
597: pay_action_information_api.create_action_information
598: (p_action_context_id => p_arc_asg_action_id
599: ,p_action_context_type => 'AAP'
600: ,p_action_information_category => 'IN_PF_SALARY'
601: ,p_source_id => p_run_asg_action_id
624: pay_in_utils.set_location(g_debug,'balance_name: '||rec_pf_balances_ptd.balance_name,20);
625: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
626:
627: IF result_val <> 0 THEN
628: pay_action_information_api.create_action_information
629: (p_action_context_id => p_arc_asg_action_id
630: ,p_action_context_type => 'AAP'
631: ,p_action_information_category => 'IN_PF_SALARY'
632: ,p_source_id => p_run_asg_action_id
652: OPEN csr_pf_vol_rate;
653: FETCH csr_pf_vol_rate INTO l_vol_pf_rate;
654: CLOSE csr_pf_vol_rate;
655:
656: pay_action_information_api.create_action_information
657: (p_action_context_id => p_arc_asg_action_id
658: ,p_action_context_type => 'AAP'
659: ,p_action_information_category => 'IN_PF_SALARY'
660: ,p_source_id => p_run_asg_action_id
803: OPEN csr_emp_name(l_representative);
804: FETCH csr_emp_name INTO l_representative_name;
805: CLOSE csr_emp_name ;
806:
807: pay_action_information_api.create_action_information
808: (p_action_context_id => p_arc_pay_action_id
809: ,p_action_context_type => 'PA'
810: ,p_action_information_category => 'IN_PF_ORG'
811: ,p_action_information1 => rec_pf_org.bus_no
829: WHERE payroll_action_id =p_arc_pay_action_id;
830:
831: pay_in_utils.set_location(g_debug,'Business Number : '||p_business_number,15);
832:
833: pay_action_information_api.create_action_information
834: (p_action_context_id => p_arc_pay_action_id
835: ,p_action_context_type => 'PA'
836: ,p_action_information_category => 'IN_PF_BUSINESS_NUMBER'
837: ,p_action_information1 => p_business_number
842: ,p_action_information_id => l_action_info_id
843: ,p_object_version_number => l_ovn
844: );
845:
846: pay_action_information_api.create_action_information
847: (p_action_context_id => p_arc_pay_action_id
848: ,p_action_context_type => 'PA'
849: ,p_action_information_category => 'IN_PF_ARC_REF_NUMBER'
850: ,p_action_information1 => g_return_type
1178:
1179: IF l_Challan_Ref IS NOT NULL
1180: THEN
1181: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_CHALLAN'||l_Challan_Ref,5);
1182: pay_action_information_api.create_action_information
1183: (p_action_context_id => p_arc_pay_action_id
1184: ,p_action_context_type => 'PA'
1185: ,p_action_information_category => 'IN_PF_CHALLAN'
1186: ,p_action_information1 => p_business_number
1212: IF l_14B_Challan_Ref IS NOT NULL
1213: THEN
1214:
1215: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_14B'||l_14B_Challan_Ref,6);
1216: pay_action_information_api.create_action_information
1217: (p_action_context_id => p_arc_pay_action_id
1218: ,p_action_context_type => 'PA'
1219: ,p_action_information_category => 'IN_PF_14B'
1220: ,p_action_information1 => l_14B_Prev_Mth
1232:
1233: IF l_7Q_Challan_Ref IS NOT NULL
1234: THEN
1235: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_7Q'||l_7Q_Challan_Ref,7);
1236: pay_action_information_api.create_action_information
1237: (p_action_context_id => p_arc_pay_action_id
1238: ,p_action_context_type => 'PA'
1239: ,p_action_information_category => 'IN_PF_7Q'
1240: ,p_action_information1 => l_7Q_Due_Mth
1252:
1253: IF l_Misc_Challan_Ref IS NOT NULL
1254: THEN
1255: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_MISC'||l_Misc_Challan_Ref,8);
1256: pay_action_information_api.create_action_information
1257: (p_action_context_id => p_arc_pay_action_id
1258: ,p_action_context_type => 'PA'
1259: ,p_action_information_category => 'IN_PF_MISC'
1260: ,p_action_information1 => l_Misc_Challan_Ref
1408: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1409: AND scl.enabled_flag = 'Y')
1410: AND NOT EXISTS ( SELECT paa.assignment_id
1411: FROM pay_assignment_actions paa
1412: ,pay_action_information pai
1413: ,hr_organization_information hoi
1414: ,pay_payroll_actions ppa
1415: WHERE paa.assignment_id = paa_init.assignment_id
1416: AND paa.assignment_action_id = pai.action_context_id
1457: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1458: AND scl.enabled_flag = 'Y')
1459: AND NOT EXISTS ( SELECT paa.assignment_id
1460: FROM pay_assignment_actions paa
1461: ,pay_action_information pai
1462: ,hr_organization_information hoi
1463: ,hr_organization_units hou
1464: ,pay_payroll_actions ppa
1465: WHERE paa.assignment_id = paa_init.assignment_id
1530: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
1531: AND hoi_challan.org_information1 = g_challan_year
1532: AND hoi_challan.org_information2 = g_challan_mth
1533: AND NOT EXISTS (SELECT pai.action_information8
1534: FROM pay_action_information pai,
1535: pay_payroll_Actions ppa
1536: WHERE pai.action_information8 = hoi_challan.org_information12
1537: AND pai.action_information_category = 'IN_PF_CHALLAN'
1538: AND pai.action_context_type = 'PA'
1542: AND ppa.action_status='C'
1543: AND ppa.report_type='IN_PF_ARCHIVE'
1544: AND pai.action_context_id IN
1545: (SELECT action_context_id
1546: FROM pay_action_information painfo
1547: WHERE painfo.action_information2 IN (SELECT hoi.org_information7
1548: FROM hr_organization_information hoi ,
1549: hr_organization_units hou
1550: WHERE hoi.organization_id = hou.organization_id
1598: CURSOR csr_action_context_id(p_arc_ref VARCHAR2
1599: ,p_business_no IN NUMBER)
1600: IS
1601: SELECT DISTINCT action_context_id
1602: FROM pay_action_information pai,
1603: pay_assignment_actions paa,
1604: pay_payroll_Actions ppa
1605: WHERE action_information2 = p_arc_ref
1606: AND action_context_type = 'AAP'
1631: ,p_business_no IN NUMBER
1632: )
1633: IS
1634: SELECT 1
1635: FROM pay_action_information pai
1636: WHERE pai.action_information_category = 'IN_PF_ORG'
1637: AND pai.action_context_type = 'PA'
1638: AND pai.action_context_id = p_payroll_action_id
1639: AND pai.action_information1 = p_business_no
1643: ,p_pf_org IN NUMBER
1644: )
1645: IS
1646: SELECT 1
1647: FROM pay_action_information pai
1648: WHERE pai.action_information_category = 'IN_PF_CHALLAN'
1649: AND pai.action_context_type = 'PA'
1650: AND pai.action_context_id = p_payroll_action_id
1651: AND pai.action_information3 = p_pf_org
1967: ,p_business_no IN NUMBER
1968: )
1969: IS
1970: SELECT 1
1971: FROM pay_action_information pai
1972: WHERE pai.action_information_category = 'IN_PF_ORG'
1973: AND pai.action_context_type = 'PA'
1974: AND pai.action_context_id = p_payroll_action_id
1975: AND pai.action_information1 = p_business_no
1980: ,p_pf_org IN NUMBER
1981: )
1982: IS
1983: SELECT 1
1984: FROM pay_action_information pai
1985: WHERE pai.action_information_category = 'IN_PF_CHALLAN'
1986: AND pai.action_context_type = 'PA'
1987: AND pai.action_context_id = p_payroll_action_id
1988: AND pai.action_information3 = p_pf_org