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

Line 356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,

352: employer_name_kana,
353: employer_name
354: from (
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,

Line 357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,

353: employer_name
354: from (
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
361: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_flag,

Line 358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,

354: from (
355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
361: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_flag,
362: hr_jp_standard_pkg.to_hankaku(min(decode(piv.display_sequence, 7, peev.screen_entry_value))) employer_address_kana,

Line 359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,

355: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) */
356: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 1, peev.screen_entry_value))), 0) employment_income,
357: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 2, peev.screen_entry_value))), 0) si_prems,
358: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 3, peev.screen_entry_value))), 0) mutual_aid_prem,
359: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 4, peev.screen_entry_value))), 0) withholding_tax,
360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,
361: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_flag,
362: hr_jp_standard_pkg.to_hankaku(min(decode(piv.display_sequence, 7, peev.screen_entry_value))) employer_address_kana,
363: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) employer_address,

Line 521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),

517: P_EMPLOYER_COUNTRY => l_prev_employer.employer_country,
518: P_PEM_INFORMATION_CATEGORY => 'JP',
519: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);

Line 522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),

518: P_PEM_INFORMATION_CATEGORY => 'JP',
519: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else

Line 523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),

519: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');

Line 524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),

520: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
521: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
522: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');
528: --

Line 549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),

545: P_EMPLOYER_ADDRESS => l_prev_job.employer_address,
546: P_PEM_INFORMATION_CATEGORY => 'JP',
547: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,

Line 550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),

546: P_PEM_INFORMATION_CATEGORY => 'JP',
547: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
554: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);

Line 551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),

547: P_PEM_INFORMATION1 => l_prev_job.employer_name_kana,
548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
554: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
555: end if;

Line 552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),

548: P_PEM_INFORMATION2 => l_prev_job.employer_address_kana,
549: P_PEM_INFORMATION3 => fnd_number.number_to_canonical(l_prev_job.employment_income),
550: P_PEM_INFORMATION4 => fnd_number.number_to_canonical(l_prev_job.si_prems),
551: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
552: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
553: P_PREVIOUS_EMPLOYER_ID => l_prev_employer.previous_employer_id,
554: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
555: end if;
556: close csr_prev_employer;

Line 1402: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)

1398: ,p_object_version_number => l_ovn
1399: ,p_effective_date => l_effective_date
1400: ,p_assignment_id => p_assignment_id
1401: ,p_action_information_category => 'JP_PRE_TAX_1'
1402: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1403: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1406: ,p_action_information5 => l_pre_tax.hi_organization_id

Line 1403: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)

1399: ,p_effective_date => l_effective_date
1400: ,p_assignment_id => p_assignment_id
1401: ,p_action_information_category => 'JP_PRE_TAX_1'
1402: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1403: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1406: ,p_action_information5 => l_pre_tax.hi_organization_id
1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)

Line 1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)

1400: ,p_assignment_id => p_assignment_id
1401: ,p_action_information_category => 'JP_PRE_TAX_1'
1402: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1403: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1406: ,p_action_information5 => l_pre_tax.hi_organization_id
1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)

Line 1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)

1401: ,p_action_information_category => 'JP_PRE_TAX_1'
1402: ,p_action_information1 => fnd_number.number_to_canonical(l_pre_tax.assignment_action_id)
1403: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1406: ,p_action_information5 => l_pre_tax.hi_organization_id
1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1409: ,p_action_information8 => l_pre_tax.wp_organization_id

Line 1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)

1403: ,p_action_information2 => fnd_number.number_to_canonical(l_pre_tax.taxable_sal_amt)
1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1406: ,p_action_information5 => l_pre_tax.hi_organization_id
1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1409: ,p_action_information8 => l_pre_tax.wp_organization_id
1410: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)

Line 1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)

1404: ,p_action_information3 => fnd_number.number_to_canonical(l_pre_tax.taxable_mat_amt)
1405: ,p_action_information4 => fnd_number.number_to_canonical(l_person_id)
1406: ,p_action_information5 => l_pre_tax.hi_organization_id
1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1409: ,p_action_information8 => l_pre_tax.wp_organization_id
1410: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1412: ,p_action_information11 => l_pre_tax.wpf_organization_id

Line 1410: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)

