Search Results create_reservation

Overview

APPS.AHL_RSV_RESERVATIONS_PVT_W is a private PL/SQL wrapper package within the Oracle E-Business Suite Advanced Supply Chain and Depot Repair product family, specifically serving the Oracle Advanced Service (AHL) reservation subsystem. The package acts as a thin PL/SQL-to-Java or PL/SQL-to-DI (database integration) bridge that exposes reservation creation logic through a weakly typed, internet-accessible signature. Its name suffix "_PVT_W" denotes a private, generated wrapper whose public counterpart is invoked from forms, OAF pages, or Web ADI integrations in EBS 12.1.1 and 12.2.2.

The package is characteristic of Oracle's "Rosetta" pattern, in which a strongly typed PL/SQL record type (such as ahl_rsv_reservations_pvt.serial_number_tbl_type) is marshalled to and from generic JTF typed tables for transport across the BPEL/Java stack. This allows the depot repair or field service reservation logic to be consumed by non-PL/SQL clients without exposing the underlying record structures directly.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P2 — Converts a pair of generic JTF typed tables (a numeric table and a VARCHAR2(100) table) into the strongly typed serial_number_tbl_type used internally by the reservations private package. It is an inbound data-marshalling helper, invoked before the core reservation routine executes.
• ROSETTA_TABLE_COPY_OUT_P2 — Performs the inverse transformation, exporting the internal serial number collection back into the generic JTF typed tables so results can be returned to external callers.
• CREATE_RESERVATION — The functional entry point. It carries the standard EBS API contract parameters (p_api_version, p_init_msg_list, p_commit, p_validation_level, p_module_type, and the x_return_status / x_msg_count / x_msg_data out parameters) plus p_scheduled_material_id and the pair of typed tables representing serial-number attributes. Its purpose is to create a material reservation against a scheduled material line in depot repair, accepting optional serial number detail through the array parameters.

Tables Accessed

The ETRM metadata records a single referenced table, PLITBLM, accessed through an APPS synonym. PLITBLM is a standard Oracle Applications temporary/work table often used as a staging area for numeric or character arrays. Its presence here is consistent with the table-copy helper procedures, which rely on bulk SQL operations rather than row-by-row loops. The primary reservation tables populated by CREATE_RESERVATION (the AHL_RSV_RESERVATIONS base table and its associated serial number child table) are accessed indirectly through the underlying non-wrapper package ahl_rsv_reservations_pvt, which this wrapper delegates to.

Usage Notes

Because this package is classified as OTHER and exposes an internet-style signature, it is typically invoked from the Depot Repair or Service Request forms layer, from OAF-based reservation pages, or from integration points such as BPEL process flows that create reservations programmatically. Custom code should generally call the public ahl_rsv_reservations_pvt package rather than this generated wrapper, reserving AHL_RSV_RESERVATIONS_PVT_W for cases that require the flattened JTF table signature.

When invoking CREATE_RESERVATION, the standard EBS API discipline applies: pass a valid p_api_version, set p_init_msg_list and p_commit in accordance with transaction requirements, and always inspect x_return_status before committing. The serial number arrays must be populated through the Rosetta copy-in helper rather than constructed manually to ensure type compatibility across EBS 12.1.1 and 12.2.2.