Search Results get_posref_by_path




Overview
Explore in AI Chat

Overview

The APPS.AHL_MC_PATH_POSITION_PVT_W package is a private PL/SQL wrapper belonging to the Oracle E-Business Suite Product Lifecycle Management (PLM) family of modules, specifically the Oracle Manufacturing Execution System (MES) for Discrete Manufacturing area covered by the AHL schema. The AHL product line manages routing, shop-floor transactions, and process configuration. Within that context, the path position concept refers to the logical ordering of operations or nodes along a manufacturing routing path — that is, the sequence-position coordinates that define where a given operation sits relative to others on the shop floor.

This package serves as the interface layer between the AHL path-position business entity and the Oracle Application Framework (OAF) / BC4J middle-tier plumbing. The "_W" suffix and the presence of rosetta_table_copy_in_p1 and rosetta_table_copy_out_p1 indicate it is a member of the Oracle "Rosetta" generated-wrapper family used to marshal PL/SQL-record collections into and out of Java-layer table types (JTF_NUMBER_TABLE, JTF_DATE_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_200). This enables the PL/SQL record type ahl_mc_path_position_pvt.path_position_tbl_type to be passed efficiently across the JDBC boundary.

Key Procedures and Functions

  • ROSETTA_TABLE_COPY_IN_P1 — Converts Java-side scalar arrays (numbers, dates, and various-length VARCHAR2 tables) into a single nested PL/SQL table of type path_position_tbl_type. This is the inbound marshalling routine invoked when a client passes a collection of path-position records into the database.
  • ROSETTA_TABLE_COPY_OUT_P1 — The inverse operation: explodes a path_position_tbl_type collection back into the individual positional scalar array parameters that the Java middle tier expects as output.
  • CREATE_POSITION_ID — Generates or assigns the unique identifier for a path-position record. This underpins primary-key assignment when new routing-path position rows are created.
  • GET_POSREF_BY_PATH — The routine matching the user's search term. It retrieves the position reference (posref) associated with a supplied path. This is the core lookup used to map a routing path to its positional reference values.
  • CHECK_POS_REF_PATH — Validation routine confirming that a given position reference is compatible with, or valid for, a given path. Used to enforce integrity before persisting path-position relationships.
  • ENCODE — A utility routine for encoding path-position values, typically producing a canonical representation of position coordinates or references.

Tables Accessed

The documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is the standard EBS "PL/SQL Interface Table for BLOB/CLOB/LOB Messaging" used by the Rosetta wrapper infrastructure to stage large or bulk data during the copy-in/copy-out conversion process. No direct business tables are documented as being touched by this wrapper — the actual persistence of path-position rows occurs in the underlying AHL_MC_PATH_POSITION base table via the non-wrapper package AHL_MC_PATH_POSITION_PVT, which this "_W" package delegates to.

Usage Notes

This package is not intended for direct invocation by end users or by custom concurrent programs. It is a generated wrapper invoked by OAF/BC4J pages that display or maintain routing path positions within the MES/PLM HTML UI, and by any middle-tier Java code performing bulk path-position operations. Developers extending the MES routing-configuration screens may reference GET_POSREF_BY_PATH as a public-facing anchor but should call the base AHL_MC_PATH_POSITION_PVT package directly for PL/SQL-native logic. Because the ETRM metadata records zero dependent packages, the wrapper is effectively a leaf node in the call graph. In both 12.1.1 and 12.2.2 the object is functionally identical; the version header lineage (120.1, dated 2008) confirms that no release-specific change affects its behaviour.