Search Results copy_lines

Overview

OKC_PHI_PVT is a private PL/SQL API package in the Oracle E-Business Suite Order Capture (OKC) module responsible for managing price hold functionality on contracts. A price hold allows a contract or contract line to lock in pricing terms so that subsequent orders or releases reference a fixed, protected price rather than a volatile or re-derived value. The package bridges contract data residing in OKC structures with pricing entities stored in Oracle Advanced Pricing (QP), specifically creating and maintaining Modifiers and Pricing Agreements.

The package name carries the _PVT suffix, indicating that it is classified as a private API intended for internal use by the application rather than as a public, supported integration interface. It is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user. The header comments show it is a long-standing object, with the original source revision dated 2005, and it remains documented through ETRM 12.2.2.

Key Procedures and Functions

The package exposes three documented procedures:

• PROCESS_PRICE_HOLD — The central routine for synchronizing a contract's price hold with Oracle Pricing. It accepts a contract identifier and an operation code (documented as UPDATE or TERMINATE), plus an optional termination date. Per the header commentary, the first call with UPDATE creates a Modifier and Pricing Agreement in QP; a subsequent UPDATE updates the existing Modifier and Pricing Agreement and creates new Modifier lines when new lines are added to the contract; a TERMINATE call de-activates the Modifier and Pricing Agreement in QP. It returns the standard EBS API status and message outputs.
• EXTEND_PRICE_HOLD — Operates at the contract line level, accepting the contract line identifier of a price hold top line. It is invoked when a price hold needs to be extended, propagating the associated pricing definitions accordingly.
• COPY_LINES — Handles the copying of contract lines, which is the routine most relevant to users searching for "copy_lines." When contract lines are duplicated, price hold attributes and their associated QP entities must be replicated so that the copied lines retain valid pricing references.

Tables Accessed

The package reads and writes contract definition data through APPS synonyms, principally:

• OKC_K_LINES_B — Stores contract line definitions; the base table for the line identifiers passed to EXTEND_PRICE_HOLD and COPY_LINES.
• OKC_RULES_B and OKC_RULE_GROUPS_B — Hold contract rules and rule groups that govern pricing behavior attached to the contract; price hold logic is expressed through rules.
• QP_PRICING_ATTRIBUTES — The Oracle Advanced Pricing table used to record pricing attributes for the Modifier and Pricing Agreement created or updated in QP.
• PLITBLM — The PL/SQL interlanguage message table, referenced for message handling within the API's standard return-message framework.

Usage Notes

OKC_PHI_PVT is invoked internally rather than directly by end users. The header states explicitly that PROCESS_PRICE_HOLD is called whenever a contract or contract line is activated, terminated, or cancelled, meaning activation and lifecycle events in the Contracts workbench trigger it automatically. EXTEND_PRICE_HOLD and COPY_LINES follow the same pattern for extension and duplication actions. Because it is a private API, customizations should treat it as subject to change between releases; ETRM notes that it is referenced by two other packages, confirming its role as a shared internal utility. Developers extending price hold behavior should route through the supported public OKC APIs wherever possible.