Search Results get_reset_counters

Overview

APPS.AHL_COMPLETIONS_PVT_W is the public wrapper package for the Oracle E-Business Suite Depot Repair (AHL) completions private API, APPS.AHL_COMPLETIONS_PVT. It executes with AUTHID CURRENT_USER and is classified under ETRM as an OTHER API object belonging to the APPS schema. The package exposes the transactional business logic used to complete maintenance and repair work orders, sign off maintenance requirements, close visit records, calculate operation actual dates, and manage reset counters associated with completion processing.

The "_W" suffix denotes a wrapper layer generated to bridge PL/SQL record types and the JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, and JTF_DATE_TABLE collection types used by Oracle's Rosetta-style integration infrastructure. This indirection allows callers such as forms, Java/JTT layers, and concurrent programs to pass and receive tabular data without directly binding to the internal workorder_tbl_type record structure declared in AHL_COMPLETIONS_PVT.

Key Procedures and Functions

The package documents twenty-two procedures and functions. The bulk are Rosetta conversion utilities that copy data between the internal workorder_tbl_type record type and JTF scalar arrays. They include ROSETTA_TABLE_COPY_IN_P1, ROSETTA_TABLE_COPY_OUT_P1, ROSETTA_TABLE_COPY_IN_P3, ROSETTA_TABLE_COPY_OUT_P3, ROSETTA_TABLE_COPY_IN_P7, ROSETTA_TABLE_COPY_OUT_P7, ROSETTA_TABLE_COPY_IN_P9, ROSETTA_TABLE_COPY_OUT_P9, ROSETTA_TABLE_COPY_IN_P10, ROSETTA_TABLE_COPY_OUT_P10, ROSETTA_TABLE_COPY_IN_P18, and ROSETTA_TABLE_COPY_OUT_P18. The _P1 pair, for example, maps twenty-four positional parameters spanning numeric, varchar2, and date arrays.

The functional procedures are COMPLETE_MR_INSTANCE, which drives completion of a maintenance requirement instance; SIGNOFF_MR_INSTANCE, which records sign-off against a maintenance requirement; CLOSE_VISIT, which finalizes a service visit; GET_DEFAULT_OP_ACTUAL_DATES and GET_OP_ACTUAL_DATES, which derive default and actual operation dates; IS_SIGNOFF_DATE_OVERLAPPING, which validates sign-off date ranges; and GET_RESET_COUNTERS and RESET_COUNTERS, which retrieve and reset the counters used during completion processing. The reset-count logic is the object associated with the "reset_counters" search term.

Tables Accessed

The documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is a generic PL/SQL table storage table used by the Rosetta conversion routines to stage index-by table data during bulk copy-in and copy-out operations. Functional procedures operate primarily on maintenance requirement, work order, and visit structures passed through the workorder_tbl_type parameter, with underlying base tables (such as AHL_MR_INSTANCES and associated visit and operation tables) manipulated by the private package rather than directly by this wrapper.

Usage Notes

AHL_COMPLETIONS_PVT_W is invoked from Depot Repair forms and from integration or concurrent processing that must complete repair work orders in bulk. The wrapper is not referenced by any other documented package, indicating it is a top-level entry point rather than an internal dependency. Custom code should call the wrapper procedures rather than the private API, populating the JTF_*_TABLE arrays and relying on the Rosetta copy routines to transfer data into workorder_tbl_type. Because the procedures include reset-counter and sign-off-date validation logic, callers should prepare actual date and counter values correctly before invocation, as IS_SIGNOFF_DATE_OVERLAPPING enforces date integrity and RESET_COUNTERS alters counter state during completion.