Search Results delete_operation_lines
Overview
OKS_MASSCHANGE_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Service Contracts (OKS) module, declared with AUTHID CURRENT_USER and owned by the APPS schema. Its business purpose is to support the mass change of service contracts, allowing users to apply attribute changes to many contract headers and lines simultaneously rather than editing contracts one at a time. The package drives the entire mass change lifecycle: identifying eligible contracts, validating and previewing proposed changes, creating mass change request detail records, generating operation instances and operation lines, applying updates, and logging results. Because mass change is a long-running, high-volume process, the package also provides submission and notification logic so that work can be run through concurrent processing and the requesting user informed upon completion. The listed metadata references OKSRMASS.pls, with the header at version 120.2 dated 2007, reflecting the underlying Service Contracts architecture that remains in use across EBS 12.1.1 and 12.2.2.
Key Procedures and Functions
The package exposes 21 documented procedures and functions, reflecting the multi-stage nature of the mass change process.
- GET_ELIGIBLE_CONTRACTS — identifies the set of contracts that qualify for the requested mass change based on the selection criteria.
- PREVIEW_MASSCHANGE — allows a user to preview the effect of the change before it is applied.
- SUBMIT_MASSCHANGE, SUBMIT_CONC, SUBMIT_CONC_FORM, SUBMIT, NOTIFY_COMPLETION — manage submission of the mass change to concurrent processing and notify the user on completion.
- LOCK_CONTRACT_HEADER — obtains a lock on the contract header during processing.
- CREATE_OPERATION_INSTANCES, UPDATE_OPERATION_INSTANCES, DELETE_OPERATION_INSTANCES — create, update, or delete the operation instance records that represent each change to be applied. This is the group the search term create_operation_instances relates to.
- CREATE_OPERATION_LINES, UPDATE_OPERATION_LINES, DELETE_OPERATION_LINES — manage the corresponding operation line records.
- CREATE_MASSCHANGE_LINE_DTLS — persists the mass change line detail records.
- CREATE_MSCHG_CLASS_OPERATION — creates the class operation used to drive the mass change.
- GET_ATTRIBUTE_VALUE — retrieves attribute values needed during processing.
- UPDATE_CONTRACT — applies the change to the contract.
- UPDATE_LINE_STATUS — updates the status of the mass change lines.
- LOG_MESSAGES — records messages and errors for diagnostics and user feedback.
Tables Accessed
The package reads and writes a mix of Service Contracts and shared reference tables:
- OKC_K_HEADERS_B, OKC_K_LINES_B — contract headers and lines, the targets of the mass change.
- OKC_CLASS_OPERATIONS, OKC_CONTACTS, OKC_MASSCHANGE_REQ_DTLS — class operation definitions, contract contacts, and the mass change request detail staging table.
- HZ_PARTIES, HZ_RELATIONSHIPS, HZ_ORG_CONTACTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES_ALL — trading partner, contact, and site information used for eligibility and validation.
- HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION — organization definitions.
- GL_LEDGERS — ledger reference data.
- JTF_RS_RESOURCE_EXTNS — resource/party reference.
- FND_USER — the submitting user, used for notification and audit.
Usage Notes
OKS_MASSCHANGE_PVT is an internal implementation package; the metadata indicates it is referenced by 0 other packages, so it is not part of a published API surface. It is invoked through the Service Contracts mass change user interface and its associated concurrent programs, where SUBMIT_CONC and NOTIFY_COMPLETION handle execution and feedback, and through the preview and submission flows that call the eligible contract, operation instance, and operation line routines. Custom code that needs mass change behavior should invoke the supported Service Contracts public APIs rather than calling this PVT package directly, since its signature and internal logic may change between 12.1.1 and 12.2.2 without an API commitment.