597: ,p_source_id => p_run_asg_action_id
598: ,p_action_information1 => p_business_number
599: ,p_action_information2 => p_pf_org
600: ,p_action_information3 => c_rec.balance_name
601: ,p_action_information4 => fnd_number.number_to_canonical(result_val)
602: ,p_action_information5 => l_classification
603: ,p_action_information_id => l_action_info_id
604: ,p_object_version_number => l_ovn
605: );
628: ,p_source_id => p_run_asg_action_id
629: ,p_action_information1 => p_business_number
630: ,p_action_information2 => p_pf_org
631: ,p_action_information3 => rec_pf_balances_ptd.balance_name
632: ,p_action_information4 => fnd_number.number_to_canonical(result_val)
633: ,p_action_information5 => l_classification
634: ,p_action_information_id => l_action_info_id
635: ,p_object_version_number => l_ovn
636: );
656: ,p_source_id => p_run_asg_action_id
657: ,p_action_information1 => p_business_number
658: ,p_action_information2 => p_pf_org
659: ,p_action_information3 => 'Voluntary PF Percent'
660: ,p_action_information4 => fnd_number.number_to_canonical(l_vol_pf_rate)
661: ,p_action_information5 => l_classification
662: ,p_action_information_id => l_action_info_id
663: ,p_object_version_number => l_ovn
664: );
971: CURSOR csr_challans_info
972: IS
973: SELECT hoi_challan.org_information11 Paid_Under_Protest
974: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
972: IS
973: SELECT hoi_challan.org_information11 Paid_Under_Protest
974: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
973: SELECT hoi_challan.org_information11 Paid_Under_Protest
974: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
974: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
984: ,hoi_challan.org_information12 Challan_Ref
977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
984: ,hoi_challan.org_information12 Challan_Ref
985: ,hoi_challan.org_information13 Legal_Charges
978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
984: ,hoi_challan.org_information12 Challan_Ref
985: ,hoi_challan.org_information13 Legal_Charges
986: ,hoi_challan.org_information14 Interest_Sec
979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
984: ,hoi_challan.org_information12 Challan_Ref
985: ,hoi_challan.org_information13 Legal_Charges
986: ,hoi_challan.org_information14 Interest_Sec
987: ,hoi_challan.org_information15 Penalty
994: IS
995: SELECT hoi_challan.org_information1 Challan_Ref
996: ,hoi_challan.org_information2 Prev_Mth
997: ,hoi_challan.org_information3 Prev_Yr
998: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
995: SELECT hoi_challan.org_information1 Challan_Ref
996: ,hoi_challan.org_information2 Prev_Mth
997: ,hoi_challan.org_information3 Prev_Yr
998: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
996: ,hoi_challan.org_information2 Prev_Mth
997: ,hoi_challan.org_information3 Prev_Yr
998: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1004: FROM hr_organization_information hoi_challan
997: ,hoi_challan.org_information3 Prev_Yr
998: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1004: FROM hr_organization_information hoi_challan
1005: WHERE hoi_challan.organization_id = p_pf_org
998: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1004: FROM hr_organization_information hoi_challan
1005: WHERE hoi_challan.organization_id = p_pf_org
1006: AND hoi_challan.org_information_context ='PER_IN_PF_CHN_SEC14B'
999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1004: FROM hr_organization_information hoi_challan
1005: WHERE hoi_challan.organization_id = p_pf_org
1006: AND hoi_challan.org_information_context ='PER_IN_PF_CHN_SEC14B'
1007: AND hoi_challan.org_information1= p_challan_ref;
1010: IS
1011: SELECT hoi_challan.org_information11 Challan_Ref
1012: ,hoi_challan.org_information1 Due_Mth
1013: ,hoi_challan.org_information2 Due_Yr
1014: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1011: SELECT hoi_challan.org_information11 Challan_Ref
1012: ,hoi_challan.org_information1 Due_Mth
1013: ,hoi_challan.org_information2 Due_Yr
1014: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1012: ,hoi_challan.org_information1 Due_Mth
1013: ,hoi_challan.org_information2 Due_Yr
1014: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1020: FROM hr_organization_information hoi_challan
1013: ,hoi_challan.org_information2 Due_Yr
1014: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1020: FROM hr_organization_information hoi_challan
1021: WHERE hoi_challan.organization_id = p_pf_org
1014: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1020: FROM hr_organization_information hoi_challan
1021: WHERE hoi_challan.organization_id = p_pf_org
1022: AND hoi_challan.org_information_context ='PER_IN_PF_SEC7Q_INFO'
1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1020: FROM hr_organization_information hoi_challan
1021: WHERE hoi_challan.organization_id = p_pf_org
1022: AND hoi_challan.org_information_context ='PER_IN_PF_SEC7Q_INFO'
1023: AND hoi_challan.org_information11= p_challan_ref;
1024:
1025: CURSOR csr_misc
1026: IS
1027: SELECT hoi_challan.org_information3 Challan_Ref
1028: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1029: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1030: ,hoi_challan.org_information6 EPF_Rem
1031: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1032: ,hoi_challan.org_information8 EPS_Rem
1025: CURSOR csr_misc
1026: IS
1027: SELECT hoi_challan.org_information3 Challan_Ref
1028: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1029: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1030: ,hoi_challan.org_information6 EPF_Rem
1031: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1032: ,hoi_challan.org_information8 EPS_Rem
1033: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1027: SELECT hoi_challan.org_information3 Challan_Ref
1028: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1029: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1030: ,hoi_challan.org_information6 EPF_Rem
1031: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1032: ,hoi_challan.org_information8 EPS_Rem
1033: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1034: ,hoi_challan.org_information10 EDLI_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1029: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1030: ,hoi_challan.org_information6 EPF_Rem
1031: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1032: ,hoi_challan.org_information8 EPS_Rem
1033: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1034: ,hoi_challan.org_information10 EDLI_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1036: ,hoi_challan.org_information12 EPF_Admin_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin
1031: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1032: ,hoi_challan.org_information8 EPS_Rem
1033: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1034: ,hoi_challan.org_information10 EDLI_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1036: ,hoi_challan.org_information12 EPF_Admin_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin
1038: ,hoi_challan.org_information14 EDLI_Admin_Rem
1039: FROM hr_organization_information hoi_challan
1033: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1034: ,hoi_challan.org_information10 EDLI_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1036: ,hoi_challan.org_information12 EPF_Admin_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin
1038: ,hoi_challan.org_information14 EDLI_Admin_Rem
1039: FROM hr_organization_information hoi_challan
1040: WHERE hoi_challan.organization_id = p_pf_org
1041: AND hoi_challan.org_information_context ='PER_IN_PF_MIS_PAY_INFO'
1184: ,p_action_information3 => p_pf_org
1185: ,p_action_information4 => l_Cheque_DD_No
1186: ,p_action_information5 => fnd_date.date_to_canonical(l_Cheque_DD_Date)
1187: ,p_action_information6 => fnd_date.date_to_canonical(l_Cheque_DD_Dep_Date)
1188: ,p_action_information7 => fnd_number.number_to_canonical(l_Amount)
1189: ,p_action_information8 => l_Challan_Ref
1190: ,p_action_information9 => l_Bank_Code
1191: ,p_action_information11 => l_Branch_Code
1192: ,p_action_information12 => l_Branch_Name
1196: ,p_action_information16 => l_Dep_Branch_Name
1197: ,p_action_information17 => l_Dep_Branch_Addr
1198: ,p_action_information18 => l_Dep_Base_Branch
1199: ,p_action_information20 => l_Paid_Under_Protest
1200: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)
1201: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)
1202: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)
1203: ,p_action_information_id => l_action_info_id
1204: ,p_object_version_number => l_ovn
1197: ,p_action_information17 => l_Dep_Branch_Addr
1198: ,p_action_information18 => l_Dep_Base_Branch
1199: ,p_action_information20 => l_Paid_Under_Protest
1200: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)
1201: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)
1202: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)
1203: ,p_action_information_id => l_action_info_id
1204: ,p_object_version_number => l_ovn
1205: );
1198: ,p_action_information18 => l_Dep_Base_Branch
1199: ,p_action_information20 => l_Paid_Under_Protest
1200: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)
1201: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)
1202: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)
1203: ,p_action_information_id => l_action_info_id
1204: ,p_object_version_number => l_ovn
1205: );
1206: END IF ;
1215: ,p_action_information_category => 'IN_PF_14B'
1216: ,p_action_information1 => l_14B_Prev_Mth
1217: ,p_action_information2 => l_14B_Prev_Yr
1218: ,p_action_information3 => l_14B_Challan_Ref
1219: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1220: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1221: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1222: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1223: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1216: ,p_action_information1 => l_14B_Prev_Mth
1217: ,p_action_information2 => l_14B_Prev_Yr
1218: ,p_action_information3 => l_14B_Challan_Ref
1219: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1220: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1221: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1222: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1223: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1224: ,p_action_information_id => l_action_info_id
1217: ,p_action_information2 => l_14B_Prev_Yr
1218: ,p_action_information3 => l_14B_Challan_Ref
1219: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1220: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1221: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1222: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1223: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1224: ,p_action_information_id => l_action_info_id
1225: ,p_object_version_number => l_ovn
1218: ,p_action_information3 => l_14B_Challan_Ref
1219: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1220: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1221: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1222: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1223: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1224: ,p_action_information_id => l_action_info_id
1225: ,p_object_version_number => l_ovn
1226: );
1219: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1220: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1221: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1222: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1223: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1224: ,p_action_information_id => l_action_info_id
1225: ,p_object_version_number => l_ovn
1226: );
1227: END IF ;
1235: ,p_action_information_category => 'IN_PF_7Q'
1236: ,p_action_information1 => l_7Q_Due_Mth
1237: ,p_action_information2 => l_7Q_Due_Yr
1238: ,p_action_information3 => l_7Q_Challan_Ref
1239: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1240: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1241: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1242: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1243: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1236: ,p_action_information1 => l_7Q_Due_Mth
1237: ,p_action_information2 => l_7Q_Due_Yr
1238: ,p_action_information3 => l_7Q_Challan_Ref
1239: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1240: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1241: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1242: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1243: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1244: ,p_action_information_id => l_action_info_id
1237: ,p_action_information2 => l_7Q_Due_Yr
1238: ,p_action_information3 => l_7Q_Challan_Ref
1239: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1240: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1241: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1242: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1243: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1244: ,p_action_information_id => l_action_info_id
1245: ,p_object_version_number => l_ovn
1238: ,p_action_information3 => l_7Q_Challan_Ref
1239: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1240: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1241: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1242: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1243: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1244: ,p_action_information_id => l_action_info_id
1245: ,p_object_version_number => l_ovn
1246: );
1239: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1240: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1241: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1242: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1243: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1244: ,p_action_information_id => l_action_info_id
1245: ,p_object_version_number => l_ovn
1246: );
1247: END IF ;
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
1257: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)
1258: ,p_action_information3 => l_Misc_EPF_Rem
1259: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1260: ,p_action_information5 => l_Misc_EPS_Rem
1261: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1255: ,p_action_information_category => 'IN_PF_MISC'
1256: ,p_action_information1 => l_Misc_Challan_Ref
1257: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)
1258: ,p_action_information3 => l_Misc_EPF_Rem
1259: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1260: ,p_action_information5 => l_Misc_EPS_Rem
1261: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1262: ,p_action_information7 => l_Misc_EDLI_Rem
1263: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1257: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)
1258: ,p_action_information3 => l_Misc_EPF_Rem
1259: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1260: ,p_action_information5 => l_Misc_EPS_Rem
1261: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1262: ,p_action_information7 => l_Misc_EDLI_Rem
1263: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1264: ,p_action_information9 => l_Misc_EPF_Admin_Rem
1265: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)
1259: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1260: ,p_action_information5 => l_Misc_EPS_Rem
1261: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1262: ,p_action_information7 => l_Misc_EDLI_Rem
1263: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1264: ,p_action_information9 => l_Misc_EPF_Admin_Rem
1265: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)
1266: ,p_action_information11 => l_Misc_EDLI_Admin_Rem
1267: ,p_action_information_id => l_action_info_id
1261: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1262: ,p_action_information7 => l_Misc_EDLI_Rem
1263: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1264: ,p_action_information9 => l_Misc_EPF_Admin_Rem
1265: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)
1266: ,p_action_information11 => l_Misc_EDLI_Admin_Rem
1267: ,p_action_information_id => l_action_info_id
1268: ,p_object_version_number => l_ovn
1269: );