Search Results update_rows

Overview

PA_ASGN_CONFLICT_HIST_PKG is a PL/SQL package in the Oracle EBS Projects (PA) module that manages the persistence layer of the PA_ASSIGNMENT_CONFLICT_HIST entity. This table stores the historical record of assignment conflicts detected by the Oracle Projects resource assignment and scheduling engine, along with the resolution action applied to each conflict. The package encapsulates the DML operations required to maintain this audit-style history, ensuring that conflict records are inserted, updated, and removed in a controlled and consistent manner rather than through ad hoc SQL issued by callers.

The package source header identifies it as PARGASNS.pls (version 120.1.12010000.2, last shipped 2008/08/04), confirming its role as a long-standing component of the Projects assignment conflict framework. Its API classification is OTHER, reflecting that it is not a public business API but an internal utility supporting the conflict detection and resolution flow. It is referenced by two other packages in the EBS codebase, indicating it is invoked programmatically rather than directly by end users.

Key Procedures and Functions

• INSERT_ROWS — Creates rows in PA_ASSIGNMENT_CONFLICT_HIST. The package defines an overloaded version: one signature accepts a single conflict assignment identifier, while the second accepts a PL/SQL table (NumTabTyp) of conflict assignment identifiers for bulk, multi-transaction insertion. Both write the conflict group, assignment, resolve-conflict action code, intra-transaction conflict flag, processed flag, and self-conflict flag, and return standard return status and message count/data outputs.
• UPDATE_ROWS — Updates existing rows in PA_ASSIGNMENT_CONFLICT_HIST, limited to the resolve conflict action code attribute. This procedure is explicitly documented as overloaded, allowing callers to update conflict history for a single conflict assignment or a set of conflicting assignments within a conflict group.
• DELETE_ROWS — Removes rows from PA_ASSIGNMENT_CONFLICT_HIST, providing the cleanup path for conflict history records that are no longer required.

All procedures use the conventional ETRM error-handling contract: x_return_status, x_msg_count, and x_msg_data OUT parameters, with the underlying variables annotated NOCOPY per File.Sql.39 (bug 4440895). Because the metadata lists eight documented procedures or functions, additional internal helpers exist beyond the publicly named DML routines above; only INSERT_ROWS, UPDATE_ROWS, and DELETE_ROWS are externally documented.

Tables Accessed

• PA_ASSIGNMENT_CONFLICT_HIST — the primary base table into which conflict history rows are inserted and against which updates and deletes are performed. This is the package's core write target.
• PA_ASSIGNMENT_CONFLICT_HIST_S — the corresponding DFF/translation shadow table, maintained in step with the base table.
• DUAL — used for lightweight validation or single-row lookups within the package logic.
• PLITBLM — a PL/SQL table reference used to support the bulk, table-based overloads that process collections of conflict assignment identifiers.

Usage Notes

PA_ASGN_CONFLICT_HIST_PKG is invoked internally by the Projects assignment conflict processing logic, most notably when users resolve assignment conflicts in the Projects resource management UI and when conflict detection runs in the background. Because the procedures use array-capable overloads and return the standard status/message trio, the package is well suited for callers that must process many conflicts in a single database round trip. Customizations and extensions should invoke INSERT_ROWS, UPDATE_ROWS, and DELETE_ROWS only after validating x_return_status, and should avoid direct DML against PA_ASSIGNMENT_CONFLICT_HIST so that the base and shadow tables remain synchronized. In EBS 12.1.1 and 12.2.2 the package is unchanged in behavior between releases; the same APIs apply.