Search Results pa_assignment_conflict_hist_s

Overview

PA_ASGN_CONFLICT_HIST_PKG is an Oracle EBS Applications (APPS) PL/SQL package body classified as type OTHER in the ETRM metadata for release 12.1.1 and 12.2.2. Its business purpose is to manage the persistent record of assignment conflict history within Oracle Projects. When project resources, roles, or assignments are evaluated against conflict rules, the outcomes of those evaluations are retained so that project managers and resource managers can audit past conflict conditions, review how conflicts were resolved, and maintain a traceable history of staffing decisions. The package encapsulates the insert, update, and delete logic against the underlying conflict history tables, centralizing data manipulation and shielding callers from direct DML against those tables.

Key Procedures and Functions

ETRM documents eight total procedures and functions within the package body, with the following three explicitly named:

• INSERT_ROWS — Creates new conflict history records. It is the entry point used when a newly detected assignment conflict must be persisted to the history table.
• UPDATE_ROWS — Modifies existing conflict history records, typically to reflect a change in conflict status, resolution, or associated assignment attributes.
• DELETE_ROWS — Removes conflict history records, supporting purge, correction, and cleanup operations.

Consistent with the package's dependencies on FND_API, FND_MSG_PUB, and FND_GLOBAL, these routines follow the standard Oracle EBS API design conventions: they operate on array-based (table type) parameters rather than single rows, return a standard API status, and report errors through the FND message stack. The metadata does not publish parameter lists for these procedures; the descriptions above therefore address purpose only. The remaining five documented procedures and functions are not individually named in the supplied excerpt.

Tables Accessed

The package references the following objects, resolved through APPS synonyms:

• PA_ASSIGNMENT_CONFLICT_HIST — The primary conflict history table. It is the target of the INSERT_ROWS, UPDATE_ROWS, and DELETE_ROWS operations and stores the retained conflict records.
• PA_ASSIGNMENT_CONFLICT_HIST_S — The corresponding sequence used to generate unique primary keys for new history rows. This is the object most directly associated with the user's search string "pa_assignment_conflict_hist_s".
• DUAL — The standard Oracle single-row utility table, used for sequence value retrieval and similar scalar operations.
• PLITBLM — The PL/SQL table/index-by table support object used by the procedural code.

The package additionally depends on the PL/SQL table types PA_NUM_TBL_TYPE, PA_VARCHAR2_1_TBL_TYPE, and PA_VARCHAR2_30_TBL_TYPE, which define the array parameter structures passed into the row-handling procedures.

Usage Notes

Because the package is not referenced by any other database object, it is not part of an internal dependency chain triggered automatically by other PL/SQL units. It is instead invoked externally — most plausibly from Oracle Projects forms or concurrent programs that detect and record assignment conflicts, or from custom extensions and interfaces that need to write conflict history in a controlled, API-compliant manner. The metadata notes that the package is referenced by two other packages, indicating that those callers supply the table-type arrays and receive the standard API return status. Developers should call INSERT_ROWS, UPDATE_ROWS, and DELETE_ROWS rather than issuing direct DML against PA_ASSIGNMENT_CONFLICT_HIST, so that sequence derivation, validation, and message handling remain consistent. As with all APPS packages, execution requires the appropriate APPS privileges and, for error escalation, correct initialization of the FND message and global context facilities.