[Home] [Help]
7123: ,ppe.PHASE_CODE
7124: ,ppe.PHASE_VERSION_ID
7125: ,p_dest_project_id
7126: ,'PA_PROJECTS'
7127: FROM pa_task_types ptt,
7128: pa_proj_elements ppe,
7129: pa_proj_element_versions ppev,
7130: pa_tasks pt
7131: WHERE pt.project_id = p_dest_project_id
9140: ,ppe.WF_PROCESS
9141: ,ppe.WF_START_LEAD_DAYS
9142: ,p_dest_project_id
9143: ,'PA_PROJECTS'
9144: FROM pa_task_types ptt,
9145: pa_tasks pt,
9146: pa_proj_elements ppe
9147: WHERE ptt.object_type = 'PA_TASKS'
9148: AND ppe.type_id = ptt.task_type_id
9292: ,ppe.WF_PROCESS
9293: ,ppe.WF_START_LEAD_DAYS
9294: ,p_dest_project_id
9295: ,'PA_PROJECTS'
9296: FROM pa_task_types ptt,
9297: pa_proj_elements ppe
9298: WHERE ptt.object_type = 'PA_TASKS'
9299: AND ppe.type_id = ptt.task_type_id
9300: AND nvl(ppe.link_task_flag,'N') <> 'Y' -- 4348868
11232: ,ppe.WF_PROCESS
11233: ,ppe.WF_START_LEAD_DAYS
11234: FROM pa_proj_elements ppe,
11235: pa_tasks pt,
11236: pa_task_types ptt --bug 2827090
11237: WHERE ppe.project_id = p_src_project_id
11238: AND pt.project_id = p_dest_project_id
11239: AND pt.task_number = substrb(rtrim(ppe.element_number),1,25) -- Substrb added for Bug 5152448
11240: AND ppe.parent_structure_id = cur_pa_struct_rec.attribute15
15155: -- This cursor identified the number of progressible tasks under a parent.
15156: CURSOR get_child_count(c_parent_element_version_id NUMBER)
15157: IS
15158: SELECT count(rel.object_id_to1)
15159: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt
15160: WHERE rel.object_id_from1 = c_parent_element_version_id
15161: AND rel.object_type_to = 'PA_TASKS'
15162: AND rel.relationship_type = 'S'
15163: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
15168: AND tt.prog_entry_enable_flag = 'Y';
15169:
15170: l_child_task_count NUMBER;
15171: l_parent_version_id pa_proj_element_versions.element_version_id%TYPE;
15172: l_task_type_id pa_task_types.task_type_id%TYPE;
15173: BEGIN
15174: l_existing_task_set_max_wt := 'N';
15175: IF l_maintain_weightages = 'N' THEN -- no need to maintain weightages.
15176: l_weighting_percentage_tbl(l_task_id) := 0;
16530: -- reassign the task weightages for the affected peer tasks.
16531: CURSOR cur_get_child_info(c_parent_element_version_id NUMBER)
16532: IS
16533: SELECT rel.OBJECT_RELATIONSHIP_ID,tt.prog_entry_enable_flag
16534: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt
16535: WHERE rel.object_id_from1 = c_parent_element_version_id
16536: AND rel.object_type_to = 'PA_TASKS'
16537: AND rel.relationship_type = 'S'
16538: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
20366:
20367: TYPE CHILD_INFO_TBL IS TABLE OF CHILD_INFO_REC
20368: INDEX BY BINARY_INTEGER;
20369:
20370: TYPE prog_enable_flag_tbl IS TABLE OF pa_task_types.prog_entry_enable_flag%TYPE
20371: INDEX BY BINARY_INTEGER;
20372:
20373: TYPE object_rel_id_tbl IS TABLE OF pa_object_relationships.object_relationship_id%TYPE
20374: INDEX BY BINARY_INTEGER;
20405: from pa_proj_element_versions ver,
20406: pa_object_relationships rel,
20407: pa_proj_elem_ver_schedule sch,
20408: pa_proj_elements ele,
20409: pa_task_types ptt,
20410: pji_xbs_plans_v pxpv
20411: -- pji_fm_xbs_accum_tmp1 pfxat
20412: where ver.project_id = c_project_id
20413: and ver.parent_structure_version_id = c_structure_version_id
20437: IS
20438: select 'X'
20439: from pa_proj_element_versions ver,
20440: pa_proj_elements ele,
20441: pa_task_types ptt
20442: where ver.project_id = c_project_id
20443: and ver.parent_structure_version_id = c_structure_version_id
20444: and ver.object_type = 'PA_TASKS'
20445: and ele.proj_element_id = ver.proj_element_id