Results for “pa_task_utils”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_TASK_UTILS is a core Oracle Projects utility package body owned by the APPS schema. It encapsulates the business logic used to create, validate, maintain, and query project tasks and their hierarchical work breakdown structure (WBS) structures within Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package serves as the shared validation and navigation layer for task-level processing, supplying reusable procedures and functions that other Oracle Projects components call rather than re-implementing task rules locally. Consistent with its classification as a non-public ("OTHER") API, PA_TASK_UTILS is intended primarily for internal consumption by Oracle Projects forms, concurrent programs, and dependent packages, though customers may reference it with caution. At the time of documentation the package body holds a VALID status in the APPS schema, and it is referenced by 108 other database objects, underscoring its role as a foundational dependency in the Projects task framework.

Key Procedures and Functions

The documented interface exposes 25 procedures and functions oriented around task hierarchy navigation, validation, and attribute retrieval.

• Hierarchy navigation: GET_WBS_LEVEL returns the WBS level of a task; GET_TOP_TASK_ID and GET_PARENT_TASK_ID resolve the top-level and immediate parent task respectively; SORT_ORDER_TREE_WALK traverses the task tree in sort order.
• Validation checks: CHECK_UNIQUE_TASK_NUMBER verifies task number uniqueness; CHECK_LAST_TASK and CHECK_LAST_CHILD test whether a task is the final sibling or final child; CHECK_CHILD_EXISTS confirms subordinate tasks exist; CHECK_DELETE_TASK_OK determines deletion eligibility; CHECK_CREATE_SUBTASK_OK validates subtask creation; CHECK_PCT_COMPLETE_EXISTS tests for percent-complete records; CHECK_LABOR_COST_MULTIPLIER verifies labor cost multiplier setup.
• Structural change validation: CHANGE_LOWEST_TASK_NUM_OK, CHANGE_TASK_ORG_OK, CHANGE_TASK_ORG_OK1, and CHANGE_TASK_ORG_OK2 govern renumbering and organization reassignment rules.
• Attribute retrieval: GET_TASK_NAME, GET_TASK_NUMBER, GET_RESOURCE_NAME, and GET_RESOURCE_LIST_NAME return descriptive attributes for tasks and associated resource lists.

Tables Accessed

The package reads and writes several Projects tables through APPS synonyms. PA_TASKS is the primary task master table, supported by PA_PROJ_ELEMENTS and PA_PROJ_ELEM_VER_SCHEDULE for project element and version scheduling data. PA_PROJECTS_ALL, PA_PROJECT_TYPES, and PA_PROJECT_TYPES_ALL supply project-level context and type definitions. PA_PERCENT_COMPLETES holds progress measurement records validated by the package. PA_EVENTS supports event-driven processing, while PA_MASS_UPDATE_BATCHES and PA_RESOURCE_LISTS_ALL_BG (with PA_RESOURCE_LIST_MEMBERS) underpin mass update and resource list operations. DUAL and PLITBLM are used for utility and PL/SQL table handling purposes.

Usage Notes

PA_TASK_UTILS is invoked indirectly whenever task-level validation or hierarchy resolution is required. Oracle Projects task maintenance forms call its check functions before committing inserts, updates, deletes, and organization changes, while concurrent programs such as mass maintenance and WBS processing rely on its tree-walk and retrieval routines. Because it is referenced by 108 packages—including PA_TASK_PUB1, PA_PROJ_TSK_UTILS, and PA_PROJ_STRUCTURE_PUB—custom extensions should call the public task APIs where possible and treat PA_TASK_UTILS as an internal dependency whose signature is not guaranteed across patches.