DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_NUM_1000_NUM

Line 5451: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

5447: and c.proj_element_id = d.proj_element_id
5448: and d.link_task_flag <> 'Y';
5449: c_get_peer_tasks get_peer_tasks%ROWTYPE;
5450: l_peer_tasks_exist VARCHAR2(1) := 'Y';
5451: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
5452:
5453: --hsiu added, for task weighting
5454: CURSOR get_parent_version_id IS
5455: select object_id_from1

Line 7908: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

7904: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7905: -- end xxlu changes
7906:
7907: --hsiu added, for dates rollup
7908: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7909: l_actual_wq NUMBER;
7910:
7911: --hsiu: bug 3035902
7912: l_update_flag VARCHAR2(1) := 'N';

Line 9681: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

9677: and a.relationship_type = 'S'
9678: and b.relationship_type = 'S';
9679: c_get_peer_tasks get_peer_tasks%ROWTYPE;
9680: l_peer_tasks_exist VARCHAR2(1) := 'Y';
9681: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9682:
9683: --hsiu added, for task weighting
9684: CURSOR get_parent_version_id IS
9685: select object_id_from1

Line 10588: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

10584: wrk_task_ids task_id_tbl_type;
10585: i NUMBER := 0;
10586: l_parent_struc_ver_id NUMBER;
10587: /* Bug 2790703 Begin */
10588: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
10589: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
10590: l_index number :=0 ;
10591: /* Bug 2790703 End */
10592: