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

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

324: cursor get_global_value (
325: p_global_name varchar2,
326: p_effective_date date
327: ) is
328: select nvl(fnd_number.canonical_to_number (global_value),0)
329: from ff_globals_f
330: where legislation_code = 'NO' and global_name = p_global_name
331: and p_effective_date between effective_start_date and effective_end_date ;
332:

Line 666: fnd_number.canonical_to_number (screen_entry_value) entry_value

662: c_eff_start_date date,
663: c_eff_end_date date
664: ) is
665: select effective_start_date,
666: fnd_number.canonical_to_number (screen_entry_value) entry_value
667: from pay_element_entry_values_f peev
668: where element_entry_id = c_element_entry_id
669: and effective_start_date between c_eff_start_date and c_eff_end_date
670: and screen_entry_value is not null

Line 686: select fnd_number.canonical_to_number (screen_entry_value) entry_value

682: cursor csr_get_curr_element_value (
683: c_element_entry_id number,
684: c_effective_date date
685: ) is
686: select fnd_number.canonical_to_number (screen_entry_value) entry_value
687: from pay_element_entry_values_f
688: where element_entry_id = c_element_entry_id
689: and c_effective_date between effective_start_date
690: and effective_end_date

Line 1354: p_action_information12 => fnd_number.number_to_canonical(

1350: p_action_information9 => j.full_name,
1351: p_action_information10 => j.employee_number,
1352: p_action_information11 => fnd_date.date_to_canonical(
1353: collemptable (1).start_date),
1354: p_action_information12 => fnd_number.number_to_canonical(
1355: collemptable (1).working_hours),
1356: p_action_information17 => collemptable (1).job_id,
1357: p_action_information21 => collemptable (1).status_type,
1358: p_assignment_id => j.assignment_id

Line 1649: p_action_information12 =>fnd_number.number_to_canonical(collemptable (

1645: cnt
1646: ).start_date) -- Employment Start Date
1647: --,p_action_information16 => p_time_period_id
1648: ,
1649: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
1650: cnt
1651: ).working_hours) -- Weekly Working Hours
1652: ,
1653: p_action_information13 => fnd_date.date_to_canonical(collemptable (

Line 2002: l_hour_value_primary := fnd_number.canonical_to_number (

1998: l_retrospective_date <> l_detailed_output (cnt).effective_date then
1999: l_hour_year_change_flag := 'Y' ;
2000:
2001: begin
2002: l_hour_value_primary := fnd_number.canonical_to_number (
2003: nvl (
2004: l_detailed_output (
2005: cnt
2006: ).new_value,

Line 2064: l_new_hour := fnd_number.canonical_to_number (

2060: l_detailed_output.first .. l_detailed_output.last
2061: loop
2062: begin
2063: l_new_hour := 0;
2064: l_new_hour := fnd_number.canonical_to_number (
2065: nvl (
2066: l_detailed_output (
2067: cnt1
2068: ).new_value,

Line 2206: fnd_number.canonical_to_number (

2202: end if;
2203: elsif l_detailed_output (cnt).column_name = 'JOB_ID' and
2204: l_retrospective_date <> l_detailed_output (cnt).effective_date then
2205: l_job_id :=
2206: fnd_number.canonical_to_number (
2207: nvl (
2208: l_detailed_output (cnt).new_value,
2209: fnd_number.canonical_to_number (
2210: substr (

Line 2209: fnd_number.canonical_to_number (

2205: l_job_id :=
2206: fnd_number.canonical_to_number (
2207: nvl (
2208: l_detailed_output (cnt).new_value,
2209: fnd_number.canonical_to_number (
2210: substr (
2211: l_detailed_output (cnt).change_values,
2212: instr (
2213: l_detailed_output (cnt).change_values,

Line 2248: fnd_number.canonical_to_number (

2244:
2245:
2246: l_local_unit_value := nvl (
2247: l_detailed_output (cnt).new_value,
2248: fnd_number.canonical_to_number (
2249: substr (
2250: l_detailed_output (
2251: cnt
2252: ).change_values,

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

2284:
2285: l_old_scl := '0';
2286: l_local_unit_value := l_new_scl;
2287:
2288: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
2289: fetch csr_get_pos_scl into l_job_value;
2290: if l_emp_start_date <>
2291: l_detailed_output (cnt).effective_date then
2292: collemptable (2).job_change_date :=

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

2300: end if;
2301: close csr_get_pos_scl;
2302:
2303:
2304: open csr_get_org_no (fnd_number.canonical_to_number (l_new_scl));
2305: fetch csr_get_org_no into l_lu_org_no;
2306:
2307: if l_emp_start_date <> l_detailed_output (cnt).effective_date
2308: or l_corr_change_flag = 'C' then

Line 2346: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_new_scl));

2342: end if;
2343:
2344: /*5695791*/
2345: /* Code for Latest Start Date */
2346: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_new_scl));
2347: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2348: close csr_get_latest_st_date_scl;
2349:
2350:

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

2357: else
2358:
2359:
2360: /* Code for Local Unit */
2361: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));
2362: fetch csr_get_lu_scl into l_new_lu;
2363: close csr_get_lu_scl;
2364:
2365: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));

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

2361: open csr_get_lu_scl (fnd_number.canonical_to_number (l_new_scl));
2362: fetch csr_get_lu_scl into l_new_lu;
2363: close csr_get_lu_scl;
2364:
2365: open csr_get_lu_scl (fnd_number.canonical_to_number (l_old_scl));
2366: fetch csr_get_lu_scl into l_old_lu;
2367: close csr_get_lu_scl;
2368:
2369: if l_old_lu <> l_new_lu then

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

2372: l_lu_change_effective_date :=
2373: l_detailed_output (cnt).effective_date;
2374: end if;
2375:
2376: open csr_get_org_no (fnd_number.canonical_to_number (l_new_scl));
2377: fetch csr_get_org_no into l_lu_org_no;
2378: close csr_get_org_no;
2379:
2380: if l_emp_start_date <> l_detailed_output (cnt).effective_date

Line 2384: open csr_get_org_no (fnd_number.canonical_to_number (l_old_scl));

2380: if l_emp_start_date <> l_detailed_output (cnt).effective_date
2381: or l_corr_change_flag = 'C' then
2382: if l_corr_change_flag = 'M' then
2383: l_lu_change_flag := 'Y' ; /* 5519990 */
2384: open csr_get_org_no (fnd_number.canonical_to_number (l_old_scl));
2385: fetch csr_get_org_no into collemptable (2).old_lu_value;
2386: close csr_get_org_no;
2387: collemptable (2).lu_value := l_lu_org_no;
2388: collemptable (2).lu_change_date :=

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

2404:
2405: /* Code for Position Code */
2406:
2407:
2408: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
2409: fetch csr_get_pos_scl into l_new_job_value;
2410: close csr_get_pos_scl;
2411:
2412: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));

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

2408: open csr_get_pos_scl (fnd_number.canonical_to_number (l_new_scl));
2409: fetch csr_get_pos_scl into l_new_job_value;
2410: close csr_get_pos_scl;
2411:
2412: open csr_get_pos_scl (fnd_number.canonical_to_number (l_old_scl));
2413: fetch csr_get_pos_scl into l_old_job_value;
2414: close csr_get_pos_scl;
2415:
2416: if l_new_job_value <> l_old_job_value then

Line 2455: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_new_scl));

2451: end if;
2452: end if;
2453:
2454: /* Code for Latest Start Date */
2455: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_new_scl));
2456: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2457: close csr_get_latest_st_date_scl;
2458:
2459: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_old_scl));

Line 2459: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_old_scl));

2455: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_new_scl));
2456: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2457: close csr_get_latest_st_date_scl;
2458:
2459: open csr_get_latest_st_date_scl (fnd_number.canonical_to_number (l_old_scl));
2460: fetch csr_get_latest_st_date_scl into l_old_latest_start_date;
2461: close csr_get_latest_st_date_scl;
2462:
2463: if l_new_latest_start_date <> l_old_latest_start_date then

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

2475: and
2476: l_retrospective_date <> l_detailed_output (cnt).effective_date then
2477:
2478: open csr_get_assignment_status (
2479: fnd_number.canonical_to_number (l_detailed_output (cnt).new_value)
2480: );
2481: fetch csr_get_assignment_status into l_user_status;
2482: close csr_get_assignment_status;
2483:

Line 2697: p_action_information12 =>fnd_number.number_to_canonical(collemptable (

2693: cnt
2694: ).start_date) -- Employment Start Date
2695: --,p_action_information16 => p_time_period_id
2696: ,
2697: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
2698: cnt
2699: ).working_hours) -- Weekly Working Hours
2700: ,
2701: p_action_information13 => fnd_date.date_to_canonical(collemptable (

Line 3004: fnd_number.canonical_to_number(action_information12) action_information12,

3000: select action_information2, action_information3, action_information4,
3001: action_information5, action_information6, action_information7,
3002: action_information8, action_information9, action_information10,
3003: fnd_date.canonical_to_date(action_information11) action_information11,
3004: fnd_number.canonical_to_number(action_information12) action_information12,
3005: fnd_date.canonical_to_date(action_information13) action_information13,
3006: fnd_date.canonical_to_date(action_information14) action_information14,
3007: action_information15,
3008: fnd_date.canonical_to_date(action_information16) action_information16,

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

3430: l_check_value := hr_no_utility.chk_valid_date (l_return_value);
3431:
3432: if l_check_value <> 0 then
3433: /* Valid Birthdate */
3434: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3435: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));

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

3431:
3432: if l_check_value <> 0 then
3433: /* Valid Birthdate */
3434: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3435: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));

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

3432: if l_check_value <> 0 then
3433: /* Valid Birthdate */
3434: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3435: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));

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

3433: /* Valid Birthdate */
3434: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3435: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));

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

3434: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3435: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));

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

3435: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3443: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));

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

3436: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3443: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3444: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));

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

3437: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3443: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3444: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3445: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;

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

3438: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3443: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3444: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3445: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
3446:

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

3439: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3443: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3444: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3445: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
3446:
3447:

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

3440: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3441: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3442: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3443: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3444: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3445: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
3446:
3447:
3448: l_remainder := mod (v1, 11);