4951: v_del_val_start := nvl(p_del_val_start_date, sysdate);
4952: v_del_sess_date := nvl(p_del_sess_date, sysdate);
4953: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
4954:
4955: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
4956: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
4957: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele
4958: assoc_eles(4) := p_ele_type_id; -- Base ele
4959:
4952: v_del_sess_date := nvl(p_del_sess_date, sysdate);
4953: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
4954:
4955: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
4956: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
4957: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele
4958: assoc_eles(4) := p_ele_type_id; -- Base ele
4959:
4960: l_num_assoc_eles := 4;
4953: pay_db_pay_setup.set_session_date(nvl(p_del_val_start_date, sysdate));
4954:
4955: assoc_eles(1) := fnd_number.canonical_to_number(p_ele_info_18); -- Special Inputs ele
4956: assoc_eles(2) := fnd_number.canonical_to_number(p_ele_info_19); -- Special Features ele
4957: assoc_eles(3) := fnd_number.canonical_to_number(p_ele_info_20); -- Withholding ele
4958: assoc_eles(4) := p_ele_type_id; -- Base ele
4959:
4960: l_num_assoc_eles := 4;
4961:
4983:
4984: exception when NO_DATA_FOUND then null;
4985: End;
4986:
4987: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
4988: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
4989: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4984: exception when NO_DATA_FOUND then null;
4985: End;
4986:
4987: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
4988: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
4989: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4992: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
4985: End;
4986:
4987: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
4988: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
4989: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4992: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
4993: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
4987: assoc_bals(1) := fnd_number.canonical_to_number(p_ele_info_10); -- Primary bal
4988: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
4989: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4992: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
4993: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
4994: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
4995:
4988: assoc_bals(2) := fnd_number.canonical_to_number(p_ele_info_11); -- Accrued bal
4989: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4992: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
4993: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
4994: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
4995:
4996: Begin
4989: assoc_bals(3) := fnd_number.canonical_to_number(p_ele_info_12); -- Arrears bal
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4992: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
4993: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
4994: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
4995:
4996: Begin
4997: select balance_type_id
4990: assoc_bals(4) := v_not_taken_baltype_id; -- Not Taken bal
4991: assoc_bals(5) := fnd_number.canonical_to_number(p_ele_info_14); -- Bond Purch bal
4992: assoc_bals(6) := fnd_number.canonical_to_number(p_ele_info_15); -- Able bal
4993: assoc_bals(7) := fnd_number.canonical_to_number(p_ele_info_16); -- Additional Amt bal
4994: assoc_bals(8) := fnd_number.canonical_to_number(p_ele_info_17); -- Replacement Amt bal
4995:
4996: Begin
4997: select balance_type_id
4998: into v_elig_bal_id