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_DATE

Line 360: fnd_date.canonical_to_date(min(decode(piv.display_sequence, 5, peev.screen_entry_value))) termination_date,

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,
364: hr_jp_standard_pkg.to_hankaku(min(decode(piv.display_sequence, 9, peev.screen_entry_value))) employer_name_kana,

Line 1737: l_publication_start_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('OPEN_DATE', l_pact.legislative_parameters));

1733: l_termination_date_to := null;
1734: l_rearchive_flag := 'Y';
1735: l_inherit_archive_flag := 'Y';
1736: l_publication_period_status := 'O';
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));

Line 1738: l_publication_end_date := fnd_date.canonical_to_date(pay_core_utils.get_parameter('CLOSE_DATE', l_pact.legislative_parameters));

1734: l_rearchive_flag := 'Y';
1735: l_inherit_archive_flag := 'Y';
1736: l_publication_period_status := 'O';
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));

Line 1744: concat_parameter('TERMINATION_DATE_FROM', fnd_date.date_to_canonical(l_termination_date_from));

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);
1747: concat_parameter('INHERIT_ARCHIVE_FLAG', l_inherit_archive_flag);
1748: concat_parameter('PUBLICATION_PERIOD_STATUS', l_publication_period_status);

Line 1745: concat_parameter('TERMINATION_DATE_TO', fnd_date.date_to_canonical(l_termination_date_to));

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);
1747: concat_parameter('INHERIT_ARCHIVE_FLAG', l_inherit_archive_flag);
1748: concat_parameter('PUBLICATION_PERIOD_STATUS', l_publication_period_status);
1749: concat_parameter('PUBLICATION_START_DATE', fnd_date.date_to_canonical(l_publication_start_date));

Line 1749: concat_parameter('PUBLICATION_START_DATE', fnd_date.date_to_canonical(l_publication_start_date));

1745: concat_parameter('TERMINATION_DATE_TO', fnd_date.date_to_canonical(l_termination_date_to));
1746: concat_parameter('REARCHIVE_FLAG', l_rearchive_flag);
1747: concat_parameter('INHERIT_ARCHIVE_FLAG', l_inherit_archive_flag);
1748: concat_parameter('PUBLICATION_PERIOD_STATUS', l_publication_period_status);
1749: concat_parameter('PUBLICATION_START_DATE', fnd_date.date_to_canonical(l_publication_start_date));
1750: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));
1751: concat_parameter('UPGRADE_FLAG', 'Y');
1752: --
1753: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);

Line 1750: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));

1746: concat_parameter('REARCHIVE_FLAG', l_rearchive_flag);
1747: concat_parameter('INHERIT_ARCHIVE_FLAG', l_inherit_archive_flag);
1748: concat_parameter('PUBLICATION_PERIOD_STATUS', l_publication_period_status);
1749: concat_parameter('PUBLICATION_START_DATE', fnd_date.date_to_canonical(l_publication_start_date));
1750: concat_parameter('PUBLICATION_END_DATE', fnd_date.date_to_canonical(l_publication_end_date));
1751: concat_parameter('UPGRADE_FLAG', 'Y');
1752: --
1753: hr_utility.trace('payroll_action_id: ' || l_pact.payroll_action_id);
1754: hr_utility.trace('legislative_parameters: ' || l_legislative_parameters);

Line 1769: p_action_information4 => fnd_date.date_to_canonical(l_termination_date_from),

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,
1772: p_action_information7 => fnd_date.date_to_canonical(l_publication_start_date),
1773: p_action_information8 => fnd_date.date_to_canonical(l_publication_end_date),

Line 1770: p_action_information5 => fnd_date.date_to_canonical(l_termination_date_to),

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,
1772: p_action_information7 => fnd_date.date_to_canonical(l_publication_start_date),
1773: p_action_information8 => fnd_date.date_to_canonical(l_publication_end_date),
1774: p_action_information_id => l_id,

Line 1772: p_action_information7 => fnd_date.date_to_canonical(l_publication_start_date),

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,
1772: p_action_information7 => fnd_date.date_to_canonical(l_publication_start_date),
1773: p_action_information8 => fnd_date.date_to_canonical(l_publication_end_date),
1774: p_action_information_id => l_id,
1775: p_object_version_number => l_ovn);
1776: end loop;

Line 1773: p_action_information8 => fnd_date.date_to_canonical(l_publication_end_date),

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,
1772: p_action_information7 => fnd_date.date_to_canonical(l_publication_start_date),
1773: p_action_information8 => fnd_date.date_to_canonical(l_publication_end_date),
1774: p_action_information_id => l_id,
1775: p_object_version_number => l_ovn);
1776: end loop;
1777: --

Line 1831: l_str := fnd_date.date_to_canonical(hr_jp_standard_pkg.to_jp_date(l_str, 'EYYMMDD'));

1827: l_str varchar2(30) := p_str;
1828: begin
1829: if l_str is not null then
1830: if length(l_str) = 7 then
1831: l_str := fnd_date.date_to_canonical(hr_jp_standard_pkg.to_jp_date(l_str, 'EYYMMDD'));
1832: elsif length(l_str) = 10 then
1833: l_str := fnd_date.date_to_canonical(to_date(l_str, 'YYYY/MM/DD'));
1834: end if;
1835: end if;

Line 1833: l_str := fnd_date.date_to_canonical(to_date(l_str, 'YYYY/MM/DD'));

1829: if l_str is not null then
1830: if length(l_str) = 7 then
1831: l_str := fnd_date.date_to_canonical(hr_jp_standard_pkg.to_jp_date(l_str, 'EYYMMDD'));
1832: elsif length(l_str) = 10 then
1833: l_str := fnd_date.date_to_canonical(to_date(l_str, 'YYYY/MM/DD'));
1834: end if;
1835: end if;
1836: --
1837: return l_str;