APPS.PAY_IN_PF_ARCHIVE dependencies on FND_NUMBER

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

601: ,p_source_id => p_run_asg_action_id
602: ,p_action_information1 => p_business_number
603: ,p_action_information2 => p_pf_org
604: ,p_action_information3 => c_rec.balance_name
605: ,p_action_information4 => fnd_number.number_to_canonical(result_val)
606: ,p_action_information5 => l_classification
607: ,p_action_information_id => l_action_info_id
608: ,p_object_version_number => l_ovn
609: );

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

632: ,p_source_id => p_run_asg_action_id
633: ,p_action_information1 => p_business_number
634: ,p_action_information2 => p_pf_org
635: ,p_action_information3 => rec_pf_balances_ptd.balance_name
636: ,p_action_information4 => fnd_number.number_to_canonical(result_val)
637: ,p_action_information5 => l_classification
638: ,p_action_information_id => l_action_info_id
639: ,p_object_version_number => l_ovn
640: );

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

660: ,p_source_id => p_run_asg_action_id
661: ,p_action_information1 => p_business_number
662: ,p_action_information2 => p_pf_org
663: ,p_action_information3 => 'Voluntary PF Percent'
664: ,p_action_information4 => fnd_number.number_to_canonical(l_vol_pf_rate)
665: ,p_action_information5 => l_classification
666: ,p_action_information_id => l_action_info_id
667: ,p_object_version_number => l_ovn
668: );

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

975: CURSOR csr_challans_info
976: IS
977: SELECT hoi_challan.org_information11 Paid_Under_Protest
978: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
979: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))

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

976: IS
977: SELECT hoi_challan.org_information11 Paid_Under_Protest
978: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
979: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))

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

977: SELECT hoi_challan.org_information11 Paid_Under_Protest
978: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
979: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))

Line 982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))

978: ,fnd_date.canonical_to_date(hoi_challan.org_information9) Cheque_DD_Dep_Date
979: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))

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

979: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
987: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount

Line 984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))

980: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
987: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
988: ,hoi_challan.org_information12 Challan_Ref

Line 985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))

981: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0))
982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
987: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
988: ,hoi_challan.org_information12 Challan_Ref
989: ,hoi_challan.org_information13 Legal_Charges

Line 986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))

982: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information6,0))
983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
987: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
988: ,hoi_challan.org_information12 Challan_Ref
989: ,hoi_challan.org_information13 Legal_Charges
990: ,hoi_challan.org_information14 Interest_Sec

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

983: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information7,0))
984: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information8,0))
985: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information13,0))
986: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information14,0))
987: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information15,0)) Amount
988: ,hoi_challan.org_information12 Challan_Ref
989: ,hoi_challan.org_information13 Legal_Charges
990: ,hoi_challan.org_information14 Interest_Sec
991: ,hoi_challan.org_information15 Penalty

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

998: IS
999: SELECT hoi_challan.org_information1 Challan_Ref
1000: ,hoi_challan.org_information2 Prev_Mth
1001: ,hoi_challan.org_information3 Prev_Yr
1002: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1003: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1004: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1005: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1006: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages

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

999: SELECT hoi_challan.org_information1 Challan_Ref
1000: ,hoi_challan.org_information2 Prev_Mth
1001: ,hoi_challan.org_information3 Prev_Yr
1002: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1003: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1004: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1005: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1006: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1007: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin

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

1000: ,hoi_challan.org_information2 Prev_Mth
1001: ,hoi_challan.org_information3 Prev_Yr
1002: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1003: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1004: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1005: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1006: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1007: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1008: FROM hr_organization_information hoi_challan

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

1001: ,hoi_challan.org_information3 Prev_Yr
1002: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1003: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1004: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1005: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1006: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1007: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1008: FROM hr_organization_information hoi_challan
1009: WHERE hoi_challan.organization_id = p_pf_org

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

1002: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1003: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1004: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1005: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1006: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1007: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1008: FROM hr_organization_information hoi_challan
1009: WHERE hoi_challan.organization_id = p_pf_org
1010: AND hoi_challan.org_information_context ='PER_IN_PF_CHN_SEC14B'

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

