Search Results update_requirement_line_post

Overview

APPS.CSP_REQUIREMENT_LINES_IUHK is an internal hook API package body belonging to the Oracle E-Business Suite Customer Relationship Management (CRM) and Supply Chain module family. Its file name, cspirqlb.pls, is invoked alongside CSP_REQUIREMENT_LINES_PKG and serves as the designated extension point for vertical industry customizations. The package provides dedicated pre-processing and post-processing hooks that fire around the three core DML operations performed on requirement lines: insert, update, and delete. Because Oracle EBS was architected to support industry-specific (vertical) extensions without modifying Oracle-owned seeded code, this package exists so that partners and customers can inject custom business logic at well-defined points in the requirement line lifecycle while preserving upgrade safety.

Key Procedures and Functions

The package exposes six documented procedures, organized as three pairs of before/after hooks:

• CREATE_REQUIREMENT_LINE_PRE — Fires before a requirement line record is inserted. Delegates to the internal hook mechanism with the operation code INSERT_ROW and stage indicator 'B' (before).
• CREATE_REQUIREMENT_LINE_POST — Fires after a requirement line insert completes. Uses INSERT_ROW with stage indicator 'A' (after).
• UPDATE_REQUIREMENT_LINE_PRE — Fires before an existing requirement line is updated. Uses UPDATE_ROW and stage 'B'.
• UPDATE_REQUIREMENT_LINE_POST — Fires after a requirement line update. Uses UPDATE_ROW and stage 'A'.
• DELETE_REQUIREMENT_LINE_PRE — Fires before a requirement line is deleted. Uses DELETE_ROW and stage 'B'.
• DELETE_REQUIREMENT_LINE_POST — Fires after a requirement line deletion. Uses DELETE_ROW and stage 'A'.

Each procedure accepts a single out parameter, x_return_status, through which the hook mechanism communicates success or failure back to the caller. Implementation bodies call CSP_SHIP_TO_ADDRESS_PVT.CALL_INTERNAL_HOOK, passing the driving package name CSP_REQUIREMENT_LINES_PKG, the operation constant, the timing flag, and the return status.

Tables Accessed

The ETRM metadata for this package body identifies no direct table references. All physical DML against requirement line data is executed by the driving package, CSP_REQUIREMENT_LINES_PKG, which manipulates the underlying requirement line tables. CSP_REQUIREMENT_LINES_IUHK performs no independent reads or writes; its sole responsibility is dispatching control to registered vertical hook implementations. This separation is deliberate and keeps the extension point lightweight and side-effect free in its default (unregistered) state.

Usage Notes

This package is not intended for direct invocation by end users, Oracle Forms, or concurrent programs. It is called internally by CSP_REQUIREMENT_LINES_PKG at the appropriate point in each DML transaction. The package is referenced by exactly one other package, consistent with this internal dependency pattern. To extend behavior, implementers register their logic through the CSP ship-to-address internal hook framework rather than editing this file. Because the header carries the "noship" designation, the object is a non-shipped internal artifact; customizations placed here may be overwritten during patching. Oracle EBS 12.1.1 and 12.2.2 both preserve this design, and the online patching architecture in 12.2.2 reinforces the importance of using the hook registration mechanism rather than modifying seeded source.