DBA Data[Home] [Help]

APPS.AP_HOLDS_PKG dependencies on AP_INVOICES_PKG

Line 509: l_approval_status := ap_invoices_pkg.get_approval_status(x_invoice_id,

505: l_invoice_type_lookup_code
506: FROM ap_invoices
507: WHERE invoice_id = x_invoice_id;
508:
509: l_approval_status := ap_invoices_pkg.get_approval_status(x_invoice_id,
510: l_invoice_amount,
511: l_payment_status_flag,
512: l_invoice_type_lookup_code);
513:

Line 834: select ap_invoices_pkg.get_holds_count(invoice_id),

830: current_calling_sequence VARCHAR2(2000);
831: debug_info VARCHAR2(100);
832:
833: cursor l_invoice_status_cursor is
834: select ap_invoices_pkg.get_holds_count(invoice_id),
835: ap_invoices_pkg.get_approval_status(
836: invoice_id,
837: invoice_amount,
838: payment_status_flag,

Line 835: ap_invoices_pkg.get_approval_status(

831: debug_info VARCHAR2(100);
832:
833: cursor l_invoice_status_cursor is
834: select ap_invoices_pkg.get_holds_count(invoice_id),
835: ap_invoices_pkg.get_approval_status(
836: invoice_id,
837: invoice_amount,
838: payment_status_flag,
839: invoice_type_lookup_code)