DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_NUM_1000_NUM

Line 4951: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

4947: and c.proj_element_id = d.proj_element_id
4948: and d.link_task_flag <> 'Y';
4949: c_get_peer_tasks get_peer_tasks%ROWTYPE;
4950: l_peer_tasks_exist VARCHAR2(1) := 'Y';
4951: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
4952:
4953: --hsiu added, for task weighting
4954: CURSOR get_parent_version_id IS
4955: select object_id_from1

Line 7305: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

7301: l_attribute15 pa_proj_elem_ver_schedule.attribute15%TYPE ;
7302: -- end xxlu changes
7303:
7304: --hsiu added, for dates rollup
7305: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
7306: l_actual_wq NUMBER;
7307:
7308: --hsiu: bug 3035902
7309: l_update_flag VARCHAR2(1) := 'N';

Line 8935: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

8931: and a.relationship_type = 'S'
8932: and b.relationship_type = 'S';
8933: c_get_peer_tasks get_peer_tasks%ROWTYPE;
8934: l_peer_tasks_exist VARCHAR2(1) := 'Y';
8935: l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
8936:
8937: --hsiu added, for task weighting
8938: CURSOR get_parent_version_id IS
8939: select object_id_from1

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

9827: wrk_task_ids task_id_tbl_type;
9828: i NUMBER := 0;
9829: l_parent_struc_ver_id NUMBER;
9830: /* Bug 2790703 Begin */
9831: -- l_tasks_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9832: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
9833: l_index number :=0 ;
9834: /* Bug 2790703 End */
9835: