Search Results check_delete_task_ok

Overview

APPS.ENG_LIFECYCLE_USER_PUB is a public PL/SQL API package in Oracle E-Business Suite that belongs to the Engineering (ENG) product family and supports the product lifecycle management (PLM) and engineering change management (ECM) functionality within EBS. It is declared with the AUTHID CURRENT_USER clause, meaning it executes with the privileges of the invoking user and relies on the APPS schema synonyms for the underlying tables it consults. The package header was created with a version of 115.0, dated February 2003, reflecting its origins in the 11i code line that was carried forward into Release 12.1.1 and 12.2.2. The package serves as a gatekeeper for deletion activities in the engineering and project lifecycle domain. Specifically, it provides callers with a programmatic way to determine whether a given project or task may safely be deleted, taking into account references from engineering changes and other dependent lifecycle objects. Because engineering changes frequently reference projects and tasks, allowing deletion without validation could corrupt the ECM data model or leave orphaned references. ENG_LIFECYCLE_USER_PUB encapsulates this validation logic in a reusable, standardized API surface that both Oracle standard forms and custom extensions can call.

Key Procedures and Functions

• CHECK_DELETE_PROJECT_OK — This procedure accepts a project identifier (typed against PA_PROJECTS.PROJECT_ID) and evaluates whether that project can be deleted. The procedure takes the standard API parameters, including p_api_version and p_init_msg_list, and returns an x_delete_ok flag, the standard x_return_status, x_errorcode, x_msg_count, and x_msg_data output values used across Oracle EBS APIs for message stack handling. Its logic checks the project for blocking references, such as dependent engineering changes, before returning a deletion verdict.
• CHECK_DELETE_TASK_OK — This procedure performs the parallel validation for a task, accepting a p_task_id typed against PA_TASKS.TASK_ID. It follows the same signature pattern and returns the same set of output parameters, giving the caller a clear boolean indication of whether the task is eligible for deletion along with any diagnostic messages. This is the procedure referenced in the search term "check_delete_task_ok".

Tables Accessed

The documented tables referenced via APPS synonyms are PA_PROJECTS, PA_TASKS, ENG_ENGINEERING_CHANGES, and DUAL. PA_PROJECTS and PA_TASKS are the Project Accounting base tables that hold the project and task records being validated; the procedures read them to confirm the entity exists and to retrieve attributes relevant to deletion rules. ENG_ENGINEERING_CHANGES is the Engineering Change Management table; the package queries it to detect whether an engineering change order or similar lifecycle artifact references the project or task, which would block deletion. DUAL is used for lightweight scalar queries, such as initializing status or returning constant values when no data lookup is required.

Usage Notes

This package is typically invoked when a user attempts to delete a project or task from an Oracle EBS form or a custom program, or when a concurrent process validates lifecycle integrity. The API classification of PUB indicates it is intended for public consumption, so custom code may call it directly. Note that it is referenced by one other package, confirming its role as a shared validation utility. Callers should supply a valid p_api_version and check x_return_status before interpreting x_delete_ok; messages should be retrieved via the standard FND_MSG_PUB message stack in the usual manner.