Search Results set_unset_financial_task

Overview

PA_TASKS_MAINT_PVT is a private PL/SQL package in the Oracle EBS Projects (PA) module that encapsulates the core maintenance logic for project tasks and task structures. It operates as the internal engine behind the public task maintenance APIs, providing the validation, data manipulation, and hierarchy management routines required when tasks are created, modified, reorganized, or copied within a project. Because the package is classified as PVT (private), it is not intended for direct invocation by external integrations; instead it is consumed by the public wrapper packages and by the Oracle Projects forms that present the Task Maintenance and Workplan user interfaces. The package body header identifies the source file as PATSKSVB.pls and shows references to workplan (WP) functionality, reflecting its role in keeping task definitions synchronized with financial and workplan structures.

Key Procedures and Functions

The package exposes eleven documented procedures and functions covering the full lifecycle of project tasks:

• CREATE_TASK, UPDATE_TASK, and DELETE_TASK — the fundamental CRUD operations for task records, including validation of task attributes and maintenance of associated project element and version data.
• INDENT_TASK and OUTDENT_TASK — adjust the hierarchical position of a task by moving it deeper into or shallower out of the task structure, preserving the parent/child relationships maintained in PA_TASKS.
• MOVE_TASK — relocates a task to a different parent or position within the hierarchy.
• COPY_ENTIRE_PROJECT, COPY_SELECTED_TASK, and COPY_ENTIRE_TASK — provide the several copy scenarios supported by the module: replicating an entire project structure, duplicating an individual task, or duplicating a selected subset of tasks.
• SET_UNSET_FINANCIAL_TASK — the routine associated with the searched term; it toggles the financial task designation, controlling whether a given task is treated as a financial task within the project's financial structure.
• SYNC_UP_WP_TASKS_WITH_FIN — reconciles workplan tasks with the financial task structure, ensuring the two representations remain consistent when financial settings change.

These procedures are not declared individually here with parameter lists; callers obtain their signatures from the package specification and the public APIs that wrap them.

Tables Accessed

The package reads and writes a defined set of PA and FND tables through APPS synonyms. PA_TASKS and PA_TASKS_S store the core task definitions and their translated/audit representations. PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS hold the project-element mapping and versioning that tasks depend on for financial processing. PA_PROJECTS_ALL, PA_PROJECT_TYPES_ALL, and PA_PROJECT_CUSTOMERS supply project-level and customer context needed for validation. PA_OBJECT_RELATIONSHIPS is used to maintain the hierarchical and object links between tasks. FND_NEW_MESSAGES supports the FND message and error-reporting framework, while ALL_TAB_COLUMNS and USER_SYNONYMS are queried for dynamic metadata and synonym resolution at runtime.

Usage Notes

PA_TASKS_MAINT_PVT is invoked primarily from the Oracle Projects Task Maintenance and Workplan forms, and from concurrent programs that copy or reorganize project structures. It is also referenced by one other package, which typically wraps these private routines behind a public API surface. Custom code should call the corresponding public PA task APIs rather than this private package, since signatures may change between releases (the header indicates version 120.14 applied to Release 12.1). The SET_UNSET_FINANCIAL_TASK and SYNC_UP_WP_TASKS_WITH_FIN routines are of particular interest when financial task flags are changed, as they trigger reconciliation between workplan and financial representations.