Search Results g_rep_con_status_terminated




Overview
Explore in AI Chat

Overview

The APPS.OKC_REP_STATUS_UPDATE_PVT package body is a private (PVT-classified) PL/SQL module within the Oracle E-Business Suite Contracts (OKC) application, specifically serving the repository/contracts reporting subsystem. Its principal business function is to automate the maintenance of contract lifecycle status. As documented, the package updates the status of contracts that have reached their termination date, transitioning repository contract records to the appropriate lifecycle state. Constants declared in the package body establish the internal mechanics for this process, including the contract status codes G_REP_CON_STATUS_SIGNED ('SIGNED') and G_REP_CON_STATUS_TERMINATED ('TERMINATED'), which drive the state transitions handled by the package. A party-type constant, G_PARTY_TYPE_INTERNAL ('INTERNAL_ORG'), and standard error-handling tokens (G_UNEXPECTED_ERROR, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN) are also defined, indicating that the package follows Oracle's standard API error-handling and message-stack conventions.

Key Procedures and Functions

  • CONTRACT_STATUS_UPDATER — The private worker routine that performs the actual status update for contracts reaching their termination date. Per the inline source comments, it is typed as a private API with the function "Updates status for contracts reaching their termination date." Its comment block documents a standard EBS API signature pattern using p_api_version, p_init_msg_list, and p_status as input parameters, with x_return_status, x_msg_count, and x_msg_data as output parameters. It returns no value; status is reported through the standard return-status convention.
  • CONTRACT_STATUS_UPDATE_MANAGER — The documented coordinating routine that drives the status-update process, typically invoking the worker routine and managing control flow, error handling, and message propagation across the set of qualifying contracts.

Tables Accessed

  • OKC_REP_CONTRACTS_ALL — The primary repository contract table holding the contract header records whose lifecycle status is evaluated and updated.
  • OKC_REP_CONTRACT_VERS — The contract version table, referenced to align status changes with the relevant contract version records and to support version-aware status maintenance.
  • PLITBLM — The PL/SQL message-table used by the EBS message dictionary for storing and retrieving error and diagnostic messages via the standard message-handling API.

Usage Notes

Because this package is classified as PVT (private), it is not a published public API and is not intended for direct invocation by customer extensions. It is normally called internally by the OKC repository contract status-update logic, most likely in conjunction with the concurrent program referenced in the source header identifier OKCVREPSTATCHB. Typical invocation patterns include a concurrent program that periodically scans for contracts reaching their termination date and calls the status-update manager to process them in batch.

Regarding the search term g_app_name: this is a package-level constant (here defined as 'OKC', the application short name) used in the standard EBS error-message routine FND_MSG_PUB.Add to attribute messages to the correct application. Its presence reflects adherence to Oracle's documented error-handling standard, in which G_APP_NAME, the package name constant, and the module constant are passed to the message API so that errors are logged and retrieved using FND_MSG_PUB routines. Note that the value shown in the excerpt is the literal OKC, while the adjacent module constant references the search package name, a common copy-edit artifact in the source header. Custom code should not depend on this private package; any requirement to extend contract status automation should instead target supported public OKC APIs.