Search Results set_financial_flag_wrapper

Overview

PA_TASKS_MAINT_PUB is a public PL/SQL package in the Oracle EBS Projects (PA) application responsible for the maintenance of project tasks and task structures. It provides the programmatic interface through which task records are created, modified, deleted, copied, and reorganized within the Project Management and Project Costing functional areas. Tasks represent the lowest level of the project work breakdown structure and carry the financial attributes used to collect costs, budgets, and commitments. The package therefore bridges the descriptive project-management side of tasks with the financial processing performed by Oracle Projects Financials (FIN).

The specification header indicates significant historical development, including additions made for the FP.M (Project Financial Management) code line. The package exposes a set of versioned, API-style procedures that conform to the Oracle Application Object Library (AOL) API conventions, accepting standard parameters such as p_api_version, p_init_msg_list, p_commit, p_validate_only, and p_validation_level. This design allows callers to invoke the APIs in validation-only mode before committing changes.

Key Procedures and Functions

• CREATE_TASK — Creates a new project task, accepting descriptive, organizational, and financial attributes such as project identifier, task number and name, manager, carrying-out organization, task type, priority, work type, service type, and milestone indicator. It also supports creation relative to a reference task.
• UPDATE_TASK — Modifies the attributes of an existing task record.
• DELETE_TASK — Removes a task from the project structure.
• EDIT_TASK_STRUCTURE — Supports modification of the hierarchical relationships that make up the task breakdown structure.
• MOVE_TASK — Relocates a task within the task hierarchy, typically to a new parent.
• COPY_TASK — Duplicates a task, or a task structure, for reuse within a project.
• SET_FINANCIAL_FLAG_WRAPPER — Wrapper routine that toggles the financial flag on a task, controlling whether the task participates in Project Financials processing.
• POPULATE_TEMP_TABLE — Populates the temporary table PA_PREVIEW_FIN_TASKS_TEMP, used to preview financial task data before synchronization.
• SYNC_UP_WP_TASKS_WITH_FIN — The procedure matching the user search term. It synchronizes Workplan (WP) tasks with the financial task structures maintained by Oracle Projects Financials, aligning task definitions between the workplan and the financially enabled task hierarchy.

Tables Accessed

• PA_TASKS — Core task table holding task definitions and attributes.
• PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS — Store project elements and their versioned attributes, linking tasks to the broader project element model.
• PA_PROJ_ELEM_VER_STRUCTURE — Maintains the hierarchical structure and version relationships among project elements.
• PA_OBJECT_RELATIONSHIPS — Records relationships between project objects, supporting workplan-to-financial task association.
• PA_PREVIEW_FIN_TASKS_TEMP — Temporary staging table used by POPULATE_TEMP_TABLE and the synchronization logic.
• DUAL and PLITBLM — Utility references used in PL/SQL processing.

Usage Notes

PA_TASKS_MAINT_PUB is invoked from Oracle Projects forms, concurrent programs, and custom integrations that manage project tasks. Its standard API parameter conventions make it suitable for use with the AOL API validation framework, and it is referenced by eight other packages, indicating that it functions as a shared service for task maintenance across the application. The SYNC_UP_WP_TASKS_WITH_FIN procedure is typically called when a workplan task must be created or aligned within the financial task structure, ensuring consistent financial tracking.