Search Results is_si_delete_ok

Overview

PA_CI_SUPPLIER_UTILS is a PL/SQL utility package in the APPS schema that supports the Control Items feature set within Oracle Projects. Control Items are user-defined categories used to group and track supplier-related cost information — typically costs tied to purchase orders and project resource assignments — for analysis and reporting against a project. The package encapsulates the reusable logic required to validate, insert, merge, delete, and cost-out supplier control item records, so that higher-level Control Items APIs do not need to duplicate this processing.

The package is classified as an "OTHER" API rather than a public, fully supported interface. It is an internal utility layered beneath PA_CONTROL_ITEMS_PVT and PA_CI_IMPACTS_UTIL, and it is also referenced by itself for internal recursion, indicating that several of its routines share common validation and cost helpers. Its ETRM status is VALID in both 12.1.1 and 12.2.2, and it depends on the standard FND_API error-handling framework as well as on PL/SQL table types defined in the PA schema.

Key Procedures and Functions

ETRM documents fifteen procedures and functions. The main groups are:

• Validation and insertion: VALIDATE_SI_RECORD, VALIDATE_INSERT_SI, and VALIDATESI perform record-level checks on a supplier control item, confirm it may be inserted, and drive the insertion path. IS_SI_DELETE_OK determines whether a supplier control item is eligible for removal.
• Maintenance: MERGE_SUPPLIERS consolidates duplicate supplier control item entries; DELETESIRECORD removes a supplier control item record; DELETE_SUPPLIER_COSTS and DELETE_IMPACT remove associated cost and impact rows.
• Cost calculation: GET_TOTAL_COST aggregates the total cost for a control item or supplier record; GET_FORMATED_AMOUNT returns a display-ready formatted amount; SAVE_SUPPLIER_COSTS persists computed supplier cost lines.
• Identifier and lookup helpers: GET_RESOURCE_LIST_ID and GET_ORIGINAL_CI_ID resolve the resource list identifier and the originating control item identifier used as keys in downstream processing.
• Diagnostics: PRINT_MSG emits diagnostic or error messages, typically through the FND_API message stack.

Parameter signatures are not exposed in the ETRM extract and should be confirmed directly in the package specification before invocation.

Tables Accessed

The package works primarily against the Control Items and supplier cost tables:

• PA_CI_SUPPLIER_DETAILS and PA_CI_SUPPLIER_DETAILS_S — the supplier detail record and its audit/shadow table, which are the primary targets of insert, merge, and delete operations.
• PA_CI_DIRECT_COST_DETAILS and PA_CI_IMPACTS — direct cost lines and their project impact records, used in cost aggregation and in DELETE_IMPACT.
• PA_CONTROL_ITEMS and PA_CI_TYPES_B — the control item header and its type definition, used to resolve GET_ORIGINAL_CI_ID and validate classification.
• PA_RESOURCE_ASSIGNMENTS and PA_RESOURCE_ASGN_CURR — assignment and assignment-currency data used for GET_RESOURCE_LIST_ID and cost derivation.
• PO_HEADERS_ALL and PO_LINES_ALL — purchasing documents supplying supplier and amount information.
• PA_BUDGET_VERSIONS and PA_PROJ_FP_OPTIONS — budget version and forecasting options used to determine valid costing context.
• FND_CURRENCIES — currency validation and formatting for GET_FORMATED_AMOUNT.

Usage Notes

PA_CI_SUPPLIER_UTILS is not intended for direct custom invocation. It is normally called by PA_CONTROL_ITEMS_PVT, by PA_CI_IMPACTS_UTIL, and internally by itself. In Oracle EBS 12.1.1 and 12.2.2, this call path is reached through Control Items forms and related concurrent processing, where supplier control item costs are entered, adjusted, or transferred. Custom code should prefer the public Control Items API or the forms-based path; any direct call must supply the PA_VARCHAR2_150_TBL_TYPE, PA_VARCHAR2_30_TBL_TYPE, PA_NUM_TBL_TYPE, and PA_DATE_TBL_TYPE collections and handle FND_API error codes.