Search Results load_class_category

Overview

APPS.PA_PROJECT_PUB is the public (PUB-classified) PL/SQL API package for the Oracle Projects (PA) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the canonical server-side interface through which projects, tasks, and their supporting attributes are created, validated, loaded, and maintained. The package encapsulates the business rules that govern project and task structure so that external callers — Oracle forms, concurrent programs, and custom extensions — do not manipulate the underlying PA_PROJECTS and related tables directly.

Users searching for "pa_proj_task_struc_pub" are typically looking for the entry point that manages the project-to-task structure hierarchy. That capability resides within the project and task API family: PA_PROJECT_PUB provides project-level and task-level operations such as ADD_TASK, LOAD_TASK, and DELETE_TASK, while the closely related package PA_PROJ_TASK_STRUC_PUB (listed as a dependent of PA_PROJECT_PUB) addresses the structure and parent-child relationships. Together they form the supported API surface for building and reorganizing work breakdown structures.

Key Procedures and Functions

The ETRM metadata documents 78 procedures and functions. The principal entries include:

• CREATE_PROJECT — Creates a new project record with its defining attributes.
• INIT_PROJECT / CLEAR_PROJECT — Initialize and reset the project-level record structure used by the multi-step create/load process.
• EXECUTE_CREATE_PROJECT — Performs the actual persistence step of the create sequence.
• LOAD_PROJECT — Populates the project record from caller-supplied values before creation.
• LOAD_KEY_MEMBER, LOAD_ORG_ROLE, LOAD_CLASS_CATEGORY — Load the key members, organization roles, and class categories associated with a project.
• ADD_TASK, LOAD_TASK, DELETE_TASK, FETCH_TASK — Manage tasks within a project: add a task, load its attributes, remove it, and retrieve its data.
• CHECK_DELETE_TASK_OK, CHECK_ADD_SUBTASK_OK, CHECK_CHANGE_PARENT_OK — Validate whether a task may be deleted, whether a subtask may be added, and whether a task may be reparented within the structure.
• CHECK_DELETE_PROJECT_OK, CHECK_CHANGE_PROJECT_ORG_OK — Validate project deletion and project organization changes.
• CHECK_UNIQUE_TASK_REFERENCE, CHECK_UNIQUE_TASK_NUMBER, CHECK_UNIQUE_PROJECT_REFERENCE — Enforce uniqueness of task and project identifiers.

Tables Accessed

The package reads and writes documented PA and external tables via APPS synonyms. PA_PROJECTS, PA_ALTERNATE_TASKS, PA_CLASS_CODES, and PA_OBJECT_RELATIONSHIPS support the core project/task structure and classification data. PA_DRAFT_INVOICES and PA_DRAFT_REVENUES participate in billing-related validation. AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL are referenced for supplier cost and invoice validation. HZ_PARTIES and HZ_CUST_ACCOUNTS supply trading partner information. PA_IMPLEMENTATIONS, PA_PROBABILITY_MEMBERS, PA_OBJ_STATUS_CHANGES_S, and PA_PJI_PROJ_EVENTS_LOG support implementation checks, forecasting, status history, and project events logging. FND_NEW_MESSAGES is used for message resolution within the FND_API error-handling framework.

Usage Notes

PA_PROJECT_PUB is invoked from Oracle Projects forms, concurrent programs, and custom PL/SQL integrations. The ETRM dependency listing shows it is referenced by twenty other packages, including PA_PROJECT_PVT, PA_TASK_PUB1, PA_TASK_PVT1, PA_PROJ_TASK_STRUC_PUB, PA_STATUS_PUB, PA_ACTIONS_PUB, PA_PROJECT_INTEGRATION_PUB, PA_PROJECT_PARTIES_PUB, PA_USER_ATTR_PUB, PA_XC_PROJECT_PUB, PA_STRUCT_TASK_ROLLUP_PUB, PA_TASKS_MAINT_PVT, GMS_AWARD_PVT, GMS_MULTI_FUNDING, AHL_VWP_PROJ_PROD_PVT, and PJM_SEIBAN_PKG. It depends on FND_API and PA_PROJECT_UTILS for error handling and shared business logic. Because it is a PUB API, callers should invoke it rather than modifying PA_PROJECTS directly, ensuring that validation, uniqueness checks, and event logging are consistently applied.