APPS.PQP_RATES_HISTORY_CALC dependencies on FND_NUMBER

Line 819: l_contract_factor := fnd_number.canonical_to_number(

815: THEN
816:
817: -- Get the factor value from the contracts table
818: BEGIN
819: l_contract_factor := fnd_number.canonical_to_number(
820: hruserdt.get_table_value
821: (p_bus_group_id => p_business_group_id
822: ,p_table_name => c_contract_table_name
823: ,p_col_name => l_column_name

Line 1099: fnd_number.canonical_to_number( hruserdt.get_table_value

1095: -- BUG 3454641
1096: BEGIN
1097:
1098: l_annual_term_time_hours :=
1099: fnd_number.canonical_to_number( hruserdt.get_table_value
1100: (p_bus_group_id => l_business_group_id
1101: ,p_table_name => c_contract_table_name
1102: ,p_col_name => 'ANNUAL TERM TIME HOURS'
1103: ,p_row_value => l_contract_type

Line 1129: fnd_number.canonical_to_number( hruserdt.get_table_value

1125: -- BUG 3454641
1126:
1127: BEGIN
1128: l_annual_hours :=
1129: fnd_number.canonical_to_number( hruserdt.get_table_value
1130: (p_bus_group_id => l_business_group_id
1131: ,p_table_name => c_contract_table_name
1132: ,p_col_name => 'ANNUAL HOURS'
1133: ,p_row_value => l_contract_type

Line 1357: l_factor_or_percentage := fnd_number.canonical_to_number(l_entry_value_txt);

1353: pay_ele_shd.convert_lookups(l_input_value_id, l_entry_value_txt);
1354:
1355: END IF; -- IF ( l_input_value_lookup_type IS NOT NULL
1356:
1357: l_factor_or_percentage := fnd_number.canonical_to_number(l_entry_value_txt);
1358:
1359: IF g_debug THEN
1360: debug('l_factor_or_percentage:'||l_factor_or_percentage);
1361: END IF;

Line 1711: SELECT fnd_number.canonical_to_number(pgr.VALUE) --Modified for the bug 11795180

1707: -- Cursor to get rate from grade scale
1708: --
1709: CURSOR csr_grade_rate
1710: IS
1711: SELECT fnd_number.canonical_to_number(pgr.VALUE) --Modified for the bug 11795180
1712: FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr
1713: WHERE paf.assignment_id = p_assignment_id
1714: AND paf.grade_id = pgr.grade_or_spinal_point_id
1715: AND pgr.rate_type = 'G'

Line 1730: SELECT fnd_number.canonical_to_number(pgr.VALUE) --Modified for the bug 11795180

1726: --Cursor to get rate from grade scale in case of Qualifier with a wildcard.
1727: --
1728: CURSOR csr_grade_rate_like
1729: IS
1730: SELECT fnd_number.canonical_to_number(pgr.VALUE) --Modified for the bug 11795180
1731: FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr
1732: WHERE paf.assignment_id = p_assignment_id
1733: AND paf.grade_id = pgr.grade_or_spinal_point_id
1734: AND pgr.rate_type = 'G'

Line 1971: l_fetched_rate := fnd_number.canonical_to_number(l_entry_value_txt);

1967: END IF; -- IF ( l_input_value_lookup_type IS NOT NULL
1968:
1969: IF l_entry_value_txt IS NOT NULL
1970: THEN
1971: l_fetched_rate := fnd_number.canonical_to_number(l_entry_value_txt);
1972: ELSE
1973: l_fetched_rate := 0;
1974: END IF;
1975:

Line 2623: ,p_calculation_value => fnd_number.canonical_to_number(l_calc_value)

2619: ,p_pay_source_value => l_pay_source_value
2620: ,p_qualifier => l_qualifier
2621: ,p_from_time_dim => l_from_time_dimension
2622: ,p_calculation_type => l_calc_type
2623: ,p_calculation_value => fnd_number.canonical_to_number(l_calc_value)
2624: ,p_input_value => l_input_value
2625: ,p_term_time_yes_no => l_term_time_yes_no
2626: ,p_sum_multiple_entries_yn => l_sum_multiple_entries_yn
2627: ,p_lookup_input_values_yn => l_lookup_input_values_yn

Line 3162: ,p_calculation_value => fnd_number.canonical_to_number(l_calc_value)

3158: ,p_pay_source_value => l_pay_source_value
3159: ,p_qualifier => l_qualifier
3160: ,p_from_time_dim => l_from_time_dimension
3161: ,p_calculation_type => l_calc_type
3162: ,p_calculation_value => fnd_number.canonical_to_number(l_calc_value)
3163: ,p_input_value => l_input_value
3164: ,p_term_time_yes_no => l_term_time_yes_no
3165: ,p_sum_multiple_entries_yn => l_sum_multiple_entries_yn
3166: ,p_lookup_input_values_yn => l_lookup_input_values_yn