1406: ,p_action_information5 => l_pre_tax.hi_organization_id
1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1409: ,p_action_information8 => l_pre_tax.wp_organization_id
1410: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1412: ,p_action_information11 => l_pre_tax.wpf_organization_id
1413: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1414: ,p_action_information13 => l_pre_tax.salary_category

Line 1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)

1407: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_ee)
1408: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.hi_prem_er)
1409: ,p_action_information8 => l_pre_tax.wp_organization_id
1410: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1412: ,p_action_information11 => l_pre_tax.wpf_organization_id
1413: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1414: ,p_action_information13 => l_pre_tax.salary_category
1415: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)

Line 1413: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)

1409: ,p_action_information8 => l_pre_tax.wp_organization_id
1410: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_ee)
1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1412: ,p_action_information11 => l_pre_tax.wpf_organization_id
1413: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1414: ,p_action_information13 => l_pre_tax.salary_category
1415: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1416: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
1417: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')

Line 1415: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)

1411: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.wp_prem_er)
1412: ,p_action_information11 => l_pre_tax.wpf_organization_id
1413: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1414: ,p_action_information13 => l_pre_tax.salary_category
1415: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1416: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
1417: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1418: ,p_action_information17 => l_leaving_reason
1419: ,p_action_information18 => to_char(l_actual_termination_date,'YYYY/MM/DD')

Line 1416: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)

1412: ,p_action_information11 => l_pre_tax.wpf_organization_id
1413: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_ee)
1414: ,p_action_information13 => l_pre_tax.salary_category
1415: ,p_action_information14 => fnd_number.number_to_canonical(l_pre_tax.mutual_aid)
1416: ,p_action_information15 => fnd_number.number_to_canonical(l_period_of_service_id)
1417: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1418: ,p_action_information17 => l_leaving_reason
1419: ,p_action_information18 => to_char(l_actual_termination_date,'YYYY/MM/DD')
1420: ,p_action_information19 => l_pre_tax.ui_organization_id

Line 1421: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.ui_prem_ee)

1417: ,p_action_information16 => to_char(l_date_start,'YYYY/MM/DD')
1418: ,p_action_information17 => l_leaving_reason
1419: ,p_action_information18 => to_char(l_actual_termination_date,'YYYY/MM/DD')
1420: ,p_action_information19 => l_pre_tax.ui_organization_id
1421: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.ui_prem_ee)
1422: ,p_action_information21 => l_pre_tax.itax_organization_id
1423: ,p_action_information22 => l_pre_tax.itax_category
1424: ,p_action_information23 => l_pre_tax.itax_yea_category
1425: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)

Line 1425: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)

1421: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.ui_prem_ee)
1422: ,p_action_information21 => l_pre_tax.itax_organization_id
1423: ,p_action_information22 => l_pre_tax.itax_category
1424: ,p_action_information23 => l_pre_tax.itax_yea_category
1425: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1426: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1427: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1428: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1429: ,p_action_information30 => l_employment_category

Line 1426: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)

1422: ,p_action_information21 => l_pre_tax.itax_organization_id
1423: ,p_action_information22 => l_pre_tax.itax_category
1424: ,p_action_information23 => l_pre_tax.itax_yea_category
1425: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1426: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1427: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1428: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1429: ,p_action_information30 => l_employment_category
1430: );

Line 1427: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)

1423: ,p_action_information22 => l_pre_tax.itax_category
1424: ,p_action_information23 => l_pre_tax.itax_yea_category
1425: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1426: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1427: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1428: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1429: ,p_action_information30 => l_employment_category
1430: );
1431:

Line 1428: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)

1424: ,p_action_information23 => l_pre_tax.itax_yea_category
1425: ,p_action_information24 => fnd_number.number_to_canonical(l_pre_tax.itax)
1426: ,p_action_information25 => fnd_number.number_to_canonical(l_pre_tax.itax_adjustment)
1427: ,p_action_information26 => fnd_number.number_to_canonical(l_pre_tax.pre_tax_id)
1428: ,p_action_information29 => fnd_number.number_to_canonical(l_pre_tax.disaster_tax_reduction)
1429: ,p_action_information30 => l_employment_category
1430: );
1431:
1432: pay_action_information_api.create_action_information

Line 1443: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)

1439: ,p_assignment_id => p_assignment_id
1440: ,p_action_information_category => 'JP_PRE_TAX_2'
1441: ,p_action_information1 => l_pre_tax.assignment_action_id
1442: ,p_action_information3 => l_pre_tax.ltax_district_code
1443: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)

