Search Results mass_update_status_prc

Overview

OKS_MASS_UPD_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that supports Service Contracts mass update processing in Oracle E-Business Suite. It belongs to the Oracle Service (OKS) module and is designed to apply bulk changes to large populations of service contracts, contract lines, and sublines without requiring users to modify each contract individually. The package encapsulates validation logic, temporary table population, cascade selection, concurrent program submission, and the actual update procedures that change price, status, and effectivity values. Because it is classified as a private package, it is not intended as a public integration API; it is invoked internally by the Service Contracts mass update user interface and concurrent processing framework. It appears in both 12.1.1 and 12.2.2 environments with VALID status, and it is not referenced by any other package, confirming its role as a top-level internal driver for the mass update feature rather than a shared library.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions:

• DELETE_CONTRACT_DATA, DELETE_CHANGES — remove temporary or staged mass update data.
• LAUNCH_MASSUPD_CONC_PROG — submit the mass update concurrent program to run in the background.
• POPULATE_TEMP_TBL — load the candidate contracts, lines, and sublines into the temporary staging tables.
• VLD_MASSUPD_DATA_PRC, VLD_MASSUPD_STATUS_PRC, VLD_MASSUPD_EFF_PRC — validation routines for data, status, and effectivity changes respectively.
• MASS_UPDATE_PRICE_PRC, MASS_UPDATE_STATUS_PRC, MASS_UPDATE_EFFECTIVITY_PRC — the core processing procedures that apply price, status, and date effectivity updates.
• MASS_UPDATE_PRICE_WRAPPER, MASS_UPDATE_STATUS_WRAPPER, MASS_UPDATE_EFF_WRAPPER — wrapper entry points that orchestrate validation and processing for each change type.
• MASS_UPDATE_CASCADE_SEL — determine cascade selections when changes must propagate to child lines.
• MASS_UPDATE_SUBMIT — submit the mass update transaction for execution.
• OKS_MODEL_CHECK, OKS_CONFIG_CHECK, OKS_CONFIG_ITEM_CHECK, OKS_MODEL_ITEM_CHECK — structural checks on models, configurations, and their items, ensuring that mass updates respect configured product relationships.

Tables Accessed

The package reads and writes the staging tables OKS_HEADERS_TEMP, OKS_LINES_TEMP, and OKS_SUBLINES_TEMP during preparation and execution. Contract data is drawn from OKC_K_HEADERS_ALL_B, OKC_K_ITEMS, OKC_K_LINES_B, OKS_K_HEADERS_B, OKS_K_LINES_B, and OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES for billing-related lines. Lookups and reference data come from OKC_STATUSES_B, CSI_SYSTEMS_TL, FND_CURRENCIES, HZ_CUST_ACCOUNTS, and HZ_PARTIES. These tables supply the contract, status, currency, customer, and installed base context required for validation and update.

Usage Notes

OKS_MASS_UPD_PVT is normally invoked through the Service Contracts mass update form or the associated concurrent program, not directly by developers. Because the API classification is PVT, Oracle does not guarantee its interface for external callers. Custom code that needs to invoke mass update behavior should call the supported public APIs or the mass update user interface; direct calls to this package's procedures risk breakage during upgrades. The LAUNCH_MASSUPD_CONC_PROG and MASS_UPDATE_SUBMIT routines are the typical entry points when the operation is run concurrently. Performance is influenced by the volume of contracts staged in OKS_HEADERS_TEMP, OKS_LINES_TEMP, and OKS_SUBLINES_TEMP, so large batches should be scheduled during low-activity periods.