[Home] [Help]
7372: ,ppe.PHASE_CODE
7373: ,ppe.PHASE_VERSION_ID
7374: ,p_dest_project_id
7375: ,'PA_PROJECTS'
7376: FROM pa_task_types ptt,
7377: pa_proj_elements ppe,
7378: pa_proj_element_versions ppev,
7379: pa_tasks pt
7380: WHERE pt.project_id = p_dest_project_id
9432: ,ppe.WF_PROCESS
9433: ,ppe.WF_START_LEAD_DAYS
9434: ,p_dest_project_id
9435: ,'PA_PROJECTS'
9436: FROM pa_task_types ptt,
9437: pa_tasks pt,
9438: pa_proj_elements ppe
9439: WHERE ptt.object_type = 'PA_TASKS'
9440: AND ppe.type_id = ptt.task_type_id
9584: ,ppe.WF_PROCESS
9585: ,ppe.WF_START_LEAD_DAYS
9586: ,p_dest_project_id
9587: ,'PA_PROJECTS'
9588: FROM pa_task_types ptt,
9589: pa_proj_elements ppe
9590: WHERE ptt.object_type = 'PA_TASKS'
9591: AND ppe.type_id = ptt.task_type_id
9592: AND nvl(ppe.link_task_flag,'N') <> 'Y' -- 4348868
11547: ,ppe.WF_PROCESS
11548: ,ppe.WF_START_LEAD_DAYS
11549: FROM pa_proj_elements ppe,
11550: pa_tasks pt,
11551: pa_task_types ptt --bug 2827090
11552: WHERE ppe.project_id = p_src_project_id
11553: AND pt.project_id = p_dest_project_id
11554: AND pt.task_number = substrb(rtrim(ppe.element_number),1,25) -- Substrb added for Bug 5152448
11555: AND ppe.parent_structure_id = cur_pa_struct_rec.attribute15
15733: -- This cursor identified the number of progressible tasks under a parent.
15734: CURSOR get_child_count(c_parent_element_version_id NUMBER)
15735: IS
15736: SELECT count(rel.object_id_to1)
15737: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt
15738: WHERE rel.object_id_from1 = c_parent_element_version_id
15739: AND rel.object_type_to = 'PA_TASKS'
15740: AND rel.relationship_type = 'S'
15741: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
15746: AND tt.prog_entry_enable_flag = 'Y';
15747:
15748: l_child_task_count NUMBER;
15749: l_parent_version_id pa_proj_element_versions.element_version_id%TYPE;
15750: l_task_type_id pa_task_types.task_type_id%TYPE;
15751: BEGIN
15752: l_existing_task_set_max_wt := 'N';
15753: IF l_maintain_weightages = 'N' THEN -- no need to maintain weightages.
15754: l_weighting_percentage_tbl(l_task_id) := 0;
17177: -- reassign the task weightages for the affected peer tasks.
17178: CURSOR cur_get_child_info(c_parent_element_version_id NUMBER)
17179: IS
17180: SELECT rel.OBJECT_RELATIONSHIP_ID,tt.prog_entry_enable_flag
17181: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt
17182: WHERE rel.object_id_from1 = c_parent_element_version_id
17183: AND rel.object_type_to = 'PA_TASKS'
17184: AND rel.relationship_type = 'S'
17185: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
21161:
21162: TYPE CHILD_INFO_TBL IS TABLE OF CHILD_INFO_REC
21163: INDEX BY BINARY_INTEGER;
21164:
21165: TYPE prog_enable_flag_tbl IS TABLE OF pa_task_types.prog_entry_enable_flag%TYPE
21166: INDEX BY BINARY_INTEGER;
21167:
21168: TYPE object_rel_id_tbl IS TABLE OF pa_object_relationships.object_relationship_id%TYPE
21169: INDEX BY BINARY_INTEGER;
21200: from pa_proj_element_versions ver,
21201: pa_object_relationships rel,
21202: pa_proj_elem_ver_schedule sch,
21203: pa_proj_elements ele,
21204: pa_task_types ptt,
21205: pji_xbs_plans_v pxpv
21206: -- pji_fm_xbs_accum_tmp1 pfxat
21207: where ver.project_id = c_project_id
21208: and ver.parent_structure_version_id = c_structure_version_id
21232: IS
21233: select 'X'
21234: from pa_proj_element_versions ver,
21235: pa_proj_elements ele,
21236: pa_task_types ptt
21237: where ver.project_id = c_project_id
21238: and ver.parent_structure_version_id = c_structure_version_id
21239: and ver.object_type = 'PA_TASKS'
21240: and ele.proj_element_id = ver.proj_element_id