Line 1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)

1440: ,p_action_information_category => 'JP_PRE_TAX_2'
1441: ,p_action_information1 => l_pre_tax.assignment_action_id
1442: ,p_action_information3 => l_pre_tax.ltax_district_code
1443: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)

Line 1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)

1441: ,p_action_information1 => l_pre_tax.assignment_action_id
1442: ,p_action_information3 => l_pre_tax.ltax_district_code
1443: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)

Line 1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)

1442: ,p_action_information3 => l_pre_tax.ltax_district_code
1443: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)

Line 1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)

1443: ,p_action_information5 => fnd_number.number_to_canonical(l_pre_tax.ltax)
1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1451: ,p_action_information13 => fnd_number.number_to_canonical(0)

Line 1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)

1444: ,p_action_information6 => fnd_number.number_to_canonical(l_pre_tax.ltax_lumpsum)
1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1451: ,p_action_information13 => fnd_number.number_to_canonical(0)
1452: ,p_action_information14 => l_pre_tax.ui_category

Line 1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)

1445: ,p_action_information7 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax)
1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1451: ,p_action_information13 => fnd_number.number_to_canonical(0)
1452: ,p_action_information14 => l_pre_tax.ui_category
1453: ,p_action_information15 => l_pre_tax.sp_ltax_district_code

Line 1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)

1446: ,p_action_information8 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_income)
1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1451: ,p_action_information13 => fnd_number.number_to_canonical(0)
1452: ,p_action_information14 => l_pre_tax.ui_category
1453: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1454: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)

Line 1451: ,p_action_information13 => fnd_number.number_to_canonical(0)

1447: ,p_action_information9 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_shi)
1448: ,p_action_information10 => fnd_number.number_to_canonical(l_pre_tax.sp_ltax_to)
1449: ,p_action_information11 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_ee)
1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1451: ,p_action_information13 => fnd_number.number_to_canonical(0)
1452: ,p_action_information14 => l_pre_tax.ui_category
1453: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1454: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1455: ,p_action_information17 => l_pre_tax.wai_organization_id

Line 1454: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)

1450: ,p_action_information12 => fnd_number.number_to_canonical(l_pre_tax.ci_prem_er)
1451: ,p_action_information13 => fnd_number.number_to_canonical(0)
1452: ,p_action_information14 => l_pre_tax.ui_category
1453: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1454: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1455: ,p_action_information17 => l_pre_tax.wai_organization_id
1456: ,p_action_information18 => l_pre_tax.wai_category
1457: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1458: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)

Line 1457: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)

1453: ,p_action_information15 => l_pre_tax.sp_ltax_district_code
1454: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1455: ,p_action_information17 => l_pre_tax.wai_organization_id
1456: ,p_action_information18 => l_pre_tax.wai_category
1457: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1458: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1459: ,p_action_information21 => fnd_number.number_to_canonical(0)
1460: );
1461:

Line 1458: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)

1454: ,p_action_information16 => fnd_number.number_to_canonical(l_pre_tax.ui_sal_amt)
1455: ,p_action_information17 => l_pre_tax.wai_organization_id
1456: ,p_action_information18 => l_pre_tax.wai_category
1457: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1458: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1459: ,p_action_information21 => fnd_number.number_to_canonical(0)
1460: );
1461:
1462: end loop;

Line 1459: ,p_action_information21 => fnd_number.number_to_canonical(0)

1455: ,p_action_information17 => l_pre_tax.wai_organization_id
1456: ,p_action_information18 => l_pre_tax.wai_category
1457: ,p_action_information19 => fnd_number.number_to_canonical(l_pre_tax.wai_sal_amt)
1458: ,p_action_information20 => fnd_number.number_to_canonical(l_pre_tax.wpf_prem_er)
1459: ,p_action_information21 => fnd_number.number_to_canonical(0)
1460: );
1461:
1462: end loop;
1463: --

Line 1729: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));

1725: --
1726: for l_pact in csr_pacts loop
1727: p_valid_upgrade := 'TRUE';
1728: --
1729: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1730: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1731: l_include_terminated_flag := 'Y';
1732: l_termination_date_from := null;
1733: l_termination_date_to := null;

Line 1730: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));

