Results for “c_description”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The APPS.AHL_VWP_DEPT_SHIFTS_PUB package is a public PL/SQL API within the Oracle E-Business Suite Discrete Manufacturing and Enterprise Asset Management (eAM) modules. It serves as the programmatic interface for maintaining department shift definitions used in the Visualization Workbench (VWP) scheduling engine. The package manipulates records that associate a department with a calendar, a bill of materials workday pattern, a shift number, and a sequence definition. This data is central to capacity planning and scheduling, because department shifts define the exact working windows — including start time, end time, and duration — against which production and maintenance activities are scheduled.
The package is declared with AUTHID CURRENT_USER and exposes a record type, VWP_DEPTSHIFT_REC, which carries the full set of attributes for a department shift row. That record includes the department shift identifier, organization and department identifiers, a calendar code, a workday pattern identifier, shift number, sequence number and name, the standard WHO audit columns, fifteen descriptive flexfield attribute columns, and a DML operation indicator. The presence of the DML_OPERATION field, defaulted to 'N', confirms that the record type is designed to support insert and delete operations within a single interface.
Key Procedures and Functions
- CREATE_VWP_DEPT_SHIFTS — Inserts or maintains a department shift definition in the Visualization Workbench. It accepts the standard Oracle API parameters (API version, initialization of the message list, commit flag, validation level, default handling, and module type), returns the standard return status and message count/data outputs, and takes the VWP_DEPTSHIFT_REC record as an IN OUT NOCOPY parameter so the caller receives the processed record back. Calling applications use this procedure to define the shift sequence for a department's workday pattern.
- DELETE_VWP_DEPT_SHIFTS — Removes a department shift definition. It mirrors the parameter profile and record-based interface of the create procedure, ensuring a consistent calling convention across the package. Deletion is typically performed when a department is reorganized, a calendar is replaced, or a shift pattern is retired.
Both procedures follow the Oracle Application Object Library API standard, publishing transaction outcomes through x_return_status, x_msg_count, and x_msg_data, and honoring the p_init_msg_list, p_commit, and p_validation_level conventions so that callers may control error handling and transaction boundaries.
Tables Accessed
- AHL_DEPARTMENT_SHIFTS and AHL_DEPARTMENT_SHIFTS_S — the base and translated (or secondary) tables that store the department shift records maintained by these APIs.
- BOM_CALENDARS — supplies the calendar code and description associated with each shift definition.
- BOM_SHIFT_TIMES — provides the actual shift timing windows, including the shift duration. This table is the source of the specific shift timing values a user references when searching for a shift of a given length, such as an eleven-hour shift.
- BOM_WORKDAY_PATTERNS — defines the workday pattern to which the shift belongs, linking the shift to the manufacturing calendar structure.
- HR_ALL_ORGANIZATION_UNITS — resolves the organization and department names against which the shift is defined.
Usage Notes
This package is typically invoked from the Oracle eAM/Manufacturing department shift setup forms, from concurrent programs that load or copy shift calendars between organizations, and from custom PL/SQL extensions that automate shift maintenance during implementations or data migrations. Because it is classified as a public (PUB) API, it is the supported entry point for such customization, and direct DML against AHL_DEPARTMENT_SHIFTS should be avoided. Callers must populate the VWP_DEPTSHIFT_REC structure, including the calendar, workday pattern, shift number, and sequence fields, and must interpret the returned status before committing. When a user is searching for a specific shift length — for example an eleven-hour shift timing — the answer resides in the BOM_SHIFT_TIMES rows referenced through the calendar and shift number stored by these APIs.
-
APPS.ORACLEON SQL Statements 12.1.1
-
APPS.ORACLEON SQL Statements 12.2.2
-
PACKAGE BODY: APPS.ORACLEON 12.2.2
-
PACKAGE: APPS.ORACLEON 12.1.1
-
PACKAGE: APPS.ORACLEON 12.2.2
-
PACKAGE BODY: APPS.ORACLEON 12.1.1