Search Results pjm_task_autoassign_copy




Overview
Explore in AI Chat

Overview

PJM_TASK_AUTOASSIGN_COPY is a stored PL/SQL package owned by the APPS schema in Oracle E-Business Suite, and it is classified under the Oracle Projects (PJM) module family. As its name indicates, the package is concerned with the automatic assignment of tasks within Oracle Projects and with the propagation, or copying, of that assignment behaviour between organizational or project-level configuration contexts. In Oracle Projects, task auto-assignment governs how tasks are selected and associated with project-related transactions, resource assignments, and expenditure items when explicit task selection is not performed by the user or an integration. The package therefore encapsulates the rules that determine default task behaviour.

The package carries a VALID status in the ETRM repository, confirming it is compiled and active in both the 12.1.1 and 12.2.2 environments. Its API classification is documented as OTHER, meaning it is not formally published as a public open interface in the same manner as certain Projects APIs; it is instead an internal utility. No other packages are documented as referencing it, which suggests its callers are typically UI forms, concurrent programs, or other internal constructs rather than a documented dependency chain.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package:

  • COPY_RULES — This procedure is responsible for copying task auto-assignment rules from one context to another. Its purpose is to replicate the configured automatic task assignment behaviour so that administrators do not need to re-enter identical rules manually across organizations or projects. It reads the source rule configuration and writes the corresponding target configuration, respecting the default task and parameter settings held in the tables described below.

No parameter lists are documented in the available metadata, and none are asserted here. Custom development that intends to invoke COPY_RULES should inspect the package specification in the target environment to determine the exact signature, as Oracle does not publish formal parameter documentation for this internal package.

Tables Accessed

The package is documented as referencing the following tables through APPS synonyms:

  • PJM_DEFAULT_TASKS — Stores the default task definitions used when tasks are automatically assigned. The package reads and potentially writes entries here as part of replicating or establishing default task behaviour.
  • PJM_ORG_PARAMETERS — Holds organization-level implementation parameters, including those that control auto-assignment defaults. The package reads these to determine the organizational context of the rules being copied.
  • PJM_PROJECT_PARAMETERS — Holds project-level parameter settings, including task assignment configuration. The package reads and writes these where project-specific auto-assignment behaviour is being propagated.
  • DUAL — Used for single-row PL/SQL evaluation, validation, or constant selection within the procedure logic.

Usage Notes

PJM_TASK_AUTOASSIGN_COPY is an internal Oracle Projects utility rather than a supported public API. It is typically invoked indirectly through Oracle Projects setup forms, concurrent programs, or seeded internal logic during configuration activities such as copying project or organization templates. Because the ETRM metadata records no downstream package dependencies and classifies the API as OTHER, customers should treat it as a private construct. Any custom invocation of COPY_RULES must be validated against the specific 12.1.1 or 12.2.2 instance, since the package signature and behaviour fall outside Oracle's documented public interface guarantees and could change through patching.