Search Results get_num_languages

Overview

PO_R12_CAT_UPG_UTL is a utility package in the Oracle E-Business Suite Procurement module (APPS schema) that supports the R12 catalog upgrade and procurement data migration process. Its primary role is to provide shared helper logic for the interface staging tables that receive requisition, purchase order, and catalog content during upgrade and inbound processing. The package centralizes routine operations such as error logging, rejection of invalid interface rows, and generation of array structures used for bulk processing of interface identifiers.

The package version header indicates a last modification date of 2006, consistent with the R12 upgrade release stream that applies to both 12.1.1 and 12.2.2. It operates alongside the companion type definition package PO_R12_CAT_UPG_TYPES, which supplies the PO_TBL_NUMBER collection type referenced throughout.

Key Procedures and Functions

• ADD_FATAL_ERROR — Records a fatal error against one or more interface rows. It accepts identifiers for the header, line, line location, distribution, price differential, and attribute value interface rows, and supports an error message name along with table, column, and token substitution values used to build a formatted error message.
• REJECT_HEADERS_INTF — Marks a set of header interface rows as rejected, using an identifier parameter type and a table of numbers, and honors a cascade indicator to propagate rejection to dependent rows.
• REJECT_LINES_INTF — Performs the equivalent rejection for line interface rows, again supporting cascading to dependent records.
• REJECT_ATTR_VALUES_INTF — Rejects rows in the attribute values interface staging table.
• REJECT_ATTR_VALUES_TLP_INTF — Rejects rows in the attribute values TLP interface staging table.
• CONSTRUCT_SUBSCRIPT_ARRAY — Returns a PO_R12_CAT_UPG array of the requested size. This is the object for which the query "construct_subscript_array" was issued. Its purpose is to allocate and return a subscripted collection used for bulk operations across interface identifiers. It is a function, not a procedure, and is documented by name only in the metadata.
• ASSIGN_PROCESSING_ID — Allocates and assigns a processing identifier used to group related interface rows for a given run.
• INIT_STARTUP_VALUES — Initializes package-level startup values used by the utility routines.
• GET_BASE_LANG — Retrieves the base language installed in the environment.
• GET_NUM_LANGUAGES — Returns the number of installed languages.

Tables Accessed

The package reads and writes the core Procurement interface tables, including PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, PO_ATTR_VALUES_INTERFACE, PO_ATTR_VALUES_TLP_INTERFACE, and PO_INTERFACE_ERRORS (with its sequence PO_INTERFACE_ERRORS_S). It references PO_PDOI_PROCESSING_ID_S for processing identifier allocation. System and setup tables read include FINANCIALS_SYSTEM_PARAMS_ALL, PO_SYSTEM_PARAMETERS_ALL, MTL_PARAMETERS, and RCV_PARAMETERS. Language information is drawn from FND_LANGUAGES. DUAL and the PLITBLM synonym are also referenced.

Usage Notes

PO_R12_CAT_UPG_UTL is not intended for direct end-user invocation. It is called by the catalog upgrade programs and by other PL/SQL units during the R12 upgrade and inbound interface processing cycle. The metadata records that it is referenced by three other packages, confirming its role as a shared utility dependency. The CONSTRUCT_SUBSCRIPT_ARRAY function is typically used by caller code to build collections sized to the number of identifiers being processed in a batch, enabling bulk rejection and error assignment. Any custom code reusing this package must supply the PO_R12_CAT_UPG_TYPES collections and observe the same interface table constraints.