598: CURSOR csr_inv_line(cv_invoice_line_id IN NUMBER) IS
599: SELECT inventory_item_id
600: , uom_code
601: , quantity_invoiced
602: FROM ra_customer_trx_lines
603: WHERE customer_trx_line_id = cv_invoice_line_id;
604:
605: CURSOR csr_inv_line_exist(cv_invoice_id IN NUMBER, cv_invoice_line_id IN NUMBER) IS
606: SELECT customer_trx_line_id
603: WHERE customer_trx_line_id = cv_invoice_line_id;
604:
605: CURSOR csr_inv_line_exist(cv_invoice_id IN NUMBER, cv_invoice_line_id IN NUMBER) IS
606: SELECT customer_trx_line_id
607: FROM ra_customer_trx_lines
608: WHERE customer_trx_id = cv_invoice_id
609: AND customer_trx_line_id = cv_invoice_line_id;
610:
611: l_claim_line_id NUMBER;
633: l_batch_source_id NUMBER;
634: l_payables_source VARCHAR2(30);
635: l_vendor_in_sys NUMBER;
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
634: l_payables_source VARCHAR2(30);
635: l_vendor_in_sys NUMBER;
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
642: l_line_mix_amt_sign BOOLEAN := FALSE;
635: l_vendor_in_sys NUMBER;
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
642: l_line_mix_amt_sign BOOLEAN := FALSE;
643:
636: l_rec_clr_in_sys NUMBER;
637: l_inv_item_id RA_CUSTOMER_TRX_LINES.inventory_item_id%TYPE;
638: l_inv_uom_code RA_CUSTOMER_TRX_LINES.uom_code%TYPE;
639: l_inv_quantity RA_CUSTOMER_TRX_LINES.quantity_invoiced%TYPE;
640: l_inv_line_id RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE;
641: l_gl_date_type VARCHAR2(30);
642: l_line_mix_amt_sign BOOLEAN := FALSE;
643:
644: l_cline_sum_curr_amt NUMBER := 0;