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

Line 299: select nvl(fnd_number.canonical_to_number (global_value),0)

295: cursor get_global_value (
296: p_global_name varchar2,
297: p_effective_date date
298: ) is
299: select nvl(fnd_number.canonical_to_number (global_value),0)
300: from ff_globals_f
301: where legislation_code = 'NO' and global_name = p_global_name
302: and p_effective_date between effective_start_date and effective_end_date ;
303:

Line 656: fnd_number.canonical_to_number (screen_entry_value) entry_value

652: c_eff_start_date date,
653: c_eff_end_date date
654: ) is
655: select effective_start_date,
656: fnd_number.canonical_to_number (screen_entry_value) entry_value
657: from pay_element_entry_values_f peev
658: where element_entry_id = c_element_entry_id
659: and effective_start_date between c_eff_start_date and c_eff_end_date
660: and screen_entry_value is not null

Line 676: select fnd_number.canonical_to_number (screen_entry_value) entry_value

672: cursor csr_get_curr_element_value (
673: c_element_entry_id number,
674: c_effective_date date
675: ) is
676: select fnd_number.canonical_to_number (screen_entry_value) entry_value
677: from pay_element_entry_values_f
678: where element_entry_id = c_element_entry_id
679: and c_effective_date between effective_start_date
680: and effective_end_date

Line 1492: l_hour_value_primary := fnd_number.canonical_to_number (

1488:
1489: l_hour_year_change_flag := 'Y';
1490:
1491: begin
1492: l_hour_value_primary := fnd_number.canonical_to_number (
1493: nvl (
1494: l_detailed_output (
1495: cnt
1496: ).new_value,

Line 1557: l_new_hour := fnd_number.canonical_to_number (

1553: l_detailed_output.first .. l_detailed_output.last
1554: loop
1555: begin
1556: l_new_hour := 0;
1557: l_new_hour := fnd_number.canonical_to_number (
1558: nvl (
1559: l_detailed_output (
1560: cnt1
1561: ).new_value,

Line 1643: fnd_number.canonical_to_number (

1639: l_detailed_output (cnt).effective_date;
1640: end if;
1641:
1642: l_job_id :=
1643: fnd_number.canonical_to_number (
1644: nvl (
1645: l_detailed_output (cnt).new_value,
1646: fnd_number.canonical_to_number (
1647: substr (

Line 1646: fnd_number.canonical_to_number (

1642: l_job_id :=
1643: fnd_number.canonical_to_number (
1644: nvl (
1645: l_detailed_output (cnt).new_value,
1646: fnd_number.canonical_to_number (
1647: substr (
1648: l_detailed_output (cnt).change_values,
1649: instr (
1650: l_detailed_output (cnt).change_values,

Line 1677: fnd_number.canonical_to_number (

1673: l_local_unit_value := nvl (
1674: l_detailed_output (
1675: cnt
1676: ).new_value,
1677: fnd_number.canonical_to_number (
1678: substr (
1679: l_detailed_output (
1680: cnt
1681: ).change_values,

Line 1692: /* open csr_get_org_no (fnd_number.canonical_to_number (l_local_unit_value));

1688: + 3
1689: )
1690: )
1691: );
1692: /* open csr_get_org_no (fnd_number.canonical_to_number (l_local_unit_value));
1693: fetch csr_get_org_no into l_lu_org_no;
1694: close csr_get_org_no;*/
1695: l_old_scl := substr (
1696: l_detailed_output (cnt).change_values,

Line 1716: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));

1712:
1713: if l_old_scl = ' ' then
1714: l_old_scl := '0';
1715: l_local_unit_value := l_new_scl;
1716: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
1717: fetch csr_get_pos_scl into l_job_value;
1718: close csr_get_pos_scl;
1719:
1720: if l_detailed_output (cnt).effective_date >

Line 1734: fnd_number.canonical_to_number (

1730: end if;
1731:
1732: /* l_local_unit_value := nvl (
1733: l_detailed_output (cnt).new_value,
1734: fnd_number.canonical_to_number (
1735: substr (
1736: l_detailed_output (cnt).change_values,
1737: instr (
1738: l_detailed_output (cnt).change_values,

Line 1745: open csr_get_org_no (fnd_number.canonical_to_number (l_new_scl));

1741: + 3
1742: )
1743: )
1744: );*/
1745: open csr_get_org_no (fnd_number.canonical_to_number (l_new_scl));
1746: fetch csr_get_org_no into l_lu_org_no;
1747: close csr_get_org_no;
1748: else
1749: /* Code for Local Unit */

Line 1750: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));

1746: fetch csr_get_org_no into l_lu_org_no;
1747: close csr_get_org_no;
1748: else
1749: /* Code for Local Unit */
1750: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));
1751: fetch csr_get_lu_scl into l_new_lu;
1752: close csr_get_lu_scl;
1753:
1754: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));

Line 1754: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));

1750: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));
1751: fetch csr_get_lu_scl into l_new_lu;
1752: close csr_get_lu_scl;
1753:
1754: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));
1755: fetch csr_get_lu_scl into l_old_lu;
1756: close csr_get_lu_scl;
1757:
1758: if l_old_lu <> l_new_lu then

Line 1767: fnd_number.canonical_to_number (l_new_scl)

1763: ).effective_date;
1764: end if;
1765:
1766: open csr_get_org_no (
1767: fnd_number.canonical_to_number (l_new_scl)
1768: );
1769: fetch csr_get_org_no into l_lu_org_no;
1770: close csr_get_org_no;
1771: end if;

Line 1776: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));

1772:
1773: /* End Code for Local Unit */
1774:
1775: /* Code for Position Code */
1776: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
1777: fetch csr_get_pos_scl into l_new_job_value;
1778: close csr_get_pos_scl;
1779:
1780: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));

Line 1780: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));

1776: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
1777: fetch csr_get_pos_scl into l_new_job_value;
1778: close csr_get_pos_scl;
1779:
1780: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));
1781: fetch csr_get_pos_scl into l_old_job_value;
1782: close csr_get_pos_scl;
1783:
1784: if l_new_job_value <> l_old_job_value then

