DBA Data[Home] [Help]

APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on AP_INVOICES_PKG

Line 785: AP_INVOICES_PKG.GET_APPROVAL_STATUS(

781: debug_info VARCHAR2(100);
782:
783: CURSOR invoice_status_cursor is
784: select
785: AP_INVOICES_PKG.GET_APPROVAL_STATUS(
786: AI.INVOICE_ID,
787: AI.INVOICE_AMOUNT,
788: AI.PAYMENT_STATUS_FLAG,
789: AI.INVOICE_TYPE_LOOKUP_CODE),

Line 790: AP_INVOICES_PKG.GET_HOLDS_COUNT(

786: AI.INVOICE_ID,
787: AI.INVOICE_AMOUNT,
788: AI.PAYMENT_STATUS_FLAG,
789: AI.INVOICE_TYPE_LOOKUP_CODE),
790: AP_INVOICES_PKG.GET_HOLDS_COUNT(
791: AI.INVOICE_ID),
792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(

Line 792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577

788: AI.PAYMENT_STATUS_FLAG,
789: AI.INVOICE_TYPE_LOOKUP_CODE),
790: AP_INVOICES_PKG.GET_HOLDS_COUNT(
791: AI.INVOICE_ID),
792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(
795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,

Line 794: AP_INVOICES_PKG.GET_POSTING_STATUS(

790: AP_INVOICES_PKG.GET_HOLDS_COUNT(
791: AI.INVOICE_ID),
792: AP_INVOICES_PKG.GET_SCHED_HOLDS_COUNT( --bug 5334577
793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(
795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,
797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
798: AI.INVOICE_ID) + 1,

Line 797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(

793: AI.INVOICE_ID),
794: AP_INVOICES_PKG.GET_POSTING_STATUS(
795: AI.INVOICE_ID),
796: AI.AMOUNT_PAID,
797: AP_INVOICES_PKG.GET_MAX_LINE_NUMBER(
798: AI.INVOICE_ID) + 1,
799: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
800: AI.INVOICE_ID),
801: decode(AB.BATCH_ID,