DBA Data[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on FND_NUMBER

Line 2268: ,p_source2 => fnd_number.number_to_canonical(l_fed_tax_rec.gre_id)

2264: ,p_person_id => ln_person_id
2265: ,p_assignment_id => l_fed_tax_rec.assignment_id
2266: ,p_source1 => '00-000-0000'
2267: ,p_source1_type => 'JURISDICTION'
2268: ,p_source2 => fnd_number.number_to_canonical(l_fed_tax_rec.gre_id)
2269: ,p_source2_type => 'GRE'
2270: ,p_source3 => lv_source_name --'ONLINE W4 FORM'
2271: ,p_source3_type => 'SOURCE_NAME'
2272: ,p_source4 => p_transaction_id

Line 2276: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)

2272: ,p_source4 => p_transaction_id
2273: ,p_source4_type => 'TRANSACTION_ID'
2274: ,p_audit_information_category => 'W4 FED'
2275: ,p_audit_information1 => lv_filing_status_code
2276: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)
2277: ,p_audit_information3 => fnd_number.number_to_canonical(p_additional_amount)
2278: ,p_audit_information4 => p_exempt_status_code
2279: ,p_audit_information5 => p_last_name_diff
2280: ,p_transaction_parent_id => ln_dummy

Line 2277: ,p_audit_information3 => fnd_number.number_to_canonical(p_additional_amount)

2273: ,p_source4_type => 'TRANSACTION_ID'
2274: ,p_audit_information_category => 'W4 FED'
2275: ,p_audit_information1 => lv_filing_status_code
2276: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)
2277: ,p_audit_information3 => fnd_number.number_to_canonical(p_additional_amount)
2278: ,p_audit_information4 => p_exempt_status_code
2279: ,p_audit_information5 => p_last_name_diff
2280: ,p_transaction_parent_id => ln_dummy
2281: ,p_stat_trans_audit_id => ln_parent_audit_id

Line 2302: ,p_source2 => fnd_number.number_to_canonical(l_fed_tax_rec.gre_id)

2298: ,p_person_id => ln_person_id
2299: ,p_assignment_id => l_fed_tax_rec.assignment_id
2300: ,p_source1 => '00-000-0000'
2301: ,p_source1_type => 'JURISDICTION'
2302: ,p_source2 => fnd_number.number_to_canonical(l_fed_tax_rec.gre_id)
2303: ,p_source2_type => 'GRE'
2304: ,p_source3 => lv_source_name --'ONLINE W4 FORM'
2305: ,p_source3_type => 'SOURCE_NAME'
2306: ,p_source4 => p_transaction_id

Line 2310: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)

2306: ,p_source4 => p_transaction_id
2307: ,p_source4_type => 'TRANSACTION_ID'
2308: ,p_audit_information_category => 'W4 FED'
2309: ,p_audit_information1 => lv_filing_status_code
2310: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)
2311: ,p_audit_information3 => fnd_number.number_to_canonical(p_additional_amount)
2312: ,p_audit_information4 => p_exempt_status_code
2313: ,p_audit_information5 => p_last_name_diff
2314: ,p_transaction_parent_id => ln_parent_audit_id

Line 2311: ,p_audit_information3 => fnd_number.number_to_canonical(p_additional_amount)

2307: ,p_source4_type => 'TRANSACTION_ID'
2308: ,p_audit_information_category => 'W4 FED'
2309: ,p_audit_information1 => lv_filing_status_code
2310: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)
2311: ,p_audit_information3 => fnd_number.number_to_canonical(p_additional_amount)
2312: ,p_audit_information4 => p_exempt_status_code
2313: ,p_audit_information5 => p_last_name_diff
2314: ,p_transaction_parent_id => ln_parent_audit_id
2315: ,p_stat_trans_audit_id => ln_dummy

Line 2712: ,p_source2 => fnd_number.number_to_canonical(l_state_tax_rec.gre_id)

2708: ,p_person_id => ln_person_id
2709: ,p_assignment_id => l_state_tax_rec.assignment_id
2710: ,p_source1 => l_state_tax_rec.state_code || '-000-0000'
2711: ,p_source1_type => 'JURISDICTION'
2712: ,p_source2 => fnd_number.number_to_canonical(l_state_tax_rec.gre_id)
2713: ,p_source2_type => 'GRE'
2714: ,p_source3 => lv_source_name --'ONLINE W4 FORM'
2715: ,p_source3_type => 'SOURCE_NAME'
2716: ,p_source4 => p_transaction_id

Line 2720: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)

2716: ,p_source4 => p_transaction_id
2717: ,p_source4_type => 'TRANSACTION_ID'
2718: ,p_audit_information_category => lv_context
2719: ,p_audit_information1 => lv_state_filing_status_code
2720: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)
2721: ,p_audit_information3 => fnd_number.number_to_canonical(NVL(l_state_tax_rec.sit_additional_tax, 0))
2722: --,p_audit_information4 => p_exempt_status_code
2723: ,p_audit_information4 => NVL(l_state_exempt, 'N') -- Bug# 6333947
2724: ,p_transaction_parent_id => ln_parent_audit_id

Line 2721: ,p_audit_information3 => fnd_number.number_to_canonical(NVL(l_state_tax_rec.sit_additional_tax, 0))

2717: ,p_source4_type => 'TRANSACTION_ID'
2718: ,p_audit_information_category => lv_context
2719: ,p_audit_information1 => lv_state_filing_status_code
2720: ,p_audit_information2 => fnd_number.number_to_canonical(p_allowances)
2721: ,p_audit_information3 => fnd_number.number_to_canonical(NVL(l_state_tax_rec.sit_additional_tax, 0))
2722: --,p_audit_information4 => p_exempt_status_code
2723: ,p_audit_information4 => NVL(l_state_exempt, 'N') -- Bug# 6333947
2724: ,p_transaction_parent_id => ln_parent_audit_id
2725: ,p_stat_trans_audit_id => ln_dummy