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_JP_IWHT_ARCH_PKG dependencies on FND_NUMBER

Line 179: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',legislative_parameters))

175: --**********************************************************************
176: IS
177: SELECT business_group_id
178: ,effective_date
179: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',legislative_parameters))
180: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters))
181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))
182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))
183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))

Line 180: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters))

176: IS
177: SELECT business_group_id
178: ,effective_date
179: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',legislative_parameters))
180: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters))
181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))
182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))
183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))
184: ,pay_core_utils.get_parameter('REARCHIVE_FLAG',legislative_parameters)

Line 183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))

179: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',legislative_parameters))
180: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters))
181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))
182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))
183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))
184: ,pay_core_utils.get_parameter('REARCHIVE_FLAG',legislative_parameters)
185: FROM pay_payroll_actions PPA
186: WHERE PPA.payroll_action_id = p_payroll_action_id;
187: -- Local Variables

Line 1385: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)

1381: ,p_source_id => NULL
1382: ,p_source_text => NULL
1383: ,p_tax_group => NULL
1384: ,p_effective_date => p_effective_date
1385: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)
1386: ,p_action_information1 => lr_emp_rec.employee_number
1387: ,p_action_information2 => lr_emp_rec.last_name_kana
1388: ,p_action_information3 => lr_emp_rec.first_name_kana
1389: ,p_action_information4 => lr_emp_rec.last_name_kanji

Line 1440: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)

1436: ,p_source_id => NULL
1437: ,p_source_text => NULL
1438: ,p_tax_group => NULL
1439: ,p_effective_date => p_effective_date
1440: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)
1441: ,p_action_information1 => NVL(lc_note_submit_flag,'N')
1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)
1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)

Line 1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)

1438: ,p_tax_group => NULL
1439: ,p_effective_date => p_effective_date
1440: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)
1441: ,p_action_information1 => NVL(lc_note_submit_flag,'N')
1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)
1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)

Line 1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)

1439: ,p_effective_date => p_effective_date
1440: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)
1441: ,p_action_information1 => NVL(lc_note_submit_flag,'N')
1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)
1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)
1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)

Line 1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)

1440: ,p_assignment_id => fnd_number.number_to_canonical(lr_emp_rec.assignment_id)
1441: ,p_action_information1 => NVL(lc_note_submit_flag,'N')
1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)
1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)
1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)
1448: ,p_action_information8 => fnd_date.date_to_canonical(ld_date_earned)

Line 1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)

1441: ,p_action_information1 => NVL(lc_note_submit_flag,'N')
1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)
1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)
1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)
1448: ,p_action_information8 => fnd_date.date_to_canonical(ld_date_earned)
1449: ,p_action_information_id => ln_tax_action_info_id

Line 1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)

1442: ,p_action_information2 => fnd_number.number_to_canonical(ln_termination_money)
1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)
1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)
1448: ,p_action_information8 => fnd_date.date_to_canonical(ld_date_earned)
1449: ,p_action_information_id => ln_tax_action_info_id
1450: ,p_object_version_number => ln_tax_obj_version_num