APPS.PAY_JP_RESULT_PKG dependencies on FND_NUMBER

Line 46: 'N',fnd_number.number_to_canonical(

42: decode(substrb(piv.uom,1,1),'M','N','N','N','I','N','H','N','D','D','T') DATA_TYPE,
43: decode(
44: /* N(Number), T(Text), D(Date) */
45: decode(substrb(piv.uom,1,1),'M','N','N','N','I','N','H','N','D','D','T'),
46: 'N',fnd_number.number_to_canonical(
47: sum(
48: decode(
49: decode(substrb(piv.uom,1,1),'M','N','N','N','I','N','H','N','D','D','T'),
50: /* BUG3038738: Modified not to return result value if uom is number type. **

Line 53: ** fnd_number.canonical_to_number() function. Because fnd_number uses a **

49: decode(substrb(piv.uom,1,1),'M','N','N','N','I','N','H','N','D','D','T'),
50: /* BUG3038738: Modified not to return result value if uom is number type. **
51: ** When UOM of that result_value is number type, and it exceeds 20 digits **
52: ** after the decimal point, ORA-06502 error occurs in **
53: ** fnd_number.canonical_to_number() function. Because fnd_number uses a **
54: ** canonical_mask with only 20 decimal places against result_value with up **
55: ** to 38 decimal places. Currently, result_value for number type from this **
56: ** cursor has not been used anywhere. **
57: 'N',fnd_number.canonical_to_number(prrv.result_value),

Line 57: 'N',fnd_number.canonical_to_number(prrv.result_value),

53: ** fnd_number.canonical_to_number() function. Because fnd_number uses a **
54: ** canonical_mask with only 20 decimal places against result_value with up **
55: ** to 38 decimal places. Currently, result_value for number type from this **
56: ** cursor has not been used anywhere. **
57: 'N',fnd_number.canonical_to_number(prrv.result_value),
58: ********************************************************************************* */
59: 'N',
60: decode(substrb(piv.uom,1,1),'N',0,
61: fnd_number.canonical_to_number(prrv.result_value)),

Line 61: fnd_number.canonical_to_number(prrv.result_value)),

57: 'N',fnd_number.canonical_to_number(prrv.result_value),
58: ********************************************************************************* */
59: 'N',
60: decode(substrb(piv.uom,1,1),'N',0,
61: fnd_number.canonical_to_number(prrv.result_value)),
62: NULL
63: )
64: )
65: ),

Line 117: := fnd_number.number_to_canonical(

113: p_result_values_by_iv(l_input_value_id).result_value := l_result_value;
114: else
115: if l_data_type = 'N' then
116: p_result_values_by_iv(l_input_value_id).result_value
117: := fnd_number.number_to_canonical(
118: fnd_number.canonical_to_number(p_result_values_by_iv(l_input_value_id).result_value)
119: + fnd_number.canonical_to_number(l_result_value));
120: else
121: p_result_values_by_iv(l_input_value_id).result_value

Line 118: fnd_number.canonical_to_number(p_result_values_by_iv(l_input_value_id).result_value)

114: else
115: if l_data_type = 'N' then
116: p_result_values_by_iv(l_input_value_id).result_value
117: := fnd_number.number_to_canonical(
118: fnd_number.canonical_to_number(p_result_values_by_iv(l_input_value_id).result_value)
119: + fnd_number.canonical_to_number(l_result_value));
120: else
121: p_result_values_by_iv(l_input_value_id).result_value
122: := least(p_result_values_by_iv(l_input_value_id).result_value,l_result_value);

Line 119: + fnd_number.canonical_to_number(l_result_value));

115: if l_data_type = 'N' then
116: p_result_values_by_iv(l_input_value_id).result_value
117: := fnd_number.number_to_canonical(
118: fnd_number.canonical_to_number(p_result_values_by_iv(l_input_value_id).result_value)
119: + fnd_number.canonical_to_number(l_result_value));
120: else
121: p_result_values_by_iv(l_input_value_id).result_value
122: := least(p_result_values_by_iv(l_input_value_id).result_value,l_result_value);
123: end if;

Line 291: + fnd_number.canonical_to_number(l_result_value) * l_feed_scales(i);

287: --
288: l_result_value := p_result_values_by_iv(l_feed_ivs(i)).result_value;
289: if l_result_value is not NULL and l_result_value <> 0 then
290: p_balance_values_by_bal(l_feed_bals(i)) := p_balance_values_by_bal(l_feed_bals(i))
291: + fnd_number.canonical_to_number(l_result_value) * l_feed_scales(i);
292: end if;
293: end loop;
294: end if;
295: end if;