DBA Data[Home] [Help]

APPS.PQP_UTILITIES dependencies on FND_NUMBER

Line 584: debug(fnd_number.number_to_canonical(p_trace_number));

580: --
581: PROCEDURE debug(p_trace_number IN NUMBER)
582: IS
583: BEGIN
584: debug(fnd_number.number_to_canonical(p_trace_number));
585: END debug;
586:
587: --
588: --

Line 646: || fnd_number.number_to_canonical(p_proc_step)

642:
643: l_message :=
644: p_proc_name
645: || '{'
646: || fnd_number.number_to_canonical(p_proc_step)
647: || '}: '
648: || SUBSTRB(SQLERRM, 1, 2000);
649:
650: IF g_debug

Line 781: l_val := fnd_number.number_to_canonical(l_num);

777: IF g_debug THEN
778: debug(l_proc_name, 60);
779: END IF;
780: FETCH c_column INTO l_num;
781: l_val := fnd_number.number_to_canonical(l_num);
782: END IF;
783:
784: CLOSE c_column;
785: IF g_debug THEN

Line 2364: fnd_number.canonical_to_number(p_row_name)

2360: IF l_range_match.range_or_match = 'R'
2361: AND g_udt_rec(i).table_name = p_table_name
2362: AND g_udt_rec(i).column_name = p_column_name
2363: AND (
2364: fnd_number.canonical_to_number(p_row_name)
2365: BETWEEN fnd_number.canonical_to_number(g_udt_rec(i).row_name)
2366: AND fnd_number.canonical_to_number(g_udt_rec(i).row_high_range)
2367: )
2368: AND (

Line 2365: BETWEEN fnd_number.canonical_to_number(g_udt_rec(i).row_name)

2361: AND g_udt_rec(i).table_name = p_table_name
2362: AND g_udt_rec(i).column_name = p_column_name
2363: AND (
2364: fnd_number.canonical_to_number(p_row_name)
2365: BETWEEN fnd_number.canonical_to_number(g_udt_rec(i).row_name)
2366: AND fnd_number.canonical_to_number(g_udt_rec(i).row_high_range)
2367: )
2368: AND (
2369: p_effective_date BETWEEN g_udt_rec(i).start_date

Line 2366: AND fnd_number.canonical_to_number(g_udt_rec(i).row_high_range)

2362: AND g_udt_rec(i).column_name = p_column_name
2363: AND (
2364: fnd_number.canonical_to_number(p_row_name)
2365: BETWEEN fnd_number.canonical_to_number(g_udt_rec(i).row_name)
2366: AND fnd_number.canonical_to_number(g_udt_rec(i).row_high_range)
2367: )
2368: AND (
2369: p_effective_date BETWEEN g_udt_rec(i).start_date
2370: AND g_udt_rec(i).end_date

Line 2881: debug('p_error_code:' ||fnd_number.number_to_canonical(p_error_code));

2877: BEGIN
2878: g_debug := hr_utility.debug_enabled;
2879: IF g_debug THEN
2880: debug_enter(l_proc_name);
2881: debug('p_error_code:' ||fnd_number.number_to_canonical(p_error_code));
2882: debug('p_error_message:'||p_error_message);
2883: END IF;
2884:
2885: IF p_error_code < 0

Line 3580: l_element_entries_tab.element_entry_id(l_next) := fnd_number.canonical_to_number(l_purge_ee_ids(i));

3576: LOOP
3577: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));
3578: -- bug fix 5368066. nvl is added for this bug fix.
3579: l_next := nvl(l_element_entries_tab.element_entry_id.LAST,0) + 1;
3580: l_element_entries_tab.element_entry_id(l_next) := fnd_number.canonical_to_number(l_purge_ee_ids(i));
3581: l_element_entries_tab.datetracked_event_id(l_next) := l_purge_dte_id;
3582: END LOOP;
3583: END IF;
3584: