DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_NUM_TBL_TYPE

Line 2732: l_task_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ; -- 4201927 for performance issue

2728: and prior object_type_to = object_type_from
2729: and relationship_type = prior relationship_type; --Bug 3792616
2730: l_task_ver_id NUMBER;
2731:
2732: l_task_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ; -- 4201927 for performance issue
2733: BEGIN
2734:
2735: PA_PROJ_ELEMENTS_UTILS.CHECK_DELETE_TASK_VER_OK(
2736: p_project_id => p_project_id

Line 5317: /*l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); */ -- Commented this as this is no more needed after Bug#4964992 fix.

5313: AND PROJECT_ID = p_project_id
5314: START WITH TASK_ID = p_TASK_ID
5315: AND PROJECT_ID = p_project_id; */
5316:
5317: /*l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); */ -- Commented this as this is no more needed after Bug#4964992 fix.
5318: l_dummy number:=0;
5319: l_task_tbl sub_task; --Added this for Bug#4964992.
5320:
5321: BEGIN