APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_NUM_TBL_TYPE

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

2821: and prior object_type_to = object_type_from
2822: and relationship_type = prior relationship_type; --Bug 3792616
2823: l_task_ver_id NUMBER;
2824:
2825: l_task_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ; -- 4201927 for performance issue
2826: BEGIN
2827:
2828: PA_PROJ_ELEMENTS_UTILS.CHECK_DELETE_TASK_VER_OK(
2829: p_project_id => p_project_id

Line 5411: /*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.

5407: AND PROJECT_ID = p_project_id
5408: START WITH TASK_ID = p_TASK_ID
5409: AND PROJECT_ID = p_project_id; */
5410:
5411: /*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.
5412: l_dummy number:=0;
5413: l_task_tbl sub_task; --Added this for Bug#4964992.
5414:
5415: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16461684

Line 5415: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16461684

5411: /*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.
5412: l_dummy number:=0;
5413: l_task_tbl sub_task; --Added this for Bug#4964992.
5414:
5415: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16461684
5416: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(); --bug#16461684
5417: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16461684
5418: l_alt_task_tbl sub_task; --bug#16461684
5419: l_tmp_task_tbl sub_task; --bug#16461684