Results for “c_nls_all”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AP_APXINDIA_XMLP_PKG is a report-support package body owned by APPS in the Oracle E-Business Suite environment. It backs the XML Publisher (XMLP) report associated with the India-specific Accounts Payable approval and localization requirements. Its header comment identifies a source file named APXINDIAB.pls with a 2007 revision and a noship designation, indicating it is a report library rather than a shipped public API.
The package follows the classic Oracle Reports PL/SQL library pattern. The BeforeReport trigger function initializes the report runtime by sequencing a series of internal boolean-returning helpers, each of which raises a local init_failure exception when it does not complete successfully. This design centralizes report setup so that a single failure point aborts report generation cleanly. The package is classified as OTHER in the ETRM metadata; it exposes no public callable API for external consumers and is referenced by no other packages.
Key Procedures and Functions
The documented package exposes twenty procedures and functions, dominated by the C_* set, which are report-level global placeholders populated during the before-report phase and bound directly into the XML Publisher template.
- BEFOREREPORT — Entry point invoked by the report trigger. Calls the initialization helpers in sequence, formats the discount-through date, and returns a boolean success indicator.
- GET_NLS_STRINGS — The routine central to the user's search on
c_nls_all. It reads a displayed field fromAP_LOOKUP_CODESfor the lookup type NLS REPORT PARAMETER and lookup code ALL, assigning the result to the globalc_nls_alland its parallel globalC_NLS_ALL_P. This supplies the multilingual "select all" label used on report parameters. - GET_BASE_CURR_DATA — Retrieves base currency and precision information used by the report for monetary formatting.
- GET_COMPANY_NAME — Resolves the company name for the report header.
- GET_HEADER_VALUES — Populates header-level report globals such as the report start date and run time.
- AFTERREPORT — Terminates the report, handling the corresponding output globals.
- CUSTOM_INIT — Reserved hook for customer-specific initialization.
- Placeholder functions (C_*) —
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, andC_NLS_END_OF_REPORT_Pexpose these values to the report layout. Parameter functions such asP_DISC_THRU_DATEsupply the discount-through date input.
Tables Accessed
The ETRM metadata documents a single table reference: AP_SYSTEM_PARAMETERS, accessed through APPS synonyms, which supplies base currency, precision, and ledger-related context for the India report. In addition, the source excerpt shows GET_NLS_STRINGS querying AP_LOOKUP_CODES directly, filtering on the lookup type NLS REPORT PARAMETER and lookup code ALL to populate c_nls_all. All access is read-only; the package performs no inserts, updates, or deletes.
Usage Notes
The package is invoked by Oracle Reports/XML Publisher at report execution time, not by interactive forms or general application code. Both the before-report and after-report functions are attached to their respective report triggers, and the C_* globals are consumed by the XML template for parameter prompts, headers, and footers. Because get_nls_strings depends on seeded AP_LOOKUP_CODES values, administrators should confirm that the NLS REPORT PARAMETER / ALL lookup exists in the target instance. The package is not referenced by other packages, so customization must be confined to cloning or extending the report definition rather than calling into these routines from custom PL/SQL.