Search Results pm_schedules

Overview

OKS_PM_PROGRAMS_PVT is the private implementation package for Preventive Maintenance (PM) program processing within Oracle E-Business Suite Service Contracts (OKS). It provides the core scheduling engine that derives, adjusts, renews, and validates maintenance visit schedules generated from a PM program definition. The package operates against the PM program line structure held in OKS_K_LINES_B and its activities and schedules in OKS_PM_ACTIVITIES and OKS_PM_SCHEDULES, producing dated visit records through the OKS_PM_SCHEDULES and OKS_PM_SCHEDULES_H tables. It is declared as an API classification of PVT (private), meaning it is not a public API: external callers are expected to reach it indirectly through its public wrapper package, OKS_PM_PROGRAMS_PUB or its equivalents. The header revision indicates the file has been maintained across releases and is present in both 12.1.1 and 12.2.2 at the APPS schema level.

Key Procedures and Functions

• GENERATE_SCHEDULE — The central scheduling routine. It accepts an API version, message-list initialization flag, optional period count, start date, end date, interval duration, period type, and a first schedule date, and returns period count, last date, and a PL/SQL table of schedule rows. It seeds the schedule at the first schedule date and iterates forward using OKC_TIME_UTIL_PUB.GET_ENDDATE until the end date is reached.
• POPULATE_SCHEDULE — Materializes computed schedule rows into the PM schedule tables.
• RENEW_PM_PROGRAM_SCHEDULE — Extends an existing PM program schedule into a further period.
• ADJUST_PM_PROGRAM_SCHEDULE — Recalculates schedule rows when program parameters change.
• REFRESH_PM_PROGRAM_SCHEDULE — Rebuilds the schedule from current program rules and activities.
• UPDATE_PMP_RULE_ID — Maintains the link between PM program lines and their governing OKC rules.
• MIGRATE_TO_PROGRAM and MIGRATE_TO_ACTIVITIES — Convert historical or legacy structures into the current program/activity model.
• CHECK_PM_MATCH, CHECK_PM_SCHEDULE, CHECK_PM_PROGRAM_EFFECTIVITY, CHECK_PM_REQUIRED_VALUES, CHECK_PM_NEW_ACTIVITIES — Validation routines that verify date alignment, required columns, effectivity, and activity consistency before a program or schedule is committed.
• UNDO_PM_LINE, INIT_OKS_K_LINE, VERSION_PM, RESTORE_PM, DELETE_PMHISTORY, DELETE_PMSAVED_VERSION, COPY_PM_TEMPLATE — Lifecycle operations covering line initialization, versioning, restore, history cleanup, and template copying.

Tables Accessed

The package reads and writes OKS_PM_SCHEDULES and its history twin OKS_PM_SCHEDULES_H for generated visit dates, and OKS_PM_ACTIVITIES / OKS_PM_ACTIVITIES_H for the tasks that populate each schedule. OKS_K_LINES_B and OKS_K_LINES_B (via the OKS_K_LINES_B synonym) hold the PM program line header, while OKC_RULES_B, OKC_CLASS_OPERATIONS, OKC_OPERATION_INSTANCES, OKC_OPERATION_LINES, and OKC_SUBCLASSES_B provide the rule and operation metadata used to derive schedules. OKS_PM_STREAM_LEVELS and its history table supply stream-level configuration. AHL_MR_HEADERS_B participates in maintenance program header resolution, and PLITBLM is used for the PL/SQL index-by table type declared in the schedule APIs.

Usage Notes

Because OKS_PM_PROGRAMS_PVT is a private package, it is not intended for direct invocation by customers. It is called by the Service Contracts PM program concurrent programs, the Service Contracts authoring forms, and by the public OKS_PM_PROGRAMS_PUB package, which wraps it with standard OKC_API message handling. Twelve other packages reference it, indicating its role as the shared scheduling backend. In the context of a search for "pm_schedules," this package is the layer that actually inserts and updates rows in OKS_PM_SCHEDULES; sites tracing unexpected or missing PM schedule dates should confirm the program's effectivity dates and rule definitions before inspecting the schedule rows themselves, since CHECK_PM_EFFECTIVITY and CHECK_PM_SCHEDULE will reject or skip generation for programs outside their effective window. Custom extensions should call OKS_PM_PROGRAMS_PUB rather than this private body in both 12.1.1 and 12.2.2.