[Home] [Help]
175:
176: CURSOR csr_arch_ref_no
177: IS
178: SELECT 1
179: FROM pay_action_information pai
180: ,pay_payroll_actions ppa
181: WHERE pai.action_information_category = 'IN_PF_BUSINESS_NUMBER'
182: AND pai.action_context_type = 'PA'
183: AND pai.action_information2 = g_arc_ref_no
377: CLOSE csr_pf_people;
378:
379: pay_in_utils.set_location(g_debug,'Assignment Id : '||p_assignment_id,15);
380:
381: pay_action_information_api.create_action_information
382: (p_action_context_id => p_arc_asg_action_id
383: ,p_action_context_type => 'AAP'
384: ,p_action_information_category => 'IN_PF_PERSON_DTLS'
385: ,p_source_id => p_run_asg_action_id
556:
557: CURSOR csr_chk_vpf(p_class VARCHAR2 )
558: IS
559: SELECT COUNT(*)
560: FROM pay_action_information
561: WHERE action_context_id = p_arc_asg_action_id
562: AND action_information1 = p_business_number
563: AND action_information_category = 'IN_PF_SALARY'
564: AND action_context_type = 'AAP'
589: pay_in_utils.set_location(g_debug,'balance_name: '||c_rec.balance_name,20);
590: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
591:
592: IF result_val <> 0 THEN
593: pay_action_information_api.create_action_information
594: (p_action_context_id => p_arc_asg_action_id
595: ,p_action_context_type => 'AAP'
596: ,p_action_information_category => 'IN_PF_SALARY'
597: ,p_source_id => p_run_asg_action_id
620: pay_in_utils.set_location(g_debug,'balance_name: '||rec_pf_balances_ptd.balance_name,20);
621: pay_in_utils.set_location(g_debug,'result_val: '||result_val,20);
622:
623: IF result_val <> 0 THEN
624: pay_action_information_api.create_action_information
625: (p_action_context_id => p_arc_asg_action_id
626: ,p_action_context_type => 'AAP'
627: ,p_action_information_category => 'IN_PF_SALARY'
628: ,p_source_id => p_run_asg_action_id
648: OPEN csr_pf_vol_rate;
649: FETCH csr_pf_vol_rate INTO l_vol_pf_rate;
650: CLOSE csr_pf_vol_rate;
651:
652: pay_action_information_api.create_action_information
653: (p_action_context_id => p_arc_asg_action_id
654: ,p_action_context_type => 'AAP'
655: ,p_action_information_category => 'IN_PF_SALARY'
656: ,p_source_id => p_run_asg_action_id
799: OPEN csr_emp_name(l_representative);
800: FETCH csr_emp_name INTO l_representative_name;
801: CLOSE csr_emp_name ;
802:
803: pay_action_information_api.create_action_information
804: (p_action_context_id => p_arc_pay_action_id
805: ,p_action_context_type => 'PA'
806: ,p_action_information_category => 'IN_PF_ORG'
807: ,p_action_information1 => rec_pf_org.bus_no
825: WHERE payroll_action_id =p_arc_pay_action_id;
826:
827: pay_in_utils.set_location(g_debug,'Business Number : '||p_business_number,15);
828:
829: pay_action_information_api.create_action_information
830: (p_action_context_id => p_arc_pay_action_id
831: ,p_action_context_type => 'PA'
832: ,p_action_information_category => 'IN_PF_BUSINESS_NUMBER'
833: ,p_action_information1 => p_business_number
838: ,p_action_information_id => l_action_info_id
839: ,p_object_version_number => l_ovn
840: );
841:
842: pay_action_information_api.create_action_information
843: (p_action_context_id => p_arc_pay_action_id
844: ,p_action_context_type => 'PA'
845: ,p_action_information_category => 'IN_PF_ARC_REF_NUMBER'
846: ,p_action_information1 => g_return_type
1174:
1175: IF l_Challan_Ref IS NOT NULL
1176: THEN
1177: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_CHALLAN'||l_Challan_Ref,5);
1178: pay_action_information_api.create_action_information
1179: (p_action_context_id => p_arc_pay_action_id
1180: ,p_action_context_type => 'PA'
1181: ,p_action_information_category => 'IN_PF_CHALLAN'
1182: ,p_action_information1 => p_business_number
1208: IF l_14B_Challan_Ref IS NOT NULL
1209: THEN
1210:
1211: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_14B'||l_14B_Challan_Ref,6);
1212: pay_action_information_api.create_action_information
1213: (p_action_context_id => p_arc_pay_action_id
1214: ,p_action_context_type => 'PA'
1215: ,p_action_information_category => 'IN_PF_14B'
1216: ,p_action_information1 => l_14B_Prev_Mth
1228:
1229: IF l_7Q_Challan_Ref IS NOT NULL
1230: THEN
1231: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_7Q'||l_7Q_Challan_Ref,7);
1232: pay_action_information_api.create_action_information
1233: (p_action_context_id => p_arc_pay_action_id
1234: ,p_action_context_type => 'PA'
1235: ,p_action_information_category => 'IN_PF_7Q'
1236: ,p_action_information1 => l_7Q_Due_Mth
1248:
1249: IF l_Misc_Challan_Ref IS NOT NULL
1250: THEN
1251: pay_in_utils.set_location(g_debug,'Archiving : IN_PF_MISC'||l_Misc_Challan_Ref,8);
1252: pay_action_information_api.create_action_information
1253: (p_action_context_id => p_arc_pay_action_id
1254: ,p_action_context_type => 'PA'
1255: ,p_action_information_category => 'IN_PF_MISC'
1256: ,p_action_information1 => l_Misc_Challan_Ref
1404: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1405: AND scl.enabled_flag = 'Y')
1406: AND NOT EXISTS ( SELECT paa.assignment_id
1407: FROM pay_assignment_actions paa
1408: ,pay_action_information pai
1409: ,hr_organization_information hoi
1410: ,pay_payroll_actions ppa
1411: WHERE paa.assignment_id = paa_init.assignment_id
1412: AND paa.assignment_action_id = pai.action_context_id
1453: WHERE scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
1454: AND scl.enabled_flag = 'Y')
1455: AND NOT EXISTS ( SELECT paa.assignment_id
1456: FROM pay_assignment_actions paa
1457: ,pay_action_information pai
1458: ,hr_organization_information hoi
1459: ,hr_organization_units hou
1460: ,pay_payroll_actions ppa
1461: WHERE paa.assignment_id = paa_init.assignment_id
1526: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
1527: AND hoi_challan.org_information1 = g_challan_year
1528: AND hoi_challan.org_information2 = g_challan_mth
1529: AND NOT EXISTS (SELECT pai.action_information8
1530: FROM pay_action_information pai,
1531: pay_payroll_Actions ppa
1532: WHERE pai.action_information8 = hoi_challan.org_information12
1533: AND pai.action_information_category = 'IN_PF_CHALLAN'
1534: AND pai.action_context_type = 'PA'
1538: AND ppa.action_status='C'
1539: AND ppa.report_type='IN_PF_ARCHIVE'
1540: AND pai.action_context_id IN
1541: (SELECT action_context_id
1542: FROM pay_action_information painfo
1543: WHERE painfo.action_information2 IN (SELECT hoi.org_information7
1544: FROM hr_organization_information hoi ,
1545: hr_organization_units hou
1546: WHERE hoi.organization_id = hou.organization_id
1594: CURSOR csr_action_context_id(p_arc_ref VARCHAR2
1595: ,p_business_no IN NUMBER)
1596: IS
1597: SELECT DISTINCT action_context_id
1598: FROM pay_action_information pai,
1599: pay_assignment_actions paa,
1600: pay_payroll_Actions ppa
1601: WHERE action_information2 = p_arc_ref
1602: AND action_context_type = 'AAP'
1627: ,p_business_no IN NUMBER
1628: )
1629: IS
1630: SELECT 1
1631: FROM pay_action_information pai
1632: WHERE pai.action_information_category = 'IN_PF_ORG'
1633: AND pai.action_context_type = 'PA'
1634: AND pai.action_context_id = p_payroll_action_id
1635: AND pai.action_information1 = p_business_no
1639: ,p_pf_org IN NUMBER
1640: )
1641: IS
1642: SELECT 1
1643: FROM pay_action_information pai
1644: WHERE pai.action_information_category = 'IN_PF_CHALLAN'
1645: AND pai.action_context_type = 'PA'
1646: AND pai.action_context_id = p_payroll_action_id
1647: AND pai.action_information3 = p_pf_org
1963: ,p_business_no IN NUMBER
1964: )
1965: IS
1966: SELECT 1
1967: FROM pay_action_information pai
1968: WHERE pai.action_information_category = 'IN_PF_ORG'
1969: AND pai.action_context_type = 'PA'
1970: AND pai.action_context_id = p_payroll_action_id
1971: AND pai.action_information1 = p_business_no
1976: ,p_pf_org IN NUMBER
1977: )
1978: IS
1979: SELECT 1
1980: FROM pay_action_information pai
1981: WHERE pai.action_information_category = 'IN_PF_CHALLAN'
1982: AND pai.action_context_type = 'PA'
1983: AND pai.action_context_id = p_payroll_action_id
1984: AND pai.action_information3 = p_pf_org