723: debug_info VARCHAR2(100);
724:
725: CURSOR invoice_status_cursor is
726: select
727: AP_INVOICES_PKG.GET_APPROVAL_STATUS(
728: AI.INVOICE_ID,
729: AI.INVOICE_AMOUNT,
730: AI.PAYMENT_STATUS_FLAG,
731: AI.INVOICE_TYPE_LOOKUP_CODE),
728: AI.INVOICE_ID,
729: AI.INVOICE_AMOUNT,
730: AI.PAYMENT_STATUS_FLAG,
731: AI.INVOICE_TYPE_LOOKUP_CODE),
732: AP_INVOICES_PKG.GET_HOLDS_COUNT(
733: AI.INVOICE_ID),
734: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
735: AI.INVOICE_ID),
736: AP_INVOICES_PKG.GET_POSTING_STATUS(
730: AI.PAYMENT_STATUS_FLAG,
731: AI.INVOICE_TYPE_LOOKUP_CODE),
732: AP_INVOICES_PKG.GET_HOLDS_COUNT(
733: AI.INVOICE_ID),
734: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
735: AI.INVOICE_ID),
736: AP_INVOICES_PKG.GET_POSTING_STATUS(
737: AI.INVOICE_ID),
738: AI.AMOUNT_PAID,
732: AP_INVOICES_PKG.GET_HOLDS_COUNT(
733: AI.INVOICE_ID),
734: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
735: AI.INVOICE_ID),
736: AP_INVOICES_PKG.GET_POSTING_STATUS(
737: AI.INVOICE_ID),
738: AI.AMOUNT_PAID,
739: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
740: AI.INVOICE_ID) + 1,
735: AI.INVOICE_ID),
736: AP_INVOICES_PKG.GET_POSTING_STATUS(
737: AI.INVOICE_ID),
738: AI.AMOUNT_PAID,
739: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
740: AI.INVOICE_ID) + 1,
741: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
742: AI.INVOICE_ID),
743: decode(AB.BATCH_ID,