1726: for l_pact in csr_pacts loop
1727: p_valid_upgrade := 'TRUE';
1728: --
1729: l_payroll_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL', l_pact.legislative_parameters));
1730: l_itax_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('SWOT', l_pact.legislative_parameters));
1731: l_include_terminated_flag := 'Y';
1732: l_termination_date_from := null;
1733: l_termination_date_to := null;
1734: l_rearchive_flag := 'Y';

Line 1741: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));

1737: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));
1738: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1739: --
1740: l_legislative_parameters := null;
1741: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));
1742: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));
1743: concat_parameter('INCLUDE_TERMINATED_FLAG', l_include_terminated_flag);
1744: concat_parameter('TERMINATION_DATE_FROM', fnd_date.date_to_canonical(l_termination_date_from));
1745: concat_parameter('TERMINATION_DATE_TO', fnd_date.date_to_canonical(l_termination_date_to));

Line 1742: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));

1738: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));
1739: --
1740: l_legislative_parameters := null;
1741: concat_parameter('PAYROLL_ID', fnd_number.number_to_canonical(l_payroll_id));
1742: concat_parameter('ITAX_ORGANIZATION_ID', fnd_number.number_to_canonical(l_itax_organization_id));
1743: concat_parameter('INCLUDE_TERMINATED_FLAG', l_include_terminated_flag);
1744: concat_parameter('TERMINATION_DATE_FROM', fnd_date.date_to_canonical(l_termination_date_from));
1745: concat_parameter('TERMINATION_DATE_TO', fnd_date.date_to_canonical(l_termination_date_to));
1746: concat_parameter('REARCHIVE_FLAG', l_rearchive_flag);

Line 1766: p_action_information1 => fnd_number.number_to_canonical(l_payroll_id),

1762: p_action_context_id => l_pact.payroll_action_id,
1763: p_action_context_type => 'PA',
1764: p_action_information_category => 'JP_ITAX_PACT',
1765: p_effective_date => l_pact.effective_date,
1766: p_action_information1 => fnd_number.number_to_canonical(l_payroll_id),
1767: p_action_information2 => fnd_number.number_to_canonical(l_itax_organization_id),
1768: p_action_information3 => l_include_terminated_flag,
1769: p_action_information4 => fnd_date.date_to_canonical(l_termination_date_from),
1770: p_action_information5 => fnd_date.date_to_canonical(l_termination_date_to),

Line 1767: p_action_information2 => fnd_number.number_to_canonical(l_itax_organization_id),

1763: p_action_context_type => 'PA',
1764: p_action_information_category => 'JP_ITAX_PACT',
1765: p_effective_date => l_pact.effective_date,
1766: p_action_information1 => fnd_number.number_to_canonical(l_payroll_id),
1767: p_action_information2 => fnd_number.number_to_canonical(l_itax_organization_id),
1768: p_action_information3 => l_include_terminated_flag,
1769: p_action_information4 => fnd_date.date_to_canonical(l_termination_date_from),
1770: p_action_information5 => fnd_date.date_to_canonical(l_termination_date_to),
1771: p_action_information6 => l_publication_period_status,

Line 3026: argument7 => fnd_number.number_to_canonical(l_business_group_id), -- Business Grp

3022: argument3 => 'DEFAULT', -- Rpt Qual
3023: argument4 => null, -- Start Date
3024: argument5 => null, -- End Date
3025: argument6 => 'PROCESS', -- Rpt Category
3026: argument7 => fnd_number.number_to_canonical(l_business_group_id), -- Business Grp
3027: argument8 => null, -- Mag File Nme
3028: argument9 => null, -- Rep File Nme
3029: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID
3030: argument11 => p_upgrade_short_name, -- Short Name

Line 3029: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID

3025: argument6 => 'PROCESS', -- Rpt Category
3026: argument7 => fnd_number.number_to_canonical(l_business_group_id), -- Business Grp
3027: argument8 => null, -- Mag File Nme
3028: argument9 => null, -- Rep File Nme
3029: argument10 => fnd_number.number_to_canonical(l_upgrade_def.upgrade_definition_id), -- ID
3030: argument11 => p_upgrade_short_name, -- Short Name
3031: argument12 => 'UPG_DEF_NAME=' || p_upgrade_short_name); -- Upgrade Name
3032: if l_request_id = 0 then
3033: hr_utility.raise_error;