DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on FND_NUMBER

Line 601: ,p_action_information4 => fnd_number.number_to_canonical(result_val)

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: );

Line 632: ,p_action_information4 => fnd_number.number_to_canonical(result_val)

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: );

Line 660: ,p_action_information4 => fnd_number.number_to_canonical(l_vol_pf_rate)

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: );

Line 975: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))

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))

Line 976: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,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))

Line 977: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,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))

Line 978: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,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))

Line 979: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,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

Line 980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,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
984: ,hoi_challan.org_information12 Challan_Ref

Line 981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,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
985: ,hoi_challan.org_information13 Legal_Charges

Line 982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,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
986: ,hoi_challan.org_information14 Interest_Sec

Line 983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount

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

Line 998: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))

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

Line 999: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due

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

Line 1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages

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

Line 1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages

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

Line 1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages

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'

Line 1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin

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;

Line 1014: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))

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

Line 1015: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages

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

Line 1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages

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

Line 1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages

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

Line 1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin

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'

Line 1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin

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;

Line 1028: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))

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

Line 1029: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay

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

Line 1031: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_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

Line 1033: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay

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

Line 1035: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_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

Line 1037: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin

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'

Line 1188: ,p_action_information7 => fnd_number.number_to_canonical(l_Amount)

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

Line 1200: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)

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

Line 1201: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)

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: );

Line 1202: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)

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 ;

Line 1219: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)

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)

Line 1220: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)

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

Line 1221: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)

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

Line 1222: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)

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: );

Line 1223: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)

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 ;

Line 1239: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)

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)

Line 1240: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)

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

Line 1241: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)

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

Line 1242: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)

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: );

Line 1243: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)

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 ;

Line 1257: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)

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)

Line 1259: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_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)

Line 1261: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)

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)

Line 1263: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_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

Line 1265: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)

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: );