APPS.PERFRPHR dependencies on FND_NUMBER

Line 925: l_units_in_days := fnd_number.canonical_to_number(get_alternate_lookup

921: --
922: /* Work out how many days make up a week/month/year then multiply that by the probation period value */
923: l_trace := 'Calculating probation period';
924: -- modified for numerical value error (bug#4106045)
925: l_units_in_days := fnd_number.canonical_to_number(get_alternate_lookup
926: (p_table_name => 'QUALIFYING_UNITS'
927: ,p_col_name => 'DUE_UNITS_IN_DAYS'
928: ,p_row_value => r_app.app_prob_unit));
929: --

Line 934: l_probation_period := fnd_number.number_to_canonical(r_app.app_prob_period*l_units_in_days);

930: IF l_units_in_days IS NULL THEN
931: l_probation_period := NULL;
932: ELSE
933: -- modified for numerical value error (bug#4106045)
934: l_probation_period := fnd_number.number_to_canonical(r_app.app_prob_period*l_units_in_days);
935: END IF;
936: --
937: /* Work out how many weeks make up a day/week/month/year then multiply that by the normal working hours value */
938: l_trace := 'Calculating normal working hours';

Line 940: l_units_in_weeks := fnd_number.canonical_to_number(get_alternate_lookup

936: --
937: /* Work out how many weeks make up a day/week/month/year then multiply that by the normal working hours value */
938: l_trace := 'Calculating normal working hours';
939: -- modified for numerical value error (bug#4106045)
940: l_units_in_weeks := fnd_number.canonical_to_number(get_alternate_lookup
941: (p_table_name => 'FREQUENCY'
942: ,p_col_name => 'DUE_FREQUENCY_IN_WEEKS'
943: ,p_row_value => r_app.frequency));
944: --

Line 949: l_working_hours := fnd_number.number_to_canonical(round(r_app.app_hours*l_units_in_weeks));

945: IF l_units_in_weeks IS NULL THEN
946: l_working_hours := NULL;
947: ELSE
948: -- modified for numerical value error (bug#4106045)
949: l_working_hours := fnd_number.number_to_canonical(round(r_app.app_hours*l_units_in_weeks));
950: END IF;
951: --
952: /*Get the NAF meaning*/
953: l_naf_meaning := hr_general.decode_lookup(p_lookup_type => 'FR_NAF_CODE',

Line 967: l_monthly_hours := ROUND(fnd_number.canonical_to_number(r_app.monthly_hours));

963: r_app.app_titulair := REPLACE(r_app.app_titulair,'Y','O');
964: --
965: l_trace := 'Monthly Hours';
966: /* Round the monthly hours worked to nearest integer*/
967: l_monthly_hours := ROUND(fnd_number.canonical_to_number(r_app.monthly_hours));
968: --
969: l_trace := 'Building Output String';
970: /* Build up the text string for output */
971: l_text := RPAD(l_identifier,14) -- Identification