Line 1823: fnd_number.canonical_to_number (l_detailed_output (cnt).new_value)

1819: elsif l_detailed_output (cnt).column_name =
1820: 'ASSIGNMENT_STATUS_TYPE_ID' then
1821:
1822: open csr_get_assignment_status (
1823: fnd_number.canonical_to_number (l_detailed_output (cnt).new_value)
1824: );
1825: fetch csr_get_assignment_status into l_user_status;
1826: close csr_get_assignment_status;
1827:

Line 1829: fnd_number.canonical_to_number (l_detailed_output (cnt).old_value)

1825: fetch csr_get_assignment_status into l_user_status;
1826: close csr_get_assignment_status;
1827:
1828: open csr_get_assignment_status (
1829: fnd_number.canonical_to_number (l_detailed_output (cnt).old_value)
1830: );
1831: fetch csr_get_assignment_status into l_old_user_status;
1832: close csr_get_assignment_status;
1833:

Line 1979: p_action_information12 => fnd_number.number_to_canonical(l_hour_value) -- Weekly Working Hours

1975: l_emp_start_date
1976: ) -- Employment Start Date
1977: --,p_action_information16 => p_time_period_id
1978: ,
1979: p_action_information12 => fnd_number.number_to_canonical(l_hour_value) -- Weekly Working Hours
1980: ,
1981: p_action_information13 => fnd_date.date_to_canonical (
1982: l_hour_change_effective_date
1983: ) -- Date of change of hours

Line 2332: round (fnd_number.canonical_to_number (j.action_information12));

2328: to_char (j.action_information11, 'DDMMRRRR');
2329: l_counter := l_counter + 1;
2330: xml_tab (l_counter).tagname := 'WORKING_HOURS';
2331: xml_tab (l_counter).tagvalue :=
2332: round (fnd_number.canonical_to_number (j.action_information12));
2333: l_counter := l_counter + 1;
2334: --
2335: --
2336: xml_tab (l_counter).tagname := 'HOUR_CHANGE_DATE';

Line 2627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));

2623: l_check_value := hr_no_utility.chk_valid_date (l_return_value);
2624:
2625: if l_check_value <> 0 then
2626: /* Valid Birthdate */
2627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));

Line 2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));

2624:
2625: if l_check_value <> 0 then
2626: /* Valid Birthdate */
2627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));

Line 2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));

2625: if l_check_value <> 0 then
2626: /* Valid Birthdate */
2627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));

Line 2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));

2626: /* Valid Birthdate */
2627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));

Line 2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));

2627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));

Line 2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));

2628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));

Line 2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));

2629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));

Line 2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));

2630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;

Line 2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));

2631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
2639:

Line 2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));

2632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
2639:
2640:

Line 2637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));

2633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
2639:
2640:
2641: l_remainder := mod (v1, 11);