Search Results print_res_load




Overview
Explore in AI Chat

Overview

GMP_DESPATCH_LOAD_RPT_PKG is an Oracle EBS Process Manufacturing (OPM) report package owned by the APPS schema and classified under the ETRM catalog as an OTHER-type API. Its principal business function is to support the despatch and resource load reporting cycle within OPM: it renders despatch report output for resources and resource instances, generates the XML payloads consumed by the corresponding report templates, and resolves descriptive codes for organizations, instances, plans, and resources that appear on those reports. It is a reporting/renderer package rather than a transactional API, and the metadata records zero dependent packages, confirming that it is a leaf-level utility invoked directly by report drivers and concurrent programs.

Key Procedures and Functions

The package exposes both report entry points and small lookup functions. The documented callable units are:

  • PRINT_RES_DESP — the primary report entry point for resource despatch output. It receives standard concurrent program errbuf/retcode OUT parameters, along with from/to ranges for organizations, resources, and resource instances, a start/end date window, and template plus template locale identifiers, then produces the formatted despatch report.
  • PRINT_RES_LOAD — the parallel entry point for resource load reporting. In addition to errbuf/retcode, it accepts an instance identifier, an organization identifier, and a plan identifier, together with the same from/to resource, organization, instance, and date range parameters and template details.
  • GME_RES_GENERATE_XML — builds the XML document for the resource report, populating the temporary XML staging structure used by the template engine.
  • APS_RES_GENERATE_XML — the equivalent XML generation routine for the APS (Advanced Planning) resource variant of the report.
  • RESDL_GENERATE_OUTPUT — produces the rendered output for a given sequence number, operating on data previously staged by the XML generation routines.
  • RD_XML_TRANSFER — transfers the generated XML for a sequence number into the target structure and returns standard concurrent program status codes.
  • GET_PLAN_CODE — returns the plan code (VARCHAR2) for a supplied plan identifier. This is the function surfaced by the "get_plan_code" search and is used to translate the numeric plan ID passed into PRINT_RES_LOAD into the plan name shown on the report output.
  • GET_ORGN_CODE — returns the organization code for a given organization identifier.
  • GET_INST_CODE — returns the instance code for a given instance identifier.
  • GET_RESOURCE_DESC — returns the description of a resource for a given resource identifier.
  • GET_RESOURCE_INST — resolves resource instance information used by the despatch and load report queries.

Tables Accessed

The package reads and writes the following documented objects through APPS synonyms:

  • GMP_RESDISP_XML_TEMP — the temporary staging table holding generated XML for despatch output; written by the XML generation routines and read by the output and transfer procedures.
  • MSC_APPS_INSTANCES — source of instance definitions; underpins GET_INST_CODE and the instance range filtering on both report entry points.
  • MSC_PLANS — source of plan definitions; underpins GET_PLAN_CODE and the plan filter on PRINT_RES_LOAD.
  • MSC_DEPARTMENT_RESOURCES and MSC_DEPT_RES_INSTANCES — departmental resource and resource-instance definitions that supply the organization, resource, and resource-instance values resolved by GET_ORGN_CODE, GET_RESOURCE_DESC, and GET_RESOURCE_INST.
  • DBMS_LOB and DBMS_XMLGEN — Oracle-supplied packages used to construct and manipulate the XML payloads.

Usage Notes

GMP_DESPATCH_LOAD_RPT_PKG is invoked from the OPM despatch and resource load concurrent programs. PRINT_RES_DESP and PRINT_RES_LOAD are the registered report entry points, called with concurrent manager errbuf/retcode parameters plus the range and template arguments supplied by the report's parameter form. Internally, the entry point calls the appropriate XML generation routine (GME_RES_GENERATE_XML or APS_RES_GENERATE_XML), stages the result in GMP_RESDISP_XML_TEMP, and then drives RESDL_GENERATE_OUTPUT and RD_XML_TRANSFER to render and deliver the output. The GET_* functions are single-row lookups that may also be called independently from custom code to resolve organization, instance, plan, and resource codes; because they are defined as SQL-callable functions returning VARCHAR2, they can be embedded in custom report queries, though doing so executes a context switch per row and should be used judiciously. The package carries a noship header marker from release 120.1 (2005), indicating it is an internal, non-shipped-code object; it is not a public API and is not referenced by any other package, so customizations should avoid modifying it and instead wrap or copy the logic as required. It is available in both EBS 12.1.1 and 12.2.2, since the underlying OPM despatch reporting schema is common to both releases.