Search Results get_inst_code




Overview
Explore in AI Chat

Overview

GMP_DESPATCH_LOAD_RPT_PKG is an Oracle EBS Process Manufacturing (OPM) report utility package, owned by the APPS schema and classified under the OTHER API category. It supports the despatch and resource load reporting functionality within the GMP (Process Manufacturing) module, providing both the data extraction logic and the XML generation/transfer mechanisms required by concurrent programs and Oracle XML Publisher (BI Publisher) report templates. The package resides at version 120.1 (header GMPRDESS.pls, dated 2005/07/29) and is identified as "noship," indicating it is an internal, non-shipped object intended for restricted, internal use rather than as a public integration API.

The package operates on the principle of separating front-end report rendering from back-end data sourcing. It exposes XML generation procedures that build report payloads from resource despatch, resource load, and instance-level data, plus helper functions that resolve internal IDs into user-facing codes and descriptions.

Key Procedures and Functions

  • PRINT_RES_DESP — Prints (renders) the resource despatch report. It accepts an organization range, resource range, resource instance range, date range, and template/template locale parameters, and returns the standard concurrent program errbuf and retcode out parameters.
  • PRINT_RES_LOAD — Prints the resource load report. It accepts instance, organization, and plan identifiers in addition to the organization, resource, instance, and date ranges and template parameters used by the despatch report.
  • GME_RES_GENERATE_XML and APS_RES_GENERATE_XML — Generate the XML output consumed by the report templates for the GME and APS resource reporting flows respectively. These are invoked internally by the print procedures.
  • RESDL_GENERATE_OUTPUT — Produces report output for a given sequence number, driving the generation pipeline for a specific run.
  • RD_XML_TRANSFER — Transfers the generated XML payload (for a given sequence number) to its destination, accepting errbuf and retcode for concurrent program integration.
  • GET_ORGN_CODE — Returns the organization code for a supplied organization ID.
  • GET_INST_CODE — Returns the instance code for a supplied instance ID. This is the helper the user searched for by name ("get_inst_code"). It is a code-resolution convenience function used when building report output.
  • GET_PLAN_CODE — Returns the plan code for a supplied plan ID.
  • GET_RESOURCE_DESC — Returns the description text for a supplied resource ID.
  • GET_RESOURCE_INST — Resolves resource instance data for a supplied identifier.

Tables Accessed

Usage Notes

GMP_DESPATCH_LOAD_RPT_PKG is typically invoked from Oracle EBS concurrent programs registered against the PRINT_RES_DESP and PRINT_RES_LOAD entry points, which accept the standard errbuf/retcode signature required by the concurrent manager. The XML generation and transfer procedures are called internally to produce and stage report payloads for Oracle XML Publisher templates, using the template and template locale parameters passed in from the concurrent program definition.

Because the package is classified as OTHER and marked "noship," it is not delivered as a supported public API and should be treated as an internal implementation detail of the despatch/load reporting feature set. Customizations that call GET_INST_CODE, GET_PLAN_CODE, GET_ORGN_CODE, or GET_RESOURCE_DESC directly should be aware that these are lightweight lookup helpers subject to change across releases; the documented signature for GET_INST_CODE is get_inst_code(p_inst_id IN NUMBER) RETURN VARCHAR2. No other packages reference this package, confirming its role as a leaf-level report utility rather than a shared service.