[Home] [Help]
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:
1514: ,pa_task_types tt
1515: ,pa_project_statuses pps3
1516: ,pa_page_layouts ppl
1517: ,pa_progress_rollup ppru
1518: -----,pa_percent_completes ppc
1519: ,pa_project_statuses pps
1520: ,pa_project_statuses pps5
1521: ,pa_proj_elements ppe5
1522: ,pa_proj_element_versions ppv5
1618: -- if p_structure_version_id and p_wbs_display_depth are passed in, populate all task records for the structure version until the depth.
1619: -- ************************************************************************************************************************
1620:
1621: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
1622: --Bug 5580992: Removed the reference to pa_percent_completes. The columns Progress_comments and
1623: --Progress_brief_overview are updated after this insert.
1624:
1625: INSERT INTO pa_structures_tasks_tmp
1626: (
2329: ,pa_task_types tt
2330: ,pa_project_statuses pps3
2331: ,pa_page_layouts ppl
2332: ,pa_progress_rollup ppru
2333: -----,pa_percent_completes ppc Bug 5580992
2334: ,pa_project_statuses pps
2335: ,pa_project_statuses pps5
2336: ,pa_proj_elements ppe5
2337: ,pa_proj_element_versions ppv5
2431: and ppv.wbs_level <= p_wbs_display_depth;
2432:
2433: --Bug 5580992. This block will select the progress comment/description from pa_process_completes
2434: --update the same in PA_STRUCTURES_TASKS_TMP. This is done to remove the reference to
2435: --pa_percent_completes in above select and hence improve its performance. Please refer to bug
2436: --for more details.
2437: l_rowid_tbl.delete;
2438: l_pc_tbl.delete;
2439: l_desc_tbl.delete;
2446: l_tmp_pc := NULL;
2447: l_tmp_desc := NULL;
2448: SELECT ppc.progress_comment ,ppc.description
2449: INTO l_tmp_pc ,l_tmp_desc
2450: FROM pa_percent_completes ppc
2451: WHERE ppc.project_id=rec.project_id
2452: AND ppc.object_id = rec.proj_element_id
2453: AND ppc.object_type = 'PA_TASKS'
2454: AND ppc.date_computed = rec.as_of_date
3187: ,pa_task_types tt
3188: ,pa_project_statuses pps3
3189: ,pa_page_layouts ppl
3190: ,pa_progress_rollup ppru
3191: -----,pa_percent_completes ppc
3192: ,pa_project_statuses pps
3193: ,pa_project_statuses pps5
3194: ,pa_proj_elements ppe5
3195: ,pa_proj_element_versions ppv5
4158: ,pa_task_types tt
4159: ,pa_project_statuses pps3
4160: ,pa_page_layouts ppl
4161: ,pa_progress_rollup ppru
4162: -----,pa_percent_completes ppc
4163: ,pa_project_statuses pps
4164: ,pa_project_statuses pps5
4165: ,pa_proj_elements ppe5
4166: ,pa_proj_element_versions ppv5
4983: ,pa_task_types tt
4984: ,pa_project_statuses pps3
4985: ,pa_page_layouts ppl
4986: ,pa_progress_rollup ppru
4987: -----,pa_percent_completes ppc
4988: ,pa_project_statuses pps
4989: ,pa_project_statuses pps5
4990: ,pa_proj_elements ppe5
4991: ,pa_proj_element_versions ppv5
5809: ,pa_task_types tt
5810: ,pa_project_statuses pps3
5811: ,pa_page_layouts ppl
5812: ,pa_progress_rollup ppru
5813: -----,pa_percent_completes ppc
5814: ,pa_project_statuses pps
5815: ,pa_project_statuses pps5
5816: ,pa_proj_elements ppe5
5817: ,pa_proj_element_versions ppv5
6752: ,pa_proj_element_versions ppv1
6753: ,pa_object_relationships por
6754: ,pa_object_relationships por2
6755: ,pji_fm_xbs_accum_tmp1 pfxat
6756: ----,pa_percent_completes ppc
6757: ,pa_progress_rollup ppru
6758: ,pa_proj_progress_attr pppa
6759: where
6760: por.object_id_from1 in ( SELECT ppevs.element_version_id
7242: ,pa_proj_element_versions ppv1
7243: ,pa_object_relationships por
7244: ,pa_object_relationships por2
7245: ,pji_fm_xbs_accum_tmp1 pfxat
7246: ----,pa_percent_completes ppc
7247: ,pa_progress_rollup ppru
7248: ,pa_proj_progress_attr pppa
7249: where
7250: por.object_id_from1 in ( SELECT ppevs.element_version_id
8064: ,pa_task_types tt
8065: ,pa_project_statuses pps3
8066: ,pa_page_layouts ppl
8067: ,pa_progress_rollup ppru
8068: ----,pa_percent_completes ppc
8069: ,pa_project_statuses pps
8070: ,pa_project_statuses pps5
8071: ,pa_proj_elements ppe5
8072: ,pa_proj_element_versions ppv5
8824: ,pa_task_types tt
8825: ,pa_project_statuses pps3
8826: ,pa_page_layouts ppl
8827: ,pa_progress_rollup ppru
8828: ----,pa_percent_completes ppc
8829: ,pa_project_statuses pps
8830: ,pa_project_statuses pps5
8831: ,pa_proj_elements ppe5
8832: ,pa_proj_element_versions ppv5
9779: ,pa_lookups lu1
9780: ,pa_work_types_tl pwt
9781: ,pa_progress_rollup ppru
9782: ,pa_project_statuses pps
9783: ----,pa_percent_completes ppc
9784: ,pa_project_statuses pps5
9785: ,pa_task_types tt
9786: ,pa_tasks pt
9787: ,pa_proj_elements ppe
10606: ,pa_lookups lu1
10607: ,pa_work_types_tl pwt
10608: ,pa_progress_rollup ppru
10609: ,pa_project_statuses pps
10610: ----,pa_percent_completes ppc
10611: ,pa_project_statuses pps5
10612: ,pa_task_types tt
10613: ,pa_tasks pt
10614: ,pa_proj_elements ppe
11434: ,pa_lookups lu1
11435: ,pa_work_types_tl pwt
11436: ,pa_progress_rollup ppru
11437: ,pa_project_statuses pps
11438: ----,pa_percent_completes ppc
11439: ,pa_project_statuses pps5
11440: ,pa_task_types tt
11441: ,pa_tasks pt
11442: ,pa_proj_elements ppe
12358: ,pa_lookups lu1
12359: ,pa_work_types_tl pwt
12360: ,pa_progress_rollup ppru
12361: ,pa_project_statuses pps
12362: ----,pa_percent_completes ppc
12363: ,pa_project_statuses pps5
12364: ,pa_task_types tt
12365: ,pa_tasks pt
12366: ,pa_proj_elements ppe
13154: ,pa_lookups lu1
13155: ,pa_work_types_tl pwt
13156: ,pa_progress_rollup ppru
13157: ,pa_project_statuses pps
13158: ----,pa_percent_completes ppc
13159: ,pa_project_statuses pps5
13160: ,pa_task_types tt
13161: ,pa_tasks pt
13162: ,pa_proj_elements ppe
13951: ,pa_lookups lu1
13952: ,pa_work_types_tl pwt
13953: ,pa_progress_rollup ppru
13954: ,pa_project_statuses pps
13955: ----,pa_percent_completes ppc
13956: ,pa_project_statuses pps5
13957: ,pa_task_types tt
13958: ,pa_tasks pt
13959: ,pa_proj_elements ppe