216: IS
217: l_ref_suffix_inner number; -- Changes for bug 7368371
218: BEGIN
219:
220: SELECT csi_pa_interface_s.nextval
221: INTO l_ref_suffix_inner -- Changes for bug 7368371
222: FROM sys.dual;
223:
224: x_nl_pa_interface_rec.transaction_source := p_ei_rec.transaction_source;
482: debug('capitalizable record # '||i);
483: debug(' capitalizable exp_item_id : '||l_exp_item_rec.expenditure_item_id);
484: debug(' capitalizable quantity : '||l_exp_item_rec.quantity);
485:
486: SELECT csi_pa_interface_s.nextval
487: INTO l_ref_sufix
488: FROM sys.dual;
489:
490: l_nl_pa_interface_tbl(i).transaction_source := ei_rec.transaction_source;
572: debug(' spillover quantity : '|| l_exp_item_rec.split_quantity);
573:
574: l_nl_pa_interface_tbl(i) := l_nl_pa_interface_tbl(i-1);
575:
576: SELECT csi_pa_interface_s.nextval
577: INTO l_ref_sufix
578: FROM sys.dual;
579:
580: l_nl_pa_interface_tbl(i).orig_transaction_reference := p_in_srv_pa_attr_rec.transaction_id;