1003: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) Penal_Damages_Due
1004: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1005: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1006: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1007: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1008: FROM hr_organization_information hoi_challan
1009: WHERE hoi_challan.organization_id = p_pf_org
1010: AND hoi_challan.org_information_context ='PER_IN_PF_CHN_SEC14B'
1011: AND hoi_challan.org_information1= p_challan_ref;

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

1014: IS
1015: SELECT hoi_challan.org_information11 Challan_Ref
1016: ,hoi_challan.org_information1 Due_Mth
1017: ,hoi_challan.org_information2 Due_Yr
1018: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1019: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1020: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1021: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1022: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin

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

1015: SELECT hoi_challan.org_information11 Challan_Ref
1016: ,hoi_challan.org_information1 Due_Mth
1017: ,hoi_challan.org_information2 Due_Yr
1018: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1019: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1020: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1021: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1022: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1023: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin

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

1016: ,hoi_challan.org_information1 Due_Mth
1017: ,hoi_challan.org_information2 Due_Yr
1018: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1019: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1020: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1021: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1022: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1023: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1024: FROM hr_organization_information hoi_challan

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

1017: ,hoi_challan.org_information2 Due_Yr
1018: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1019: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1020: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1021: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1022: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1023: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1024: FROM hr_organization_information hoi_challan
1025: WHERE hoi_challan.organization_id = p_pf_org

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

1018: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information3,0))
1019: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1020: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1021: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1022: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1023: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1024: FROM hr_organization_information hoi_challan
1025: WHERE hoi_challan.organization_id = p_pf_org
1026: AND hoi_challan.org_information_context ='PER_IN_PF_SEC7Q_INFO'

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

1019: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0)) EPF_Damages
1020: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1021: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1022: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1023: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1024: FROM hr_organization_information hoi_challan
1025: WHERE hoi_challan.organization_id = p_pf_org
1026: AND hoi_challan.org_information_context ='PER_IN_PF_SEC7Q_INFO'
1027: AND hoi_challan.org_information11= p_challan_ref;

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

1028:
1029: CURSOR csr_misc
1030: IS
1031: SELECT hoi_challan.org_information3 Challan_Ref
1032: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1033: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1034: ,hoi_challan.org_information6 EPF_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1036: ,hoi_challan.org_information8 EPS_Rem

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

1029: CURSOR csr_misc
1030: IS
1031: SELECT hoi_challan.org_information3 Challan_Ref
1032: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1033: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1034: ,hoi_challan.org_information6 EPF_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1036: ,hoi_challan.org_information8 EPS_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay

Line 1035: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay

1031: SELECT hoi_challan.org_information3 Challan_Ref
1032: ,fnd_number.canonical_to_number(NVL(hoi_challan.org_information4,0))
1033: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1034: ,hoi_challan.org_information6 EPF_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1036: ,hoi_challan.org_information8 EPS_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1038: ,hoi_challan.org_information10 EDLI_Rem
1039: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin

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

1033: +fnd_number.canonical_to_number(NVL(hoi_challan.org_information5,0)) EPF_Misc_Pay
1034: ,hoi_challan.org_information6 EPF_Rem
1035: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1036: ,hoi_challan.org_information8 EPS_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1038: ,hoi_challan.org_information10 EDLI_Rem
1039: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1040: ,hoi_challan.org_information12 EPF_Admin_Rem
1041: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin

Line 1039: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin

1035: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EPS_Misc_Pay
1036: ,hoi_challan.org_information8 EPS_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1038: ,hoi_challan.org_information10 EDLI_Rem
1039: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1040: ,hoi_challan.org_information12 EPF_Admin_Rem
1041: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin
1042: ,hoi_challan.org_information14 EDLI_Admin_Rem
1043: FROM hr_organization_information hoi_challan

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

