Search Results get_payment_terms

Overview

APPS.AP_ISP_UTILITIES_PKG is a utility package within the Oracle E-Business Suite Payables module that supports Internet Supplier Portal (ISP) invoice processing and related invoice lifecycle operations. The package encapsulates helper logic that would otherwise be duplicated across invoice entry, matching, approval, hold management, and cancellation flows. Its scope spans document sequence derivation, payment term retrieval, invoice cancellation, tax override handling, invoice header maintenance, purchase order matching support, and approval workflow control.

The package header carries a version identifier reflecting ongoing Oracle maintenance ($Header: apisputs.pls 120.15 2006/12/13), and several historical procedures — notably DISCARD_INV_LINE and INVOKE_AP_WORKFLOW — were explicitly retired through bug-fix code cleanup efforts (Bug 5470344 and Bug 5407726). These procedures remain part of the documented package surface in the ETRM metadata for 12.2.2 but are commented out in the source and are no longer callable.

Key Procedures and Functions

The package exposes a broad utility surface. Key documented procedures include:

• DISCARD_INV_LINE — Historically used to discard a specific invoice line by invoice identifier and line number, with parameters governing cancellability and error reporting. This procedure is retained in the documented metadata but is commented out in the source and is not invoked in supported release paths.
• INVOKE_AP_WORKFLOW — Previously used to launch the Payables approval workflow for an invoice. Also commented out as part of ISP code cleanup.
• GET_DOC_SEQUENCE — Retrieves document sequence numbering information for an invoice, returning the document category code, sequence value, sequence name, and sequence identifier.
• GET_PAYMENT_TERMS — Derives the payment terms identifier and terms date associated with a given invoice.
• CANCEL_SINGLE_INVOICE — Cancels an individual invoice, capturing caller identity, accounting date, and returning a message name, token, and calling sequence for audit and error tracing.
• OVERRIDE_TAX — Supports tax override processing during invoice operations, accepting override status, event identifier, and aggregated error messages.
• UPDATE_INVOICE_HEADER and UPDATE_INVOICE_HEADER2 — Maintain invoice header attributes, including sequence numbering references.
• MATCH_INVOICE_LINES and DISCARD_AND_REMATCH — Support PO matching and rematch reconciliation for invoice lines.
• RELEASE_HOLD — Releases a hold applied to an invoice using documented hold codes and hold records.
• GET_SEC_ATTR_VALUE — Retrieves a security attribute value for a user, supporting data access control.
• GET_PO_NUMBER, GET_PO_HEADER_ID, GET_PO_RELEASE, GET_PO_NUMBER_SWITCHER — Resolve purchase order header, release, and numbering details for matching and display purposes.
• STOP_APPROVAL and UNSUBMIT_SWITCHER — Control approval state, halting approval or reversing submission where permitted.

Tables Accessed

The package reads and writes a defined set of Payables and related application tables, all accessed through APPS synonyms:

• AP_INVOICES_ALL, AP_INVOICES, AP_INVOICE_LINES_ALL, AP_INVOICE_LINES, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_DISTRIBUTIONS — Core invoice header, line, and distribution data.
• AP_HOLDS_ALL, AP_HOLD_CODES — Hold definitions and hold instances applied to invoices.
• AP_INV_APRVL_HIST — Approval history for invoice workflow tracking.
• GL_CODE_COMBINATIONS — Accounting flexfield combinations used in distributions.
• PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURE_TYPES — Project and expenditure attributes supporting project-related invoice lines.
• AK_WEB_USER_SEC_ATTR_VALUES — Security attribute values underpinning user-level access restriction.

Usage Notes

AP_ISP_UTILITIES_PKG is typically invoked indirectly rather than by end users. It is called from ISP invoice submission flows, from concurrent programs that process invoice cancellations and approval transitions, and from other Payables packages; the ETRM metadata records one referencing package. Custom code calling DISCARD_INV_LINE or INVOKE_AP_WORKFLOW on 12.1.1 or 12.2.2 will fail because both procedures are compiled out. Developers should target supported procedures such as CANCEL_SINGLE_INVOICE, RELEASE_HOLD, or the header update routines, and should observe the standard convention of passing Calling_Sequence for diagnostics, Last_Updated_By and Last_Update_Login for audit columns, and OUT NOCOPY parameters for token and error reporting.