Results for “c_test_date”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.AP_APXINDIA_XMLP_PKG is a PL/SQL package that supports the Oracle Payables India localization XML Publisher report (report code APXINDIA). It follows the standard XML Publisher report package pattern: Oracle Reports/XML Publisher generates a package shell that exposes report-level parameters and global variables as PL/SQL package state, and provides named callback functions that the report engine invokes at defined points in the report lifecycle (BeforeReport, AfterReport) as well as helper functions for LOV/data-source queries and lexical parameter resolution.
The package is defined with AUTHID CURRENT_USER and carries a header date of 2007/12/27 (version 120.0). It is classified as API classification OTHER, meaning it is not part of a formal public API surface; it is report boilerplate intended for internal use by the concurrent report executable.
Key Procedures and Functions
The package declares 20 documented functions, grouped by role:
- Lifecycle callbacks: BEFOREREPORT and AFTERREPORT execute immediately before and after report execution respectively; CUSTOM_INIT performs additional setup logic and is typically invoked from BeforeReport.
- Data retrieval helpers: GET_NLS_STRINGS loads translated (NLS) message strings; GET_BASE_CURR_DATA retrieves base currency attributes such as base precision; GET_COMPANY_NAME resolves the organization/company name; GET_HEADER_VALUES populates report header variables.
- Parameter/lexical binding accessors: Each
*_pfunction returns the value of a corresponding package global for use in report SQL and layout, including C_BASE_MIN_ACCT_UNIT_P, C_VEN_NAME_P, C_BASE_CURRENCY_CODE_P, C_TEST_DATE_P, C_BASE_PRECISION_P, C_NLS_ALL_P, C_PAY_GROUP_P, C_NLS_NO_DATA_EXISTS_P, C_VENDOR_TYPE_P, C_COMPANY_NAME_HEADER_P, C_REPORT_START_DATE_P, C_REPORT_RUN_TIME_P, and C_NLS_END_OF_REPORT_P. - User parameters: P_SOB_ID (set of books), P_CONC_REQUEST_ID (concurrent request ID), P_DEBUG_SWITCH, P_VEN_ID (default 'All'), P_VENDOR_TYPE (default 'All'), P_PAY_GROUP (default 'All'), P_MIN_DISC_AMOUNT, P_MIN_INV_AMOUNT, P_DISC_THRU_DATE and its character counterpart P_DISC_THRU_DATE_p, and P_MIN_PRECISION.
The accessor C_TEST_DATE_P returns the value of the package global C_TEST_DATE (varchar2(9)), which the report uses to control date validation/test-mode behavior. This is the object matched by the user's search term.
Tables Accessed
The only documented table reference is AP_SYSTEM_PARAMETERS, accessed through an APPS synonym (a custom/base reporting synonym). This table supplies Payables system-level defaults, most notably the set of books and base currency context used by GET_BASE_CURR_DATA and GET_COMPANY_NAME. All other data is obtained via the report's own queries rather than through package-level SQL.
Usage Notes
The package is not intended for direct invocation. It is referenced by the APXINDIA XML Publisher concurrent program definition, which supplies the P_* user parameters, and by the report data model, which calls the C_*_p accessors to resolve layout fields and lexical references. Because it is defined as AUTHID CURRENT_USER and classified as OTHER, it should be treated as internal report infrastructure: customizations should use the supported Payables APIs rather than calling or modifying this package. Any change to the package body must be recompiled against the APPS schema and reverified for the concurrent program to function correctly. No other packages reference it.