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 303: select nvl(fnd_number.canonical_to_number (global_value),0)

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

Line 832: fnd_number.canonical_to_number (screen_entry_value) entry_value

828: c_eff_start_date date,
829: c_eff_end_date date
830: ) is
831: select effective_start_date,
832: fnd_number.canonical_to_number (screen_entry_value) entry_value
833: from pay_element_entry_values_f peev
834: where element_entry_id = c_element_entry_id
835: and effective_start_date between c_eff_start_date and c_eff_end_date
836: and screen_entry_value is not null

Line 852: select fnd_number.canonical_to_number (screen_entry_value) entry_value

848: cursor csr_get_curr_element_value (
849: c_element_entry_id number,
850: c_effective_date date
851: ) is
852: select fnd_number.canonical_to_number (screen_entry_value) entry_value
853: from pay_element_entry_values_f
854: where element_entry_id = c_element_entry_id
855: and c_effective_date between effective_start_date
856: and effective_end_date

Line 1669: l_hour_value_primary := fnd_number.canonical_to_number (

1665:
1666: l_hour_year_change_flag := 'Y';
1667:
1668: begin
1669: l_hour_value_primary := fnd_number.canonical_to_number (
1670: nvl (
1671: l_detailed_output (
1672: cnt
1673: ).new_value,

Line 1734: l_new_hour := fnd_number.canonical_to_number (

1730: l_detailed_output.first .. l_detailed_output.last
1731: loop
1732: begin
1733: l_new_hour := 0;
1734: l_new_hour := fnd_number.canonical_to_number (
1735: nvl (
1736: l_detailed_output (
1737: cnt1
1738: ).new_value,

Line 1820: fnd_number.canonical_to_number (

1816: l_detailed_output (cnt).effective_date;
1817: end if;
1818:
1819: l_job_id :=
1820: fnd_number.canonical_to_number (
1821: nvl (
1822: l_detailed_output (cnt).new_value,
1823: fnd_number.canonical_to_number (
1824: substr (

Line 1823: fnd_number.canonical_to_number (

1819: l_job_id :=
1820: fnd_number.canonical_to_number (
1821: nvl (
1822: l_detailed_output (cnt).new_value,
1823: fnd_number.canonical_to_number (
1824: substr (
1825: l_detailed_output (cnt).change_values,
1826: instr (
1827: l_detailed_output (cnt).change_values,

Line 1854: fnd_number.canonical_to_number (

1850: l_local_unit_value := nvl (
1851: l_detailed_output (
1852: cnt
1853: ).new_value,
1854: fnd_number.canonical_to_number (
1855: substr (
1856: l_detailed_output (
1857: cnt
1858: ).change_values,

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

1865: + 3
1866: )
1867: )
1868: );
1869: /* open csr_get_org_no (fnd_number.canonical_to_number (l_local_unit_value));
1870: fetch csr_get_org_no into l_lu_org_no;
1871: close csr_get_org_no;*/
1872: l_old_scl := substr (
1873: l_detailed_output (cnt).change_values,

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

1889:
1890: if l_old_scl = ' ' then
1891: l_old_scl := '0';
1892: l_local_unit_value := l_new_scl;
1893: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
1894: fetch csr_get_pos_scl into l_job_value;
1895: close csr_get_pos_scl;
1896:
1897: if l_detailed_output (cnt).effective_date >

Line 1911: fnd_number.canonical_to_number (

1907: end if;
1908:
1909: /* l_local_unit_value := nvl (
1910: l_detailed_output (cnt).new_value,
1911: fnd_number.canonical_to_number (
1912: substr (
1913: l_detailed_output (cnt).change_values,
1914: instr (
1915: l_detailed_output (cnt).change_values,

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

1918: + 3
1919: )
1920: )
1921: );*/
1922: open csr_get_org_no (fnd_number.canonical_to_number (l_new_scl));
1923: fetch csr_get_org_no into l_lu_org_no;
1924: close csr_get_org_no;
1925: else
1926: /* Code for Local Unit */

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

1923: fetch csr_get_org_no into l_lu_org_no;
1924: close csr_get_org_no;
1925: else
1926: /* Code for Local Unit */
1927: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));
1928: fetch csr_get_lu_scl into l_new_lu;
1929: close csr_get_lu_scl;
1930:
1931: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));

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

1927: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));
1928: fetch csr_get_lu_scl into l_new_lu;
1929: close csr_get_lu_scl;
1930:
1931: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));
1932: fetch csr_get_lu_scl into l_old_lu;
1933: close csr_get_lu_scl;
1934:
1935: if l_old_lu <> l_new_lu then

Line 1944: fnd_number.canonical_to_number (l_new_scl)

1940: ).effective_date;
1941: end if;
1942:
1943: open csr_get_org_no (
1944: fnd_number.canonical_to_number (l_new_scl)
1945: );
1946: fetch csr_get_org_no into l_lu_org_no;
1947: close csr_get_org_no;
1948: end if;

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

1949:
1950: /* End Code for Local Unit */
1951:
1952: /* Code for Position Code */
1953: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
1954: fetch csr_get_pos_scl into l_new_job_value;
1955: close csr_get_pos_scl;
1956:
1957: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));

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

1953: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
1954: fetch csr_get_pos_scl into l_new_job_value;
1955: close csr_get_pos_scl;
1956:
1957: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));
1958: fetch csr_get_pos_scl into l_old_job_value;
1959: close csr_get_pos_scl;
1960:
1961: if l_new_job_value <> l_old_job_value then

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

1996: elsif l_detailed_output (cnt).column_name =
1997: 'ASSIGNMENT_STATUS_TYPE_ID' then
1998:
1999: open csr_get_assignment_status (
2000: fnd_number.canonical_to_number (l_detailed_output (cnt).new_value)
2001: );
2002: fetch csr_get_assignment_status into l_user_status;
2003: close csr_get_assignment_status;
2004:

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

2002: fetch csr_get_assignment_status into l_user_status;
2003: close csr_get_assignment_status;
2004:
2005: open csr_get_assignment_status (
2006: fnd_number.canonical_to_number (l_detailed_output (cnt).old_value)
2007: );
2008: fetch csr_get_assignment_status into l_old_user_status;
2009: close csr_get_assignment_status;
2010:

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

2152: l_emp_start_date
2153: ) -- Employment Start Date
2154: --,p_action_information16 => p_time_period_id
2155: ,
2156: p_action_information12 => fnd_number.number_to_canonical(l_hour_value) -- Weekly Working Hours
2157: ,
2158: p_action_information13 => fnd_date.date_to_canonical (
2159: l_hour_change_effective_date
2160: ) -- Date of change of hours

Line 2509: -- round (fnd_number.canonical_to_number (j.action_information12));--14507939

2505: to_char (j.action_information11, 'DDMMRRRR');
2506: l_counter := l_counter + 1;
2507: xml_tab (l_counter).tagname := 'WORKING_HOURS';
2508: xml_tab (l_counter).tagvalue :=
2509: -- round (fnd_number.canonical_to_number (j.action_information12));--14507939
2510: to_char(fnd_number.canonical_to_number (j.action_information12)*100,'fm0000');
2511: l_counter := l_counter + 1;
2512: --
2513: --

Line 2510: to_char(fnd_number.canonical_to_number (j.action_information12)*100,'fm0000');

2506: l_counter := l_counter + 1;
2507: xml_tab (l_counter).tagname := 'WORKING_HOURS';
2508: xml_tab (l_counter).tagvalue :=
2509: -- round (fnd_number.canonical_to_number (j.action_information12));--14507939
2510: to_char(fnd_number.canonical_to_number (j.action_information12)*100,'fm0000');
2511: l_counter := l_counter + 1;
2512: --
2513: --
2514: xml_tab (l_counter).tagname := 'HOUR_CHANGE_DATE';

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

2801: l_check_value := hr_no_utility.chk_valid_date (l_return_value);
2802:
2803: if l_check_value <> 0 then
2804: /* Valid Birthdate */
2805: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2806: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));

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

2802:
2803: if l_check_value <> 0 then
2804: /* Valid Birthdate */
2805: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2806: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));

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

2803: if l_check_value <> 0 then
2804: /* Valid Birthdate */
2805: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2806: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));

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

2804: /* Valid Birthdate */
2805: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2806: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));

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

2805: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
2806: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));

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

2806: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2814: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));

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

2807: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2814: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2815: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));

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

2808: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2814: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2815: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2816: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;

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

2809: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2814: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2815: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2816: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
2817:

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

2810: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2814: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2815: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2816: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
2817:
2818:

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

2811: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
2812: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
2813: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
2814: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
2815: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
2816: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
2817:
2818:
2819: l_remainder := mod (v1, 11);