DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on FND_NUMBER

Line 794: l_notional_pay := fnd_number.canonical_to_number(p_output);

790: ,p_rate => p_output
791: ,p_custom_function => g_user_rate_function
792: );
793:
794: l_notional_pay := fnd_number.canonical_to_number(p_output);
795:
796: IF nvl(g_sal_ele_fte_attr,'NONE') = 'ALL' THEN
797: l_fte_value := PQP_GB_PSI_FUNCTIONS.get_fte_value
798: (

Line 1111: p_old_value := get_grade_code(fnd_number.canonical_to_number(l_old_value));

1107: -- when the old_value/new_value is null
1108: -- the non-numeric exception is caught here.
1109: IF l_old_value IS NOT NULL THEN
1110: BEGIN
1111: p_old_value := get_grade_code(fnd_number.canonical_to_number(l_old_value));
1112: EXCEPTION
1113: WHEN others THEN
1114: debug('l_old_value is not numeric');
1115: END;

Line 1121: p_new_value := get_grade_code(fnd_number.canonical_to_number(l_new_value));

1117: END IF;
1118:
1119: IF l_new_value IS NOT NULL THEN
1120: BEGIN
1121: p_new_value := get_grade_code(fnd_number.canonical_to_number(l_new_value));
1122: EXCEPTION
1123: WHEN others THEN
1124: debug('l_old_value is not numeric');
1125: END;

Line 1302: l_actual_pay := fnd_number.canonical_to_number(p_output);

1298: ,p_effective_date => g_salary_start_date
1299: ,p_output => p_output
1300: );
1301:
1302: l_actual_pay := fnd_number.canonical_to_number(p_output);
1303:
1304: -- the following if clause is added in 115.23
1305: IF l_actual_pay < 0 THEN
1306: p_output := ltrim(rtrim(to_char(l_actual_pay,'099999999D99')));