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 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 1520: p_action_information12 => fnd_number.number_to_canonical(

1516: p_action_information9 => j.full_name,
1517: p_action_information10 => j.employee_number,
1518: p_action_information11 => fnd_date.date_to_canonical(
1519: collemptable (1).start_date),
1520: p_action_information12 => fnd_number.number_to_canonical(
1521: collemptable (1).working_hours),
1522: p_action_information17 => collemptable (1).job_id,
1523: p_action_information21 => collemptable (1).status_type,
1524: p_assignment_id => j.assignment_id

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

1811: cnt
1812: ).start_date) -- Employment Start Date
1813: --,p_action_information16 => p_time_period_id
1814: ,
1815: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
1816: cnt
1817: ).working_hours) -- Weekly Working Hours
1818: ,
1819: p_action_information13 => fnd_date.date_to_canonical(collemptable (

Line 2168: l_hour_value_primary := fnd_number.canonical_to_number (

2164: l_retrospective_date <> l_detailed_output (cnt).effective_date then
2165: l_hour_year_change_flag := 'Y' ;
2166:
2167: begin
2168: l_hour_value_primary := fnd_number.canonical_to_number (
2169: nvl (
2170: l_detailed_output (
2171: cnt
2172: ).new_value,

Line 2230: l_new_hour := fnd_number.canonical_to_number (

2226: l_detailed_output.first .. l_detailed_output.last
2227: loop
2228: begin
2229: l_new_hour := 0;
2230: l_new_hour := fnd_number.canonical_to_number (
2231: nvl (
2232: l_detailed_output (
2233: cnt1
2234: ).new_value,

Line 2372: fnd_number.canonical_to_number (

2368: end if;
2369: elsif l_detailed_output (cnt).column_name = 'JOB_ID' and
2370: l_retrospective_date <> l_detailed_output (cnt).effective_date then
2371: l_job_id :=
2372: fnd_number.canonical_to_number (
2373: nvl (
2374: l_detailed_output (cnt).new_value,
2375: fnd_number.canonical_to_number (
2376: substr (

Line 2375: fnd_number.canonical_to_number (

2371: l_job_id :=
2372: fnd_number.canonical_to_number (
2373: nvl (
2374: l_detailed_output (cnt).new_value,
2375: fnd_number.canonical_to_number (
2376: substr (
2377: l_detailed_output (cnt).change_values,
2378: instr (
2379: l_detailed_output (cnt).change_values,

Line 2413: fnd_number.canonical_to_number(substr(l_detailed_output(cnt).change_values,

2409: l_retrospective_date <> l_detailed_output (cnt).effective_date*/
2410: then
2411: l_local_unit_value :=
2412: nvl(l_detailed_output(cnt).new_value,
2413: fnd_number.canonical_to_number(substr(l_detailed_output(cnt).change_values,
2414: instr(l_detailed_output(cnt
2415: ).change_values,
2416: '->'
2417: )

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

2436: if l_old_scl = ' '
2437: then
2438: l_old_scl := '0';
2439: l_local_unit_value := l_new_scl;
2440: open csr_get_pos_scl(fnd_number.canonical_to_number(l_new_scl));
2441: fetch csr_get_pos_scl into l_job_value;
2442:
2443: if l_emp_start_date <> l_detailed_output(cnt).effective_date
2444: then

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

2450: collemptable(1).job_id := l_job_value;
2451: end if;
2452:
2453: close csr_get_pos_scl;
2454: open csr_get_org_no(fnd_number.canonical_to_number(l_new_scl));
2455: fetch csr_get_org_no into l_lu_org_no;
2456:
2457: if l_emp_start_date <> l_detailed_output(cnt).effective_date
2458: or l_corr_change_flag = 'C'

Line 2501: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_new_scl

2497: end if;
2498:
2499: /*5695791*/
2500: /* Code for Latest Start Date */
2501: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_new_scl
2502: )
2503: );
2504: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2505: close csr_get_latest_st_date_scl;

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

2513: collemptable(3).value_flag := 'Y';
2514: end if;
2515: else
2516: /* Code for Local Unit */
2517: open csr_get_lu_scl(fnd_number.canonical_to_number(l_new_scl));
2518: fetch csr_get_lu_scl into l_new_lu;
2519: close csr_get_lu_scl;
2520: open csr_get_lu_scl(fnd_number.canonical_to_number(l_old_scl));
2521: fetch csr_get_lu_scl into l_old_lu;

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

2516: /* Code for Local Unit */
2517: open csr_get_lu_scl(fnd_number.canonical_to_number(l_new_scl));
2518: fetch csr_get_lu_scl into l_new_lu;
2519: close csr_get_lu_scl;
2520: open csr_get_lu_scl(fnd_number.canonical_to_number(l_old_scl));
2521: fetch csr_get_lu_scl into l_old_lu;
2522: close csr_get_lu_scl;
2523:
2524: if l_old_lu <> l_new_lu

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

2528: l_lu_change_effective_date :=
2529: l_detailed_output(cnt).effective_date;
2530: end if;
2531:
2532: open csr_get_org_no(fnd_number.canonical_to_number(l_new_scl));
2533: fetch csr_get_org_no into l_lu_org_no;
2534: close csr_get_org_no;
2535:
2536: if l_emp_start_date <> l_detailed_output(cnt).effective_date

Line 2542: open csr_get_org_no(fnd_number.canonical_to_number(l_old_scl

2538: then
2539: if l_corr_change_flag = 'M'
2540: then
2541: l_lu_change_flag := 'Y'; /* 5519990 */
2542: open csr_get_org_no(fnd_number.canonical_to_number(l_old_scl
2543: )
2544: );
2545: fetch csr_get_org_no into collemptable(2).old_lu_value;
2546: close csr_get_org_no;

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

2562:
2563: /* End Code for Local Unit */
2564:
2565: /* Code for Position Code */
2566: open csr_get_pos_scl(fnd_number.canonical_to_number(l_new_scl));
2567: fetch csr_get_pos_scl into l_new_job_value;
2568: close csr_get_pos_scl;
2569: open csr_get_pos_scl(fnd_number.canonical_to_number(l_old_scl));
2570: fetch csr_get_pos_scl into l_old_job_value;

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

2565: /* Code for Position Code */
2566: open csr_get_pos_scl(fnd_number.canonical_to_number(l_new_scl));
2567: fetch csr_get_pos_scl into l_new_job_value;
2568: close csr_get_pos_scl;
2569: open csr_get_pos_scl(fnd_number.canonical_to_number(l_old_scl));
2570: fetch csr_get_pos_scl into l_old_job_value;
2571: close csr_get_pos_scl;
2572:
2573: if l_new_job_value <> l_old_job_value

Line 2617: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_new_scl

2613: end if;
2614: end if;
2615:
2616: /* Code for Latest Start Date */
2617: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_new_scl
2618: )
2619: );
2620: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2621: close csr_get_latest_st_date_scl;

Line 2622: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_old_scl

2618: )
2619: );
2620: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2621: close csr_get_latest_st_date_scl;
2622: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_old_scl
2623: )
2624: );
2625: fetch csr_get_latest_st_date_scl into l_old_latest_start_date;
2626: close csr_get_latest_st_date_scl;

Line 2639: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_new_scl

2635:
2636: if l_old_scl <> ' '
2637: then
2638: /* Code for Latest Start Date */
2639: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_new_scl
2640: )
2641: );
2642: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2643: close csr_get_latest_st_date_scl;

Line 2644: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_old_scl

2640: )
2641: );
2642: fetch csr_get_latest_st_date_scl into l_new_latest_start_date;
2643: close csr_get_latest_st_date_scl;
2644: open csr_get_latest_st_date_scl(fnd_number.canonical_to_number(l_old_scl
2645: )
2646: );
2647: fetch csr_get_latest_st_date_scl into l_old_latest_start_date;
2648: close csr_get_latest_st_date_scl;

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

2662: and
2663: l_retrospective_date <> l_detailed_output (cnt).effective_date then
2664:
2665: open csr_get_assignment_status (
2666: fnd_number.canonical_to_number (l_detailed_output (cnt).new_value)
2667: );
2668: fetch csr_get_assignment_status into l_user_status;
2669: close csr_get_assignment_status;
2670:

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

2880: cnt
2881: ).start_date) -- Employment Start Date
2882: --,p_action_information16 => p_time_period_id
2883: ,
2884: p_action_information12 =>fnd_number.number_to_canonical(collemptable (
2885: cnt
2886: ).working_hours) -- Weekly Working Hours
2887: ,
2888: p_action_information13 => fnd_date.date_to_canonical(collemptable (

Line 3191: fnd_number.canonical_to_number(action_information12) action_information12,

3187: select action_information2, action_information3, action_information4,
3188: action_information5, action_information6, action_information7,
3189: action_information8, action_information9, action_information10,
3190: fnd_date.canonical_to_date(action_information11) action_information11,
3191: fnd_number.canonical_to_number(action_information12) action_information12,
3192: fnd_date.canonical_to_date(action_information13) action_information13,
3193: fnd_date.canonical_to_date(action_information14) action_information14,
3194: action_information15,
3195: fnd_date.canonical_to_date(action_information16) action_information16,

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

3623: l_check_value := hr_no_utility.chk_valid_date (l_return_value);
3624:
3625: if l_check_value <> 0 then
3626: /* Valid Birthdate */
3627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));

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

3624:
3625: if l_check_value <> 0 then
3626: /* Valid Birthdate */
3627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));

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

3625: if l_check_value <> 0 then
3626: /* Valid Birthdate */
3627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));

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

3626: /* Valid Birthdate */
3627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));

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

3627: d1 := fnd_number.canonical_to_number (substr (l_return_value, 1, 1));
3628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));

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

3628: d2 := fnd_number.canonical_to_number (substr (l_return_value, 2, 1));
3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));

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

3629: m1 := fnd_number.canonical_to_number (substr (l_return_value, 3, 1));
3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));

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

3630: m2 := fnd_number.canonical_to_number (substr (l_return_value, 4, 1));
3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;

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

3631: y1 := fnd_number.canonical_to_number (substr (l_return_value, 5, 1));
3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
3639:

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

3632: y2 := fnd_number.canonical_to_number (substr (l_return_value, 6, 1));
3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
3639:
3640:

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

3633: i1 := fnd_number.canonical_to_number (substr (l_return_value, 8, 1));
3634: i2 := fnd_number.canonical_to_number (substr (l_return_value, 9, 1));
3635: i3 := fnd_number.canonical_to_number (substr (l_return_value, 10, 1));
3636: c1 := fnd_number.canonical_to_number (substr (l_return_value, 11, 1));
3637: c2 := fnd_number.canonical_to_number (substr (l_return_value, 12, 1));
3638: v1 := 3 * d1 + 7 * d2 + 6 * m1 + m2 + 8 * y1 + 9 * y2 + 4 * i1 + 5 * i2 + 2 * i3;
3639:
3640:
3641: l_remainder := mod (v1, 11);