Search Results populate_bo_and_save_concur




Overview
Explore in AI Chat

Overview

POS_SUPP_GENERATE_RPT_PKG is an APPS-owned PL/SQL package in the Oracle E-Business Suite supplier management module. Its name, together with its dependency on POS_TBL_NUMBER and its documented procedures, indicates that it supports the generation and persistence of supplier-related reports, most notably reports rendered as XML. The package provides the server-side logic that a concurrent program or form invokes when a user requests a supplier report: it resolves the current supporting report identifier, collects and formats source data, builds a business object payload, and stores the result for downstream retrieval and printing.

The object is classified as OTHER in the ETRM documentation, meaning it is a supporting internal package rather than a public, supported API. It carries a VALID status in the APPS schema at 12.1.1 and 12.2.2. Dependency metadata shows the package references APPS.POS_TBL_NUMBER and STANDARD, and that it is referenced only by itself, confirming its role as an internal implementation unit rather than an extension point.

Key Procedures and Functions

  • GET_CURR_SUPP_XML_RPT_ID — Returns the identifier of the current supplier XML report instance, allowing the package to correlate generated content with a specific report run.
  • REM_FIRST_COMMA — Utility routine that removes a leading comma from a delimited string, typically after iterative string concatenation.
  • LIST_TO_CSV_VARCHAR — Converts a PL/SQL list into a comma-separated VARCHAR2 value for use in SQL predicates or report parameters.
  • PARSE_LIST — Parses a delimited string into its component elements, the inverse operation of LIST_TO_CSV_VARCHAR.
  • GENERATE_REPORT_EVENT — Orchestrates the report generation event, coordinating data collection and output creation for a supplier report.
  • POPULATE_BO_AND_SAVE_CONCUR — Populates the business object structure and saves it, supporting concurrent processing of report output.
  • GET_BO_AND_INSERT — Retrieves the business object content and inserts it into the report storage structures.
  • BEFORE_REPORT_TRIGGER — Pre-report hook that prepares state and context before the report body is produced.

Tables Accessed

  • POS_SUPP_GENERATE_XML_RPT — Primary storage for generated supplier XML report content.
  • POS_SUPP_GEN_XML_RPT_S — Sequence or secondary table used to assign report identifiers referenced by GET_CURR_SUPP_XML_RPT_ID.
  • POS_TBL_NUMBER — Referenced for numbering or identifier generation.
  • DUAL — Used for single-row evaluations and utility calculations.
  • PLITBLM — Standard PL/SQL table type used to hold in-memory collections during list parsing and CSV conversion.
  • XMLTYPE — Datatype employed for constructing and storing the report's XML payload.

Usage Notes

The package is typically invoked indirectly. A concurrent program or an Oracle Forms event triggers report generation, which calls GENERATE_REPORT_EVENT and the BEFORE_REPORT_TRIGGER hook. Output is persisted through POPULATE_BO_AND_SAVE_CONCUR and GET_BO_AND_INSERT into the POS_SUPP_GENERATE_XML_RPT structures, where it is later retrieved for printing or viewing. Customizations should avoid direct calls where possible because the package is an internal implementation object with no documented public interface and no downstream dependent packages.