DBA Data[Home] [Help]

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 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