684: SELECT 'Y'
685: FROM DUAL
686: WHERE EXISTS
687: (SELECT 1
688: FROM pa_percent_completes ppc
689: WHERE ppc.project_id=p_project_id);
690:
691: c1_rec C1%ROWTYPE;
692:
1515: ,pa_task_types tt
1516: ,pa_project_statuses pps3
1517: ,pa_page_layouts ppl
1518: ,pa_progress_rollup ppru
1519: -----,pa_percent_completes ppc
1520: ,pa_project_statuses pps
1521: ,pa_project_statuses pps5
1522: ,pa_proj_elements ppe5
1523: ,pa_proj_element_versions ppv5
2092: ,pa_task_types tt
2093: ,pa_project_statuses pps3
2094: ,pa_page_layouts ppl
2095: ,pa_progress_rollup ppru
2096: -----,pa_percent_completes ppc
2097: ,pa_project_statuses pps
2098: ,pa_project_statuses pps5
2099: ,pa_proj_elements ppe5
2100: ,pa_proj_element_versions ppv5
2202: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
2203: -- ************************************************************************************************************************
2204:
2205: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
2206: --Bug 5580992: Removed the reference to pa_percent_completes. The columns Progress_comments and
2207: --Progress_brief_overview are updated after this insert.
2208:
2209: INSERT INTO pa_structures_tasks_tmp
2210: (
2914: ,pa_task_types tt
2915: ,pa_project_statuses pps3
2916: ,pa_page_layouts ppl
2917: ,pa_progress_rollup ppru
2918: -----,pa_percent_completes ppc Bug 5580992
2919: ,pa_project_statuses pps
2920: ,pa_project_statuses pps5
2921: ,pa_proj_elements ppe5
2922: ,pa_proj_element_versions ppv5
3494: ,pa_task_types tt
3495: ,pa_project_statuses pps3
3496: ,pa_page_layouts ppl
3497: ,pa_progress_rollup ppru
3498: -----,pa_percent_completes ppc Bug 5580992
3499: ,pa_project_statuses pps
3500: ,pa_project_statuses pps5
3501: ,pa_proj_elements ppe5
3502: ,pa_proj_element_versions ppv5
3607: * *
3608: *
3609: --Bug 5580992. This block will select the progress comment/description from pa_process_completes
3610: --update the same in PA_STRUCTURES_TASKS_TMP. This is done to remove the reference to
3611: --pa_percent_completes in above select and hence improve its performance. Please refer to bug
3612: --for more details.
3613: l_rowid_tbl.delete;
3614: l_pc_tbl.delete;
3615: l_desc_tbl.delete;
3622: l_tmp_pc := NULL;
3623: l_tmp_desc := NULL;
3624: SELECT ppc.progress_comment ,ppc.description
3625: INTO l_tmp_pc ,l_tmp_desc
3626: FROM pa_percent_completes ppc
3627: WHERE ppc.project_id=rec.project_id
3628: AND ppc.object_id = rec.proj_element_id
3629: AND ppc.object_type = 'PA_TASKS'
3630: AND ppc.date_computed = rec.as_of_date
4364: ,pa_task_types tt
4365: ,pa_project_statuses pps3
4366: ,pa_page_layouts ppl
4367: ,pa_progress_rollup ppru
4368: -----,pa_percent_completes ppc
4369: ,pa_project_statuses pps
4370: ,pa_project_statuses pps5
4371: ,pa_proj_elements ppe5
4372: ,pa_proj_element_versions ppv5
4939: ,pa_task_types tt
4940: ,pa_project_statuses pps3
4941: ,pa_page_layouts ppl
4942: ,pa_progress_rollup ppru
4943: -----,pa_percent_completes ppc
4944: ,pa_project_statuses pps
4945: ,pa_project_statuses pps5
4946: ,pa_proj_elements ppe5
4947: ,pa_proj_element_versions ppv5
5058: --Bug 11868236(replaced the code fixed on bug 5580992 so subtasks get updated) start
5059:
5060: --Bug 5580992. This block will select the progress comment/description from pa_process_completes
5061: --update the same in PA_STRUCTURES_TASKS_TMP. This is done to remove the reference to
5062: --pa_percent_completes in above select and hence improve its performance. Please refer to bug
5063: --for more details.
5064: l_rowid_tbl.delete;
5065: l_pc_tbl.delete;
5066: l_desc_tbl.delete;
5073: l_tmp_pc := NULL;
5074: l_tmp_desc := NULL;
5075: SELECT ppc.progress_comment ,ppc.description
5076: INTO l_tmp_pc ,l_tmp_desc
5077: FROM pa_percent_completes ppc
5078: WHERE ppc.project_id=rec.project_id
5079: AND ppc.object_id = rec.proj_element_id
5080: AND ppc.object_type = 'PA_TASKS'
5081: AND ppc.date_computed = rec.as_of_date
5970: ,pa_task_types tt
5971: ,pa_project_statuses pps3
5972: ,pa_page_layouts ppl
5973: ,pa_progress_rollup ppru
5974: -----,pa_percent_completes ppc
5975: ,pa_project_statuses pps
5976: ,pa_project_statuses pps5
5977: ,pa_proj_elements ppe5
5978: ,pa_proj_element_versions ppv5
6796: ,pa_task_types tt
6797: ,pa_project_statuses pps3
6798: ,pa_page_layouts ppl
6799: ,pa_progress_rollup ppru
6800: -----,pa_percent_completes ppc
6801: ,pa_project_statuses pps
6802: ,pa_project_statuses pps5
6803: ,pa_proj_elements ppe5
6804: ,pa_proj_element_versions ppv5
7623: ,pa_task_types tt
7624: ,pa_project_statuses pps3
7625: ,pa_page_layouts ppl
7626: ,pa_progress_rollup ppru
7627: -----,pa_percent_completes ppc
7628: ,pa_project_statuses pps
7629: ,pa_project_statuses pps5
7630: ,pa_proj_elements ppe5
7631: ,pa_proj_element_versions ppv5
8567: ,pa_proj_element_versions ppv1
8568: ,pa_object_relationships por
8569: ,pa_object_relationships por2
8570: ,pji_fm_xbs_accum_tmp1 pfxat
8571: ----,pa_percent_completes ppc
8572: ,pa_progress_rollup ppru
8573: ,pa_proj_progress_attr pppa
8574: where
8575: por.object_id_from1 in ( SELECT ppevs.element_version_id
9058: ,pa_proj_element_versions ppv1
9059: ,pa_object_relationships por
9060: ,pa_object_relationships por2
9061: ,pji_fm_xbs_accum_tmp1 pfxat
9062: ----,pa_percent_completes ppc
9063: ,pa_progress_rollup ppru
9064: ,pa_proj_progress_attr pppa
9065: where
9066: por.object_id_from1 in ( SELECT ppevs.element_version_id
9566: ,pa_proj_element_versions ppv1
9567: ,pa_object_relationships por
9568: ,pa_object_relationships por2
9569: ,pji_fm_xbs_accum_tmp1 pfxat
9570: ----,pa_percent_completes ppc
9571: ,pa_progress_rollup ppru
9572: ,pa_proj_progress_attr pppa
9573: where
9574: por.object_id_from1 in ( SELECT ppevs.element_version_id
10394: ,pa_task_types tt
10395: ,pa_project_statuses pps3
10396: ,pa_page_layouts ppl
10397: ,pa_progress_rollup ppru
10398: ----,pa_percent_completes ppc
10399: ,pa_project_statuses pps
10400: ,pa_project_statuses pps5
10401: ,pa_proj_elements ppe5
10402: ,pa_proj_element_versions ppv5
11154: ,pa_task_types tt
11155: ,pa_project_statuses pps3
11156: ,pa_page_layouts ppl
11157: ,pa_progress_rollup ppru
11158: ----,pa_percent_completes ppc
11159: ,pa_project_statuses pps
11160: ,pa_project_statuses pps5
11161: ,pa_proj_elements ppe5
11162: ,pa_proj_element_versions ppv5
12110: ,pa_lookups lu1
12111: ,pa_work_types_tl pwt
12112: ,pa_progress_rollup ppru
12113: ,pa_project_statuses pps
12114: ----,pa_percent_completes ppc
12115: ,pa_project_statuses pps5
12116: ,pa_task_types tt
12117: ,pa_tasks pt
12118: ,pa_proj_elements ppe
12938: ,pa_lookups lu1
12939: ,pa_work_types_tl pwt
12940: ,pa_progress_rollup ppru
12941: ,pa_project_statuses pps
12942: ----,pa_percent_completes ppc
12943: ,pa_project_statuses pps5
12944: ,pa_task_types tt
12945: ,pa_tasks pt
12946: ,pa_proj_elements ppe
13767: ,pa_lookups lu1
13768: ,pa_work_types_tl pwt
13769: ,pa_progress_rollup ppru
13770: ,pa_project_statuses pps
13771: ----,pa_percent_completes ppc
13772: ,pa_project_statuses pps5
13773: ,pa_task_types tt
13774: ,pa_tasks pt
13775: ,pa_proj_elements ppe
14692: ,pa_lookups lu1
14693: ,pa_work_types_tl pwt
14694: ,pa_progress_rollup ppru
14695: ,pa_project_statuses pps
14696: ----,pa_percent_completes ppc
14697: ,pa_project_statuses pps5
14698: ,pa_task_types tt
14699: ,pa_tasks pt
14700: ,pa_proj_elements ppe
15489: ,pa_lookups lu1
15490: ,pa_work_types_tl pwt
15491: ,pa_progress_rollup ppru
15492: ,pa_project_statuses pps
15493: ----,pa_percent_completes ppc
15494: ,pa_project_statuses pps5
15495: ,pa_task_types tt
15496: ,pa_tasks pt
15497: ,pa_proj_elements ppe
16287: ,pa_lookups lu1
16288: ,pa_work_types_tl pwt
16289: ,pa_progress_rollup ppru
16290: ,pa_project_statuses pps
16291: ----,pa_percent_completes ppc
16292: ,pa_project_statuses pps5
16293: ,pa_task_types tt
16294: ,pa_tasks pt
16295: ,pa_proj_elements ppe