Search Results cp_struct_num_p
Overview
JG_JGZZRCAK_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API. The name follows the standard Oracle Reports convention in which a report executable or definition (short name JGZZRCAK, extended name JG_JGZZRCAK_XMLP) is paired with a generated XML Publisher (XMLP) package. The "JG" prefix identifies the object as belonging to the Oracle Public Sector / Local Government product family, and the report concerns customer receipts. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher conversion wraps the original Oracle Reports PL/SQL logic into a database package so that the report can be executed against an XML data template. The package status is VALID in the APPS schema, and it exposes a documented set of 67 procedures and functions that perform data selection, formatting, number-to-word conversion, and document sequence auditing for the receipt output. Its business purpose is to drive the printed or published customer receipt document, including currency amounts, document sequencing compliance, and the associated customer and receipt attributes.
Key Procedures and Functions
The documented entry points cover report lifecycle and value-derivation logic:
- BEFOREREPORT and AFTERREPORT — standard XML Publisher/Reports package hooks invoked at the start and end of report execution to initialise and clean up session state and parameters.
- CUSTOMER_RECEIPTS — the primary data-retrieval logic that gathers receipt records for the report output.
- AR_DOC_SEQUENCE_AUDIT_P — audit routine associated with Accounts Receivable document sequencing, used to record or verify sequence assignment for receipts.
- CONVERT_NUMBER and CONVERT_NUMBER2 — number-to-text conversion helpers, typically used to render an amount in words.
- GET_WORD_VALUE and CF_WORD_AMOUNTFORMULA — the amount-in-words formula and its supporting value lookup.
- CF_COUNTFORMULA — a count formula used within the report/template layout.
- PRECISION — precision determination for numeric formatting.
- CP_FUNC_CURRENCY_P, CP_PRECISION_P, CP_STRUCT_NUM_P, CP_SOB_NAME_P, CP_WHERE_RECEIPT_DATES_P, CP_SUB_UNIT_PLURAL_P, CP_SUB_UNIT_SINGULAR_P, CP_UNIT_PLURAL_P, CP_UNIT_SINGULAR_P, CP_UNIT_RATIO_P — a family of "CP_" (concurrent/parameter) functions supplying functional currency, precision, structure number, set-of-books name, receipt date predicates, and singular/plural unit and ratio labels for the layout.
Parameter lists are not reproduced here; the procedures perform the purposes named above.
Tables Accessed
The package reads and, where auditing applies, writes the following tables through APPS synonyms:
- AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY — receipt header and history data for the report.
- AR_DOC_SEQUENCE_AUDIT, FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_ASSIGNMENTS, FND_DOC_SEQUENCE_CATEGORIES, FND_DOC_SEQUENCE_USERS — document sequencing setup and audit tables used to validate and record receipt document numbers.
- HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES — Trading Community Architecture customer, site, and address details printed on the receipt.
- DUAL — used for single-row computations.
Usage Notes
JG_JGZZRCAK_XMLP_PKG is not invoked directly by end users or forms. It is executed as part of the JGZZRCAK XML Publisher report, normally submitted as a concurrent program from the Receivables or Public Sector receipts menu after receipt entry or remittance processing. The package is referenced by no other packages in the documented metadata, so its dependencies flow outward to the AR and FND tables rather than inward from other PL/SQL. Custom development should not call these procedures directly; instead, customisations should clone the report and its XML template if modified receipt output is required.