Search Results create_def_prj_stus_controls

Overview

APPS.PA_PROJECT_CORE2 is a server-side PL/SQL package belonging to the Oracle Projects (PA) application family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered in ETRM with an API classification of OTHER, indicating that it is not exposed as a formally supported public API but is used internally by Oracle Projects and by dependent product code. The package is defined with AUTHID CURRENT_USER and executes under the privileges of the calling session rather than the APPS schema owner.

The package addresses two distinct areas of project lifecycle maintenance. The first is the duplication of the task hierarchy from an existing project onto a newly created project, including the transaction control, billing, asset assignment and rate- related attributes attached to each task. The second is the generation of default project status controls whenever a new project status is defined. Together these routines support the administrative setup that must occur before transactional project data can be entered or billed.

Key Procedures and Functions

• COPY_TASK — Creates new tasks on a target project by copying the task structure of a source project. The caller supplies the originating project identifier and the destination project identifier. Beyond the task records themselves, the procedure propagates task-level attributes such as transaction controls, billing assignments, project asset assignments, percent complete values, burden schedules and overrides. Error information is returned to the caller through standard Oracle Projects error handling parameters for error code, error stage and error stack.
• CREATE_DEF_PRJ_STUS_CONTROLS — Populates the default project status controls for a newly created project status. The defaults are derived from the system status associated with the status being created. This procedure is intended to be invoked after a new project status row has been inserted, ensuring that the status is usable within the project status control framework.

Both procedures use NOCOPY OUT parameters for the error stack, error stage and error code, consistent with the File.Sql.39 convention used throughout Oracle Projects to avoid unnecessary copying of large PL/SQL values.

Tables Accessed

The documented table references are entirely rate, billing and assignment related, reflecting the attribute set copied by COPY_TASK. The package reads and writes PA_BILLING_ASSIGNMENTS and PA_BILLING_ASSIGNMENTS_S to carry billing assignment definitions and their translation rows, and interacts with PA_EMP_BILL_RATE_OVERRIDES, PA_JOB_BILL_RATE_OVERRIDES, PA_JOB_ASSIGNMENT_OVERRIDES and PA_JOB_BILL_TITLE_OVERRIDES (each with its corresponding _S translation table) to reproduce employee and job level billing overrides. Rate schedule structures are handled through PA_IND_RATE_SCHEDULES_S, PA_IND_RATE_SCH_REVISIONS and PA_IND_RATE_SCH_REVISIONS_S, while multiplier and burden information is drawn from PA_IND_COST_MULTIPLIERS and PA_LABOR_MULTIPLIERS. All of these objects are accessed through APPS synonyms, so the package resolves them in the APPS schema at runtime.

Usage Notes

PA_PROJECT_CORE2 is most commonly invoked from Oracle Projects setup forms and from concurrent programs that perform project duplication or mass task creation. The COPY_TASK entry point is the logical backend for task copy functionality presented to users during project creation or project template instantiation. Because the package manipulates the _S (translation) shadow tables alongside the base tables, it is not intended for direct ad hoc SQL manipulation; callers should pass valid project identifiers and be prepared to interpret the returned error code, stage and stack to diagnose partial failures. ETRM records that two other packages reference PA_PROJECT_CORE2, confirming its role as a shared internal utility rather than a standalone entry point. Customizations in 12.1.1 and 12.2.2 should treat this package as unsupported internal code and avoid direct dependencies, since Oracle does not guarantee its signature across patches or upgrades.