1037: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EDLI_Misc_Pay
1038: ,hoi_challan.org_information10 EDLI_Rem
1039: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1040: ,hoi_challan.org_information12 EPF_Admin_Rem
1041: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin
1042: ,hoi_challan.org_information14 EDLI_Admin_Rem
1043: FROM hr_organization_information hoi_challan
1044: WHERE hoi_challan.organization_id = p_pf_org
1045: AND hoi_challan.org_information_context ='PER_IN_PF_MIS_PAY_INFO'

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

1188: ,p_action_information3 => p_pf_org
1189: ,p_action_information4 => l_Cheque_DD_No
1190: ,p_action_information5 => fnd_date.date_to_canonical(l_Cheque_DD_Date)
1191: ,p_action_information6 => fnd_date.date_to_canonical(l_Cheque_DD_Dep_Date)
1192: ,p_action_information7 => fnd_number.number_to_canonical(l_Amount)
1193: ,p_action_information8 => l_Challan_Ref
1194: ,p_action_information9 => l_Bank_Code
1195: ,p_action_information11 => l_Branch_Code
1196: ,p_action_information12 => l_Branch_Name

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

1200: ,p_action_information16 => l_Dep_Branch_Name
1201: ,p_action_information17 => l_Dep_Branch_Addr
1202: ,p_action_information18 => l_Dep_Base_Branch
1203: ,p_action_information20 => l_Paid_Under_Protest
1204: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)
1205: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)
1206: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)
1207: ,p_action_information_id => l_action_info_id
1208: ,p_object_version_number => l_ovn

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

1201: ,p_action_information17 => l_Dep_Branch_Addr
1202: ,p_action_information18 => l_Dep_Base_Branch
1203: ,p_action_information20 => l_Paid_Under_Protest
1204: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)
1205: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)
1206: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)
1207: ,p_action_information_id => l_action_info_id
1208: ,p_object_version_number => l_ovn
1209: );

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

1202: ,p_action_information18 => l_Dep_Base_Branch
1203: ,p_action_information20 => l_Paid_Under_Protest
1204: ,p_action_information21 => fnd_number.number_to_canonical(l_Interest_Sec)
1205: ,p_action_information22 => fnd_number.number_to_canonical(l_Legal_Charges)
1206: ,p_action_information23 => fnd_number.number_to_canonical(l_Penalty)
1207: ,p_action_information_id => l_action_info_id
1208: ,p_object_version_number => l_ovn
1209: );
1210: END IF ;

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

1219: ,p_action_information_category => 'IN_PF_14B'
1220: ,p_action_information1 => l_14B_Prev_Mth
1221: ,p_action_information2 => l_14B_Prev_Yr
1222: ,p_action_information3 => l_14B_Challan_Ref
1223: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1224: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1225: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1226: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1227: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)

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

1220: ,p_action_information1 => l_14B_Prev_Mth
1221: ,p_action_information2 => l_14B_Prev_Yr
1222: ,p_action_information3 => l_14B_Challan_Ref
1223: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1224: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1225: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1226: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1227: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1228: ,p_action_information_id => l_action_info_id

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

1221: ,p_action_information2 => l_14B_Prev_Yr
1222: ,p_action_information3 => l_14B_Challan_Ref
1223: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1224: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1225: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1226: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1227: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1228: ,p_action_information_id => l_action_info_id
1229: ,p_object_version_number => l_ovn

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

1222: ,p_action_information3 => l_14B_Challan_Ref
1223: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1224: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1225: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1226: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1227: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1228: ,p_action_information_id => l_action_info_id
1229: ,p_object_version_number => l_ovn
1230: );

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

1223: ,p_action_information4 => fnd_number.number_to_canonical(l_14B_Penal_Damages_Due)
1224: ,p_action_information5 => fnd_number.number_to_canonical(l_14B_EPS_Penal_Damages)
1225: ,p_action_information6 => fnd_number.number_to_canonical(l_14B_EDLI_Penal_Damages)
1226: ,p_action_information7 => fnd_number.number_to_canonical(l_14B_EPF_Penal_Damages)
1227: ,p_action_information8 => fnd_number.number_to_canonical(l_14B_Edli_Admin)
1228: ,p_action_information_id => l_action_info_id
1229: ,p_object_version_number => l_ovn
1230: );
1231: END IF ;

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

