DBA Data[Home] [Help]

APPS.AP_HOLDS_PKG dependencies on AP_INVOICES_PKG

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

525: l_invoice_type_lookup_code
526: FROM ap_invoices
527: WHERE invoice_id = x_invoice_id;
528:
529: l_approval_status := ap_invoices_pkg.get_approval_status(x_invoice_id,
530: l_invoice_amount,
531: l_payment_status_flag,
532: l_invoice_type_lookup_code);
533:

Line 915: select ap_invoices_pkg.get_holds_count(invoice_id),

911: current_calling_sequence VARCHAR2(2000);
912: debug_info VARCHAR2(100);
913:
914: cursor l_invoice_status_cursor is
915: select ap_invoices_pkg.get_holds_count(invoice_id),
916: ap_invoices_pkg.get_approval_status(
917: invoice_id,
918: invoice_amount,
919: payment_status_flag,

Line 916: ap_invoices_pkg.get_approval_status(

912: debug_info VARCHAR2(100);
913:
914: cursor l_invoice_status_cursor is
915: select ap_invoices_pkg.get_holds_count(invoice_id),
916: ap_invoices_pkg.get_approval_status(
917: invoice_id,
918: invoice_amount,
919: payment_status_flag,
920: invoice_type_lookup_code)