Results for “get_event_description”

16 results




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

Overview

EDR_PRINT_PROCESS_PVT is a private PL/SQL package in the APPS schema within Oracle E-Business Suite, part of the EDR (Electronic Document Records / E-Records) module delivered with Oracle EBS 12.1.1 and 12.2.2. The package encapsulates the server-side logic required to prepare, submit, and manage the printing of E-Records captured in the EDR framework. Its responsibilities centre on taking a selected query or set of E-Record identifiers, resolving the associated printable content, submitting the request to the concurrent manager for output, and maintaining the print-count audit information on those records.

The API classification is PVT (private), indicating that the package is not intended as a public integration surface. It is an internal utility invoked by other EDR components, forms, and concurrent programs rather than by customer-written code. The header comment records that the package was shipped as part of the EDR print utilities, with the source file identified as EDRVPRTS.pls.

Key Procedures and Functions

  • SUBMIT_PRINT_JOB — Submits a print job for a given query identifier and increments the print count for the affected records. It exposes an API version and an initialisation flag for the message stack, accepts the query identifier and a flag controlling whether the caller waits for the concurrent request to complete, and returns the API status, message count, message data, and the concurrent request ID and status. This is the primary entry point for initiating output.
  • PROCESS_PRINTRECORDS — Processes a collection of E-Records passed as a table and prepares them for print or query. It accepts the API version, initialisation flag, the table of E-Record identifiers, and a flag indicating whether related (child) records should be included.
  • ACKNOWLEDGE_PRINT — Records acknowledgement that printing has occurred, supporting the audit trail of which E-Records have been output.
  • GET_PARENT_ERECORD_ID — Resolves the parent E-Record identifier for a given record, supporting the hierarchy and related-record inclusion logic used during processing.
  • GET_EVENT_DESCRIPTION — Returns the description associated with an EDR event, used for labelling and audit purposes during print processing.

Tables Accessed

The documented metadata does not enumerate specific base tables or APPS synonyms referenced by EDR_PRINT_PROCESS_PVT. Functionally, the package operates against the EDR E-Record repository (the tables holding E-Record headers, lines, relationships, and print counters) and against the standard concurrent processing tables used to return request ID and request status. Because the package is classified PVT and references no documented public tables via synonyms, consumers should treat its table dependencies as internal implementation detail that may change between patch levels.

Usage Notes

EDR_PRINT_PROCESS_PVT is invoked by the EDR print and query user interface, by EDR concurrent programs that generate output for batches of E-Records, and by internal EDR PL/SQL that needs to submit a print request or resolve record relationships. The package is referenced by zero other packages according to the documented metadata, reinforcing its role as a leaf-level private utility.

Because the API is private, Oracle does not guarantee backward compatibility of its signature. Customisations should not call SUBMIT_PRINT_JOB, PROCESS_PRINTRECORDS, or the remaining routines directly; instead, use the supported EDR forms and concurrent programs. When troubleshooting EDR output, the package is relevant to the server-side print submission path, not to client-side printer configuration or network connectivity.