Search Results update_supplier_impact

Overview

APPS.PA_CONTROL_API_PUB is a public PL/SQL API package within the Oracle EBS Projects (PA) module. It provides the programmatic interface for managing project control items and their associated change management activities, including issues, change requests, change orders, and supplier change impacts. The package is defined with AUTHID DEFINER, meaning its procedures execute with the privileges of the APPS schema owner rather than the calling user, which is standard practice for EBS public APIs that must perform DML against protected PA tables.

The package header declares a substantial set of record and table types, including ci_action_in_rec_type, ci_action_out_rec_type, and their corresponding PL/SQL tables, along with supp_det_rec_type for supplier detail changes and rel_item_in_table_type for related item identifiers. Notably, the package defines three sentinel constants inherited from PA_INTERFACE_UTILS_PUB: G_PA_MISS_NUM, G_PA_MISS_DATE, and G_PA_MISS_CHAR. These constants are used as default placeholder values in record type declarations, allowing the API to distinguish between a caller-supplied value and an unset attribute during impact processing.

Key Procedures and Functions

The documented procedures group into several functional areas:

• Impact management: ADD_WORKPLAN_IMPACT, ADD_STAFFING_IMPACT, ADD_CONTRACT_IMPACT, ADD_OTHER_IMPACT, and ADD_SUPPLIER_IMPACT create impact records for a control item, while their UPDATE_ counterparts (UPDATE_WORKPLAN_IMPACT, UPDATE_STAFFING_IMPACT, UPDATE_CONTRACT_IMPACT, UPDATE_OTHER_IMPACT, UPDATE_SUPPLIER_IMPACT) modify existing impact records. DELETE_SUPPLIER_IMPACT_DETAILS removes supplier impact detail rows.
• Progress tracking: UPDATE_PROGRESS records progress against a control item.
• Control item creation: CREATE_ISSUE, CREATE_CHANGE_REQUEST, and CREATE_CHANGE_ORDER instantiate the respective control item types, driving records into PA_CONTROL_ITEMS.
• Action management: CREATE_ACTION, TAKE_ACTION, and CANCEL_ACTION manage the workflow-linked actions associated with control items, including assignment, sign-off, and closure.
• Deletion: DELETE_ISSUE and DELETE_CHANGE_REQUEST remove the parent control items and their dependent records.

Tables Accessed

The package references the following tables through APPS synonyms:

• PA_CI_ACTIONS, PA_CI_COMMENTS — store action records and reviewer comments against control items.
• PA_CI_SUPPLIER_DETAILS — holds supplier change impact detail rows created by the supplier impact APIs.
• PA_CI_IMPACTS, PA_CI_TYPES_B — impact definitions and control item type lookups.
• PA_CONTROL_ITEMS — the master control item table for issues, change requests, and change orders.
• PA_PROJECTS_ALL, PA_PROJECT_STATUSES, PA_CLASS_CODES — validate project context and classification.
• PA_WF_PROCESSES — workflow process configuration used when initiating actions.
• PER_ALL_PEOPLE_F — validates assignee and user references.
• DBMS_SQL, PLITBLM — dynamic SQL and PL/SQL table utilities supporting the table-type parameters.

Usage Notes

PA_CONTROL_API_PUB is typically invoked from the Projects change management forms, from concurrent programs that process control items in batch, and from custom extensions requiring programmatic creation or update of issues, change requests, and change orders. Because it is classified as a PUB API, it is the supported entry point for third-party and customer code; direct DML against the underlying PA_CI_* tables is discouraged. The G_PA_MISS_DATE constant is significant to callers building record parameters, since it provides the canonical sentinel value indicating an unspecified date attribute.