Search Results validate_vi

Overview

PA_TRX_IMPORT is a core Oracle Projects PL/SQL package that supports the import and validation of transactions and adjustments into the Oracle Projects transaction interface. In Oracle EBS 12.1.1 and 12.2.2, the package is owned by the APPS schema and is classified as a miscellaneous (OTHER) API object. Its primary role is to validate and prepare interface rows before the Transaction Import process transfers them into the production transaction tables. This includes validating items, distributions, expenditure types, organization names, and project-related attributes, as well as checking for duplicate items and duplicate adjustment items. Additionally, the package incorporates logic to validate supplier invoice (AP) related data, such as prepayment and payment distribution amounts, against Projects data, and it provides locking and date-related utility functions for PO-line/task processing. The package is heavily referenced across Oracle Grants and Oracle Projects components, indicating a broad functional footprint that spans cost collection and grants management.

Key Procedures and Functions

The documented procedures and functions (18 total) serve distinct validation, lookup, and control purposes:

• GETTRXSRCINFO – Retrieves transaction source information used during import.
• GETETYPEINFO – Retrieves expenditure type information for validation.
• GETNLRINFO – Obtains non-labor resource information.
• CHECKDUPITEM – Checks for duplicate interface items.
• CHECKDUPADJITEM – Checks for duplicate adjustment items.
• GETPROJTYPEINFO – Retrieves project type information.
• CHECKCCID – Validates code combinations (chart of accounts).
• GETORGNAME – Retrieves organization name details.
• VALIDATE_VI – Performs validation of interface records.
• VALIDATEITEM – Validates general interface items.
• INIT – Initializes package-level session variables and setup.
• COUNT_STATUS – Counts records by status for processing control.
• VALIDATEITEMOTL – Validates items associated with OTL (Oracle Time and Labor) processing.
• INIT_PO_AMT_CHK – Initializes purchase-order amount checks.
• RELEASE_PO_LINE_TASK_LOCK – Releases locks held on PO line/task combinations.
• SET_GVAL_PROJTSKEI_DATE – Sets a global value for project/task expenditure item dates.
• GET_GVAL_PROJTSKEI_DATE – Retrieves that stored global date value.
• VALIDATE_EXP_DATE – Validates expenditure item dates.

Tables Accessed

The package reads and writes through APPS synonyms to the following documented tables:

• PA_TRANSACTION_INTERFACE_ALL – The transaction interface staging table where validated rows are held prior to import.
• AP_INVOICES, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL – Used to validate supplier invoice and distribution data.
• AP_INVOICE_PAYMENTS, AP_PAYMENT_HIST_DISTS, AP_PAYMENT_SCHEDULES_ALL, AP_PREPAY_APP_DISTS – Used to validate payment and prepayment application data against Projects transactions.
• AP_SELF_ASSESSED_TAX_DIST, AP_SELF_ASSESSED_TAX_DIST_ALL – Used to validate self-assessed tax distributions.
• GL_BC_PACKETS_S – Supports balance and control packet processing during import.
• GL_CODE_COMBINATIONS – Used for chart of accounts validation.
• GL_DAILY_CONVERSION_TYPES – Used for currency conversion type validation.
• GL_PERIOD_STATUSES – Used to verify open/closed accounting periods.

Usage Notes

PA_TRX_IMPORT is typically invoked indirectly by Oracle Projects Transaction Import concurrent programs and related processes rather than being called directly by end users. It is referenced by numerous dependent packages and programs, including PAAPIMP_PKG (the interface import package), PA_ALLOC_RUN (allocation processing), PA_OTC_API, GMS_PA_COSTING_PKG, GMS_AWARD_DIST_ENG, GMS_LD_PKG, and GMS_TRANSACTIONS_PUB, as well as the PAXTRTRX XML publisher component. Custom code that must perform pre-import validation, duplicate checking, or PO/task locking should call the appropriate procedures rather than replicate the logic. Because APPS.PA_TRX_IMPORT is a valid public package, it can be safely referenced from custom PL/SQL and Oracle Projects extensions. Effective use requires a solid understanding of Oracle Projects transaction interface structures and AP payment distribution data used for supplier invoice processing.