1239: ,p_action_information_category => 'IN_PF_7Q'
1240: ,p_action_information1 => l_7Q_Due_Mth
1241: ,p_action_information2 => l_7Q_Due_Yr
1242: ,p_action_information3 => l_7Q_Challan_Ref
1243: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1244: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1245: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1246: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1247: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)

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

1240: ,p_action_information1 => l_7Q_Due_Mth
1241: ,p_action_information2 => l_7Q_Due_Yr
1242: ,p_action_information3 => l_7Q_Challan_Ref
1243: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1244: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1245: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1246: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1247: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1248: ,p_action_information_id => l_action_info_id

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

1241: ,p_action_information2 => l_7Q_Due_Yr
1242: ,p_action_information3 => l_7Q_Challan_Ref
1243: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1244: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1245: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1246: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1247: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1248: ,p_action_information_id => l_action_info_id
1249: ,p_object_version_number => l_ovn

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

1242: ,p_action_information3 => l_7Q_Challan_Ref
1243: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1244: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1245: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1246: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1247: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1248: ,p_action_information_id => l_action_info_id
1249: ,p_object_version_number => l_ovn
1250: );

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

1243: ,p_action_information4 => fnd_number.number_to_canonical(l_7Q_EPF_Damages)
1244: ,p_action_information5 => fnd_number.number_to_canonical(l_7Q_EPS_Damages)
1245: ,p_action_information6 => fnd_number.number_to_canonical(l_7Q_EDLI_Damages)
1246: ,p_action_information7 => fnd_number.number_to_canonical(l_7Q_EPF_Admin)
1247: ,p_action_information8 => fnd_number.number_to_canonical(l_7Q_EDLI_Admin)
1248: ,p_action_information_id => l_action_info_id
1249: ,p_object_version_number => l_ovn
1250: );
1251: END IF ;

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

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
1261: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)
1262: ,p_action_information3 => l_Misc_EPF_Rem
1263: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1264: ,p_action_information5 => l_Misc_EPS_Rem
1265: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)

Line 1263: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)

1259: ,p_action_information_category => 'IN_PF_MISC'
1260: ,p_action_information1 => l_Misc_Challan_Ref
1261: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)
1262: ,p_action_information3 => l_Misc_EPF_Rem
1263: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1264: ,p_action_information5 => l_Misc_EPS_Rem
1265: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1266: ,p_action_information7 => l_Misc_EDLI_Rem
1267: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)

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

1261: ,p_action_information2 => fnd_number.number_to_canonical(l_Misc_EPF_Pay)
1262: ,p_action_information3 => l_Misc_EPF_Rem
1263: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1264: ,p_action_information5 => l_Misc_EPS_Rem
1265: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1266: ,p_action_information7 => l_Misc_EDLI_Rem
1267: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1268: ,p_action_information9 => l_Misc_EPF_Admin_Rem
1269: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)

Line 1267: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)

1263: ,p_action_information4 => fnd_number.number_to_canonical(l_Misc_EPS_Pay)
1264: ,p_action_information5 => l_Misc_EPS_Rem
1265: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1266: ,p_action_information7 => l_Misc_EDLI_Rem
1267: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1268: ,p_action_information9 => l_Misc_EPF_Admin_Rem
1269: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)
1270: ,p_action_information11 => l_Misc_EDLI_Admin_Rem
1271: ,p_action_information_id => l_action_info_id

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

1265: ,p_action_information6 => fnd_number.number_to_canonical(l_Misc_EDLI_Pay)
1266: ,p_action_information7 => l_Misc_EDLI_Rem
1267: ,p_action_information8 => fnd_number.number_to_canonical(l_Misc_EPF_Admin)
1268: ,p_action_information9 => l_Misc_EPF_Admin_Rem
1269: ,p_action_information10 => fnd_number.number_to_canonical(l_Misc_EDLI_Admin)
1270: ,p_action_information11 => l_Misc_EDLI_Admin_Rem
1271: ,p_action_information_id => l_action_info_id
1272: ,p_object_version_number => l_ovn
1273: );