Search Results res_time_termnt_k

Overview

OKC_TIME_RES_PUB is the public API package body for time-based resource and task resolution within the Oracle E-Business Suite Contracts (OKC) module. It belongs to the ETRM (Enterprise Contracts) family of APIs and is owned by the APPS schema, carrying a "PUB" classification that designates it as the externally callable wrapper layer for the corresponding private package OKC_TIME_RES_PVT. The package exposes a standardized, uniform API interface built on the OKC_API activity framework, providing message-list initialization, return status propagation, and consistent error handling for consumers that need to resolve, create, or terminate time and resource records relative to contract headers and contract lines. The user search term "create_res_time_n_tasks" corresponds directly to the documented procedure CREATE_RES_TIME_N_TASKS, one of the primary entry points in this package.

Key Procedures and Functions

The documented package exposes eight procedures, all of which follow the OKC_API wrapper convention by delegating core processing to OKC_TIME_RES_PVT. Their purposes are:

• RES_TIME_EVENTS — Triggers resolution of time-based events for a specified contract, driven by contract header, contract line, and a reference date supplied by the caller.
• RES_TIME_NEW_K — Performs resolution logic when a new contract header is created, ensuring that time and resource rules are applied at contract inception.
• RES_TIME_EXTND_K — Applies resolution behavior when a contract is extended, carrying forward or regenerating time/resource entries for the extended term.
• RES_TIME_TERMNT_K — Handles resolution activity when a contract is terminated, cleaning up or closing out associated time and resource records.
• CHECK_RES_TIME_N_TASKS — Validates the relationship between resources, time entries, and tasks without committing changes.
• DELETE_RES_TIME_N_TASKS — Removes existing associations between time records and tasks.
• CREATE_RES_TIME_N_TASKS — Creates new time-and-task associations; this is the procedure referenced by the user's search.
• BATCH_RESOLVE_TIME_N_TASKS — Executes time-and-task resolution in bulk or batch mode, suitable for concurrent processing across many contracts.

Tables Accessed

The ETRM metadata does not enumerate the specific base tables touched by this package; it references them indirectly through APPS synonyms. Based on the OKC naming conventions and the package's functional scope, processing flows through underlying OKC contracts tables such as OKC_K_HEADERS (contract headers) and OKC_K_LINES (contract lines), with time-and-task associations typically stored in supporting detail tables referenced via private-layer logic in OKC_TIME_RES_PVT. All DML is performed in the private package; the public wrappers read profile options (FND_PROFILE) for debug tracing and otherwise act as orchestration only.

Usage Notes

OKC_TIME_RES_PUB is typically invoked from Oracle Forms-based Contracts UI actions, contract lifecycle concurrent programs, and custom PL/SQL integrations. Because every callable is a thin wrapper, callers must supply a valid API version and message-list initialization flag and rely on OKC_API.START_ACTIVITY and OKC_API.END_ACTIVITY to manage the PL/SQL message stack. Error states are surfaced through G_RET_STS_ERROR and G_RET_STS_UNEXP_ERROR exceptions raised into the caller's session. The package is referenced by four other packages, indicating that downstream OKC functionality depends on its lifecycle hooks (new, extend, terminate) firing consistently. In both 12.1.1 and 12.2.2, AFLOG_ENABLED controls diagnostic logging, and BATCH_RESOLVE_TIME_N_TASKS is the preferred entry point when invoking resolution outside of single-contract UI flows.