DBA Data[Home] [Help]

APPS.PYNEGNET01 dependencies on FND_NUMBER

Line 2211: if fnd_number.canonical_to_number(l_result_value) > 0 then

2207: fetch csr_run_results into l_run_result_id, l_input_value_id, l_result_value;
2208:
2209: WHILE csr_run_results%found LOOP
2210:
2211: if fnd_number.canonical_to_number(l_result_value) > 0 then
2212: update pay_run_result_values
2213: set result_value = fnd_number.number_to_canonical(fnd_number.canonical_to_number(result_value) * (-1))
2214: where run_result_id = l_run_result_id and
2215: input_value_id = l_input_value_id;

Line 2213: set result_value = fnd_number.number_to_canonical(fnd_number.canonical_to_number(result_value) * (-1))

2209: WHILE csr_run_results%found LOOP
2210:
2211: if fnd_number.canonical_to_number(l_result_value) > 0 then
2212: update pay_run_result_values
2213: set result_value = fnd_number.number_to_canonical(fnd_number.canonical_to_number(result_value) * (-1))
2214: where run_result_id = l_run_result_id and
2215: input_value_id = l_input_value_id;
2216: end if;
2217: fetch csr_run_results into l_run_result_id, l_input_value_id, l_result_value;