eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_MTRA dependencies on FND_NUMBER

Line 88: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_WT'))

84:
85: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
86: SELECT PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
87: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
88: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_WT'))
89: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_SS'))
90: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_TS'))
91: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'VAT'))
92: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')

Line 89: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_SS'))

85: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
86: SELECT PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
87: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
88: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_WT'))
89: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_SS'))
90: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_TS'))
91: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'VAT'))
92: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
93: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')

Line 90: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_TS'))

86: SELECT PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
87: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
88: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_WT'))
89: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_SS'))
90: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_TS'))
91: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'VAT'))
92: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
93: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
94: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 91: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'VAT'))

87: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
88: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_WT'))
89: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_SS'))
90: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ADJUSTMENT_TS'))
91: ,FND_NUMBER.CANONICAL_TO_NUMBER(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'VAT'))
92: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
93: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
94: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
95: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'DUE_DATE'))

Line 912: ,p_action_information3 => FND_NUMBER.NUMBER_TO_CANONICAL(l_subsidy_tax_at_source_dec) --l_emp_id

908: ,p_source_text => NULL
909: ,p_action_information_category => 'EMEA REPORT INFORMATION'
910: ,p_action_information1 => 'PYFIMTRA'
911: ,p_action_information2 => l_emp_type
912: ,p_action_information3 => FND_NUMBER.NUMBER_TO_CANONICAL(l_subsidy_tax_at_source_dec) --l_emp_id
913: ,p_action_information4 => l_month||l_year
914: ,p_action_information5 => l_tax_payer_name
915: ,p_action_information6 => l_address_line_1
916: ,p_action_information7 => l_address_line_2

Line 920: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Wt)

916: ,p_action_information7 => l_address_line_2
917: ,p_action_information8 => l_address_line_3
918: ,p_action_information9 => l_postal_code || ' ' ||l_town_or_city ||' '||l_country
919: ,p_action_information10 => l_business_id
920: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Wt)
921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)
922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)

Line 921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)

917: ,p_action_information8 => l_address_line_3
918: ,p_action_information9 => l_postal_code || ' ' ||l_town_or_city ||' '||l_country
919: ,p_action_information10 => l_business_id
920: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Wt)
921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)
922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))

Line 922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)

918: ,p_action_information9 => l_postal_code || ' ' ||l_town_or_city ||' '||l_country
919: ,p_action_information10 => l_business_id
920: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Wt)
921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)
922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)

Line 923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)

919: ,p_action_information10 => l_business_id
920: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Wt)
921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)
922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))

Line 924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)

920: ,p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Wt)
921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)
922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)

Line 925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))

921: ,p_action_information12 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Sal_subject_Ts)
922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)
929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))

Line 926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)

922: ,p_action_information13 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_Wt)
923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)
929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))
930: ,p_action_information21 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_vat,0))

Line 927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))

923: ,p_action_information14 => FND_NUMBER.NUMBER_TO_CANONICAL(l_Pay_subject_ts)
924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)
929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))
930: ,p_action_information21 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_vat,0))
931: ,p_action_information22 => l_contact_person

Line 928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)

924: ,p_action_information15 => FND_NUMBER.NUMBER_TO_CANONICAL(l_wt_deduction)
925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)
929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))
930: ,p_action_information21 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_vat,0))
931: ,p_action_information22 => l_contact_person
932: ,p_action_information23 => l_phone

Line 929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))

925: ,p_action_information16 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_wt,0))
926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)
929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))
930: ,p_action_information21 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_vat,0))
931: ,p_action_information22 => l_contact_person
932: ,p_action_information23 => l_phone
933: ,p_action_information24 => l_fax

Line 930: ,p_action_information21 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_vat,0))

926: ,p_action_information17 => FND_NUMBER.NUMBER_TO_CANONICAL(l_employer_ss_fee)
927: ,p_action_information18 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ss,0))
928: ,p_action_information19 => FND_NUMBER.NUMBER_TO_CANONICAL(l_ts_deduction)
929: ,p_action_information20 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_adjustment_ts,0))
930: ,p_action_information21 => FND_NUMBER.NUMBER_TO_CANONICAL(nvl(l_vat,0))
931: ,p_action_information22 => l_contact_person
932: ,p_action_information23 => l_phone
933: ,p_action_information24 => l_fax
934: ,p_action_information25 => l_tax_office_ba

Line 939: ,p_action_information30 => FND_NUMBER.NUMBER_TO_CANONICAL(l_subsidy_witholding_tax_ded) ); -- null );

935: ,p_action_information26 => l_tax_office_name
936: ,p_action_information27 => l_employer_ba
937: ,p_action_information28 => l_due_date2
938: ,p_action_information29 => l_ref_num
939: ,p_action_information30 => FND_NUMBER.NUMBER_TO_CANONICAL(l_subsidy_witholding_tax_ded) ); -- null );
940:
941:
942: pay_action_information_api.create_action_information (
943: p_action_information_id => l_action_info_id