Results for “set_env”
10 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_REPORT_PVT is an internal private PL/SQL package in the APPS schema that underpins the Oracle Contracts (OKC) reporting framework in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary responsibility is the runtime assembly, transformation, and delivery of contract reports — most notably the generation of HTML, XML, and styled output derived from report definitions, XSL stylesheets, and SQL extract statements stored in the contract reporting tables. Because it is classified as a PVT package, it is not intended as a public API; it is consumed by the public contract reporting layer and by concurrent processing infrastructure. The package operates with dependencies on OKC_API, OKC_PARAMETERS_PUB, STANDARD, and the JTF_VARCHAR2_TABLE_2000 collection type, and it relies on DBMS_LOB and DBMS_TRANSACTION for large-object handling and transactional control during report execution.
Key Procedures and Functions
The package exposes 36 documented procedures and functions that cover the full report lifecycle. The following represent the core documented entries:
- GET_XML, GET_HTM — Returns the generated report content in XML or HTML form, respectively, after transformation of the underlying data set.
- GET_XSL_HELP, GET_ART_HELP — Retrieves help content associated with XSL stylesheets and article definitions used within report templates.
- SET_ENV — Establishes the session and environment context, including NLS-related settings, prior to report execution.
- REPORT_URL, GET_CONTRACT_URL, URL_OTHER_PARAMS — Construct and return URLs used to access generated reports and contract records, assembling additional query parameters as required.
- CHECK_ACCESS, CHECK_TRANSF_PATH — Validate user access rights and the availability of the transformation (XSL) path before processing begins.
- PRERUN, EXEC_OKC_WEB_PRERUN, EXEC_OKC_WEB_LOG_RUN — Manage the pre-execution and logged-run phases of report processing within the web execution context.
- GET_K_VERSION, GET_SQL_NAME, GET_NEW_ID — Utility functions retrieving contract version identifiers, SQL definition names, and newly generated sequence identifiers.
- TRANSFORMATION_ERROR, ARTICLES_WARNING, NOOP — Error and warning handling routines, plus a no-operation placeholder used by the reporting engine.
- FREE_TEMP_CLOB — Releases temporary CLOB resources allocated during report generation, preventing memory and LOB segment growth.
Tables Accessed
Through APPS synonyms, the package reads and writes the principal contract reporting and contract header tables:
- OKC_REPORT_HTM, OKC_REPORT_XML, OKC_REPORT_XST — Store generated HTML, XML, and transformed report content.
- OKC_REPORT_SQL_B / _TL, OKC_REPORT_XSL_B / _TL — Hold report SQL and XSL stylesheet definitions, including translated descriptions.
- OKC_K_HEADERS_B, OKC_K_HEADERS_TL, OKC_K_VERS_NUMBERS_H — Supply contract header, translated header, and version number data used as report source records.
- OKC_SECTIONS_B — Provides contract section structure incorporated into report output.
DBMS_LOB, DBMS_TRANSACTION, NLS_SESSION_PARAMETERS, and PLITBLM are referenced for LOB operations, transactional control, national language session settings, and PL/SQL table handling.
Usage Notes
OKC_REPORT_PVT is not invoked directly by end users or external custom code. It is called internally by the public OKC reporting layer when a contract report is requested — typically triggered from an Oracle Forms interface or a concurrent program that renders contract documents in HTML or XML. The PRERUN and EXEC_OKC_WEB_* routines indicate web-based execution paths within the Contracts application. Customizations should avoid calling this package directly, as its interface is private and unsupported; instead, integrators should target the supported public APIs (such as OKC_API and OKC_PARAMETERS_PUB) that OKC_REPORT_PVT depends upon. The package is referenced by no other packages, confirming its terminal position in the reporting call hierarchy.
-
PACKAGE: APPS.OKC_REPORT_PVT 12.1.1
-
PACKAGE: APPS.OKC_REPORT_PVT 12.2.2