5077: v_del_val_start := nvl(p_del_val_start_date, sysdate);
5078: v_del_sess_date := nvl(p_del_sess_date, sysdate);
5079: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
5080:
5081: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
5082: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
5083: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele
5084: assoc_eles(4) := p_ele_type_id; -- Base ele
5085:
5078: v_del_sess_date := nvl(p_del_sess_date, sysdate);
5079: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
5080:
5081: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
5082: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
5083: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele
5084: assoc_eles(4) := p_ele_type_id; -- Base ele
5085:
5086: l_num_assoc_eles := 4;
5079: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
5080:
5081: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
5082: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
5083: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele
5084: assoc_eles(4) := p_ele_type_id; -- Base ele
5085:
5086: l_num_assoc_eles := 4;
5087:
5109:
5110: exception when NO_DATA_FOUND then null;
5111: End;
5112:
5113: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
5114: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
5115: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5110: exception when NO_DATA_FOUND then null;
5111: End;
5112:
5113: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
5114: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
5115: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5118: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
5111: End;
5112:
5113: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
5114: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
5115: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5118: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
5119: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
5113: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
5114: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
5115: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5118: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
5119: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
5120: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
5121:
5114: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
5115: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5118: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
5119: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
5120: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
5121:
5122: Begin
5115: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5118: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
5119: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
5120: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
5121:
5122: Begin
5123: select balance_type_id
5116: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
5117: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
5118: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
5119: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
5120: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
5121:
5122: Begin
5123: select balance_type_id
5124: into v_elig_bal_id