Results for “load_input_record”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.OKL_OPEN_INTERFACE_PVT_W package is a public wrapper API within the Oracle E-Business Suite Oracle Contracts (OKL / ETRM) module. Its name and header comment (OKLEKOIS.pls) indicate that it belongs to the OKL Open Interface component, the integration layer used to import external lease and contract data into the ETRM repository. The package presents three documented entry points that collectively support the bulk import lifecycle: validating an incoming set of open-interface records, loading those records into the interface staging tables, and submitting the actual import contract concurrent program for processing.

The "_W" suffix follows Oracle's convention for a wrapper layer that exposes a clean, stable public signature over internal private procedures. It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user, so callers must themselves hold the necessary grants on the underlying OKL interface tables and concurrent program submissions. The package is classified as API type OTHER, reflecting its role as a supporting integration utility rather than a business-event API.

Key Procedures and Functions

The package exposes exactly three documented program units:

• CHECK_INPUT_RECORD — A procedure that validates the open-interface staging records matching the supplied selection criteria. It accepts a standard message-list flag, the standard return status/count/data output parameters, and selection filters covering p_batch_number, a start-date range (p_start_date_from, p_start_date_to), p_contract_number, and p_customer_number. It returns x_total_checked, the count of records examined. This is the entry point a user reaches when supplying the p_customer_number filter to narrow validation to a specific customer's staged contracts.
• LOAD_INPUT_RECORD — A procedure that loads the qualifying staged records into the interface tables following the same selection parameters as CHECK_INPUT_RECORD. It returns x_total_loaded, the number of records successfully loaded, and reports status through the standard messaging outputs.
• SUBMIT_IMPORT_CONTRACT — A function that submits the import contract process. Its signature includes p_api_version, p_init_msg_list, the standard output parameters, and selection parameters including p_batch_number, p_contract_number, p_start_date, p_end_date, and p_party_number. It returns a numeric request identifier. Note that this function filters by party number rather than customer number, reflecting the trading-partner model used at the submission stage.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables accessed through APPS synonyms. Based on the OKL open-interface design, the procedures operate against the OKL open-interface staging tables (the OKL_OPEN_INTERFACE family) and the interface tables into which records are loaded before the import contract concurrent program consumes them. No tables are listed as directly referenced in the documented metadata.

Usage Notes

This package is typically invoked from the Oracle Contracts open-interface concurrent programs or from custom PL/SQL integration code that follows the validate–load–submit pattern. A caller runs CHECK_INPUT_RECORD to identify rejected records, correcting them before LOAD_INPUT_RECORD moves data forward. The p_customer_number parameter is the filter most commonly searched by users performing targeted imports for a single customer. Because the package is AUTHID CURRENT_USER, any custom caller must possess execute privilege and appropriate table access. The package header is dated 2005 and it is referenced by zero other packages, indicating a standalone utility with no downstream dependencies.