[Home] [Help]
301: 09-AUG-2002 alogue 115.51 2362454 Enhance Reversals so handle
302: result values with up to 35
303: decimal places. Previously
304: there was a restriction of up
305: to 20 dcs within the fnd_number
306: code.
307: 01-AUG-2002 dsaxby 115.50 2492007 Prevent ora-01403
308: no data found from within
309: bal_adjust_actions.
5589: l_num_found boolean;
5590: begin
5591:
5592: -- intialise mask for a number with 35 decimal places
5593: -- fnd_number.number_to_canonical uses a mask with only 20 decimal places
5594: -- bug 2362454
5595: -- increased to 38 decimal places and redelieverd under bug 2587443
5596: -- Bug 13359813 - Customer had result value with 22 numbers before decimal
5597: -- this is a valid result generated from payroll run. Needed to increase allowed
8510: balance_expiry_level, bal_context_string,
8511: alb.assignment_action_id, alb.value,
8512: alb.expired_assignment_action_id, alb.expired_value,
8513: alb.prev_assignment_action_id, alb.prev_balance_value,
8514: fnd_number.canonical_to_number(rrv.result_value),
8515: alb.scale, dummy_date,dummy_date,dummy_date);
8516:
8517: if l_change_flag = TRUE then
8518: update pay_assignment_latest_balances
8539: balance_expiry_level, bal_context_string,
8540: plb.assignment_action_id, plb.value,
8541: plb.expired_assignment_action_id, plb.expired_value,
8542: plb.prev_assignment_action_id, plb.prev_balance_value,
8543: fnd_number.canonical_to_number(rrv.result_value),
8544: plb.scale,dummy_date,dummy_date,dummy_date);
8545:
8546: if l_change_flag = TRUE then
8547: update pay_person_latest_balances
8570: balance_expiry_level, bal_context_string,
8571: lb.assignment_action_id, lb.value,
8572: lb.expired_assignment_action_id, lb.expired_value,
8573: lb.prev_assignment_action_id, lb.prev_balance_value,
8574: fnd_number.canonical_to_number(rrv.result_value),
8575: lb.scale,lb.expiry_date, lb.expired_date,lb.prev_expiry_date);
8576:
8577: if l_change_flag = TRUE then
8578: update pay_latest_balances