Results for “delete_work_data”

10 results




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

Overview

GR_EURO_CLASSIFICATION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER API. It belongs to the Oracle Process Manufacturing / Oracle Quality family of modules concerned with regulatory compliance for hazardous materials, specifically supporting the classification of items against European hazard and risk regulations. In the context of Oracle EBS 12.1.1 and 12.2.2, the package encapsulates the business logic required to determine an item's hazard classification, to associate the appropriate risk and safety phrases, and to persist those results into the applicable GR (Global Regulatory) tables.

The package is declared with AUTHID CURRENT_USER and carries header version information (115.2, dated 2002/10/30) that predates the 12.x releases, indicating it is a legacy component that has been carried forward largely unchanged. The source reveals extensive use of global variables for item, ingredient, label, property, product class, session, and user context, together with PL/SQL record and index-by-table types used to consolidate safety phrases, risk phrases, and intermediate calculations. These structures support the aggregation of concentration data for ingredient-driven classification.

Key Procedures and Functions

The documented package interface exposes six procedures and functions, all serving the hazard classification workflow:

  • CLASSIFY_HAZARD — The core routine that evaluates an item's composition and properties to determine its European hazard classification.
  • ASSIGN_RISK_PHRASES — Associates the applicable risk phrases with a classified item.
  • ASSIGN_SAFETY_PHRASES — Associates the applicable safety phrases with a classified item.
  • UPDATE_HAZARD_CLASSIFICATIONS — Persists or refreshes hazard classification results for affected items.
  • DELETE_WORK_DATA — Removes transient working data generated during a classification run, cleaning the GR_WORK_* staging tables.
  • ITEM_MATCHES_CATEGORY_VALUE — Evaluates whether an item matches a given category value, used in classification rules.

Tables Accessed

The package reads and writes a defined set of GR tables via APPS synonyms. Base and definition tables include GR_EUROHAZARDS_B, GR_ITEM_GENERAL, GR_ITEM_CONCENTRATIONS, GR_ITEM_PROPERTIES, GR_LABELS_B, GR_PRODUCT_CLASSES, GR_RISK_PHRASES_B, and GR_ITEM_RISK_PHRASES, which supply item, ingredient, label, and phrase reference data. Classification and calculation results are stored in GR_ITEM_CLASSNS, GR_RISK_CALCULATIONS, and GR_WORK_CLASSNS. Staging and intermediate results are held in GR_WORK_SAFETY_PHRASES, while DUAL is used for simple singleton queries. These tables collectively support the read of item composition and the write of computed hazard classification and phrase assignments.

Usage Notes

GR_EURO_CLASSIFICATION is typically invoked from the Global Regulatory/Environmental Health and Safety forms or from concurrent programs that perform bulk hazard reclassification across item populations. The reference to concurrent request return values (G_PRINT_STATUS, G_CONCURRENT_ID) indicates it can operate in a concurrent processing context. Because the package is referenced by zero other packages, it functions as an entry point rather than a shared library, so custom code may call it directly. Developers should note the AUTHID CURRENT_USER declaration, meaning privilege checking follows the invoking user, and the legacy status of the source, which warrants thorough regression testing when extending or invoking it in 12.1.1 or 12.2.2 environments.