eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_STRUCTURES_TASKS_TMP

Line 301: -- delete from pa_structures_tasks_tmp where parent_project_id = p_project_id;

297: -- Begin fix for Bug # 4485192.
298:
299: -- first delete from the temp table
300:
301: -- delete from pa_structures_tasks_tmp where parent_project_id = p_project_id;
302:
303: -- If this API is being called for the parent project then delete all the parent projects records
304: -- from the table: pa_structures_tasks_tmp before re-populating the records.
305:

Line 304: -- from the table: pa_structures_tasks_tmp before re-populating the records.

300:
301: -- delete from pa_structures_tasks_tmp where parent_project_id = p_project_id;
302:
303: -- If this API is being called for the parent project then delete all the parent projects records
304: -- from the table: pa_structures_tasks_tmp before re-populating the records.
305:
306: -- Bug # 4875311.
307:
308: if ((l_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 313: delete from pa_structures_tasks_tmp pstt

309: and (l_program_flag = 'N') --Bug # 4875311.
310: and (p_calling_page_name <> 'TASK_DETAILS')) -- Bug # 4875311.
311: then
312:
313: delete from pa_structures_tasks_tmp pstt
314: where pstt.parent_structure_version_id = p_structure_version_id
315: and pstt.parent_element_version_id = l_task_version_id;
316:
317: else

Line 323: delete from pa_structures_tasks_tmp where project_id = p_project_id;

319: -- Bug # 4875311.
320:
321: if (l_parent_project_id = p_project_id) then
322:
323: delete from pa_structures_tasks_tmp where project_id = p_project_id;
324:
325: delete from pa_structures_tasks_tmp where parent_project_id = p_project_id; -- Fix for Bug # 4540645.
326:
327: end if;

Line 325: delete from pa_structures_tasks_tmp where parent_project_id = p_project_id; -- Fix for Bug # 4540645.

321: if (l_parent_project_id = p_project_id) then
322:
323: delete from pa_structures_tasks_tmp where project_id = p_project_id;
324:
325: delete from pa_structures_tasks_tmp where parent_project_id = p_project_id; -- Fix for Bug # 4540645.
326:
327: end if;
328:
329: end if; -- Bug # 4875311.

Line 656: FROM pa_structures_tasks_tmp

652: SELECT NULL
653: FROM DUAL
654: WHERE EXISTS
655: (SELECT NULL
656: FROM pa_structures_tasks_tmp
657: WHERE proj_element_id IS NULL);
658:
659: CURSOR C2
660: IS

Line 675: pa_structures_tasks_tmp t1,

671: FROM DUAL
672: WHERE EXISTS
673: (SELECT 1
674: FROM pa_control_items pci,
675: pa_structures_tasks_tmp t1,
676: pa_ci_types_b pct
677: WHERE pci.project_id=t1.project_id
678: AND pci.ci_type_id=pct.ci_type_id
679: AND pct.ci_type_class_Code = c_ci_type);

Line 812: INSERT INTO pa_structures_tasks_tmp

808: -- End of Bug 6156686
809:
810: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
811:
812: INSERT INTO pa_structures_tasks_tmp
813: (
814: parent_project_id
815: , element_Number
816: , element_Name

Line 2209: INSERT INTO pa_structures_tasks_tmp

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: (
2211: parent_project_id
2212: , element_Number
2213: , element_Name

Line 3610: --update the same in PA_STRUCTURES_TASKS_TMP. This is done to remove the reference to

3606: * * is moved to the end of the procedure.
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;

Line 3617: FOR rec IN (SELECT rowid, project_id, proj_element_id, as_of_date FROM PA_STRUCTURES_TASKS_TMP) LOOP

3613: l_rowid_tbl.delete;
3614: l_pc_tbl.delete;
3615: l_desc_tbl.delete;
3616: rec_count :=0;
3617: FOR rec IN (SELECT rowid, project_id, proj_element_id, as_of_date FROM PA_STRUCTURES_TASKS_TMP) LOOP
3618:
3619:
3620: BEGIN
3621:

Line 3649: UPDATE PA_STRUCTURES_TASKS_TMP

3645: END LOOP;
3646:
3647: FORALL zz IN 1..l_rowid_tbl.COUNT
3648:
3649: UPDATE PA_STRUCTURES_TASKS_TMP
3650: SET Progress_comments =l_pc_tbl(zz)
3651: ,Progress_brief_overview =l_desc_tbl(zz)
3652: WHERE rowid=l_rowid_tbl(zz);
3653:

Line 3655: --in PA_STRUCTURES_TASKS_TMP

3651: ,Progress_brief_overview =l_desc_tbl(zz)
3652: WHERE rowid=l_rowid_tbl(zz);
3653:
3654: --Bug 5580992. End of changes for stamping Progress_comments and Progress_brief_overview
3655: --in PA_STRUCTURES_TASKS_TMP
3656: */
3657:
3658: -- ************************************************************************************************************************
3659: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.

Line 3664: INSERT INTO pa_structures_tasks_tmp

3660: -- ************************************************************************************************************************
3661:
3662: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
3663:
3664: INSERT INTO pa_structures_tasks_tmp
3665: (
3666: parent_project_id
3667: , element_Number
3668: , element_Name

Line 5061: --update the same in PA_STRUCTURES_TASKS_TMP. This is done to remove the reference to

5057:
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;

Line 5068: FOR rec IN (SELECT rowid, project_id, proj_element_id, as_of_date FROM PA_STRUCTURES_TASKS_TMP) LOOP

5064: l_rowid_tbl.delete;
5065: l_pc_tbl.delete;
5066: l_desc_tbl.delete;
5067: rec_count :=0;
5068: FOR rec IN (SELECT rowid, project_id, proj_element_id, as_of_date FROM PA_STRUCTURES_TASKS_TMP) LOOP
5069:
5070:
5071: BEGIN
5072:

Line 5101: UPDATE PA_STRUCTURES_TASKS_TMP

5097: END LOOP;
5098:
5099: FORALL zz IN 1..l_rowid_tbl.COUNT
5100:
5101: UPDATE PA_STRUCTURES_TASKS_TMP
5102: SET Progress_comments =l_pc_tbl(zz)
5103: ,Progress_brief_overview =l_desc_tbl(zz)
5104: WHERE rowid=l_rowid_tbl(zz);
5105:

Line 5107: --in PA_STRUCTURES_TASKS_TMP

5103: ,Progress_brief_overview =l_desc_tbl(zz)
5104: WHERE rowid=l_rowid_tbl(zz);
5105:
5106: --Bug 5580992. End of changes for stamping Progress_comments and Progress_brief_overview
5107: --in PA_STRUCTURES_TASKS_TMP
5108: --Bug 11868236(replaced the code fixed on bug 5580992 so subtasks get updated) end
5109:
5110:
5111:

Line 5119: UPDATE pa_structures_tasks_tmp

5115:
5116:
5117: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
5118:
5119: UPDATE pa_structures_tasks_tmp
5120: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
5121: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
5122: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
5123: ETC_Cost =null

Line 5238: INSERT INTO pa_structures_tasks_tmp

5234: -- ************************************************************************************************************************
5235:
5236: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
5237:
5238: INSERT INTO pa_structures_tasks_tmp
5239: (
5240: parent_project_id
5241: , element_Number
5242: , element_Name

Line 6064: INSERT INTO pa_structures_tasks_tmp

6060: -- ************************************************************************************************************************
6061:
6062: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
6063:
6064: INSERT INTO pa_structures_tasks_tmp
6065: (
6066: parent_project_id
6067: , element_Number
6068: , element_Name

Line 6891: INSERT INTO pa_structures_tasks_tmp

6887: -- ************************************************************************************************************************
6888:
6889: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
6890:
6891: INSERT INTO pa_structures_tasks_tmp
6892: (
6893: parent_project_id
6894: , element_Number
6895: , element_Name

Line 7728: UPDATE pa_structures_tasks_tmp

7724: */
7725:
7726: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
7727:
7728: UPDATE pa_structures_tasks_tmp
7729: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
7730: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
7731: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
7732: ETC_Cost =null

Line 7814: FROM pa_structures_tasks_tmp a,

7810:
7811: CURSOR cur_get_parent_disp( c_subproject_id NUMBER, c_subproj_struc_ver_id NUMBER )
7812: IS
7813: SELECT a.display_sequence
7814: FROM pa_structures_tasks_tmp a,
7815: pa_object_relationships b
7816: WHERE b.object_id_to1=c_subproj_struc_ver_id
7817: AND b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
7818: AND b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 7882: delete from pa_structures_tasks_tmp pstt

7878: -- the user navigates between the parent projects, this fix serves to remove the sub-project
7879: -- records populated in the context of the previously accessed parent project, because they are
7880: -- re-populated in the context of the currently accessed parent project.
7881:
7882: delete from pa_structures_tasks_tmp pstt
7883: where pstt.project_id in (select por1.object_id_to2
7884: from pa_object_relationships por1
7885: ,pa_proj_element_versions ppv
7886: where por1.relationship_type = 'LW'

Line 7909: INSERT INTO pa_structures_tasks_tmp

7905: -- End of Bug Fix 5609629
7906:
7907:
7908: -- bug 4416432: insert working structures
7909: INSERT INTO pa_structures_tasks_tmp
7910: (
7911: parent_project_id
7912: , element_Number
7913: , element_Name

Line 9664: Update pa_structures_tasks_tmp

9660: --move the sub-project record rowcount places ahead. This is required if there are multiple sub-projects originating
9661: --from the same linked task.
9662:
9663: --update the structure record with the global_sequnece
9664: Update pa_structures_tasks_tmp
9665: set display_sequence = global_sequence_number
9666: where element_version_id = l_struc_ver_id
9667: and project_id= l_project_id
9668: ;

Line 9702: UPDATE pa_structures_tasks_tmp

9698: /* IF p_calling_page_name = 'GANTT_REGION'
9699: THEN
9700:
9701: --Update all the tasks of the immediate parent project to move them relative to all sub-projects and their sub-tasks that were added before these tasks.
9702: UPDATE pa_structures_tasks_tmp
9703: SET display_sequence = display_sequence + global_sequence_number + global_sub_proj_task_count
9704: WHERE project_id = l_immediate_parent_proj_id
9705: AND display_sequence > l_sub_proj_str_disp_seq
9706: AND element_version_id <> l_struc_ver_id;

Line 9710: from pa_structures_tasks_tmp

9706: AND element_version_id <> l_struc_ver_id;
9707:
9708: --Move the next sub-proj structure after the last task of previous sub-proj structure is inserted
9709: select max(display_sequence) + 1 into global_sequence_number
9710: from pa_structures_tasks_tmp
9711: where project_id = l_immediate_parent_proj_id;
9712: END IF; */ --bug 7434683
9713: --bug 4448499
9714:

Line 9815: INSERT INTO pa_structures_tasks_tmp

9811: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
9812: -- End of Bug Fix 5609629
9813:
9814: --Populate published versions records first.
9815: INSERT INTO pa_structures_tasks_tmp
9816: (
9817: parent_project_id
9818: , element_Number
9819: , element_Name

Line 10575: INSERT INTO pa_structures_tasks_tmp

10571: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
10572: -- End of Bug Fix 5609629
10573:
10574:
10575: INSERT INTO pa_structures_tasks_tmp
10576: (
10577: parent_project_id
10578: , element_Number
10579: , element_Name

Line 11364: INSERT INTO pa_structures_tasks_tmp

11360:
11361:
11362: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
11363:
11364: INSERT INTO pa_structures_tasks_tmp
11365: (
11366: parent_project_id
11367: , element_Number
11368: , element_Name

Line 12192: INSERT INTO pa_structures_tasks_tmp

12188: -- ************************************************************************************************************************
12189:
12190: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
12191:
12192: INSERT INTO pa_structures_tasks_tmp
12193: (
12194: parent_project_id
12195: , element_Number
12196: , element_Name

Line 13021: INSERT INTO pa_structures_tasks_tmp

13017: -- ************************************************************************************************************************
13018:
13019: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
13020:
13021: INSERT INTO pa_structures_tasks_tmp
13022: (
13023: parent_project_id
13024: , element_Number
13025: , element_Name

Line 13850: UPDATE pa_structures_tasks_tmp

13846: -- Bug # 4875311.
13847:
13848: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
13849:
13850: UPDATE pa_structures_tasks_tmp
13851: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
13852: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
13853: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
13854: ETC_Cost =null

Line 13981: INSERT INTO pa_structures_tasks_tmp

13977:
13978:
13979: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
13980:
13981: INSERT INTO pa_structures_tasks_tmp
13982: (
13983: parent_project_id
13984: , element_Number
13985: , element_Name

Line 14778: INSERT INTO pa_structures_tasks_tmp

14774: -- ************************************************************************************************************************
14775:
14776: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
14777:
14778: INSERT INTO pa_structures_tasks_tmp
14779: (
14780: parent_project_id
14781: , element_Number
14782: , element_Name

Line 15576: INSERT INTO pa_structures_tasks_tmp

15572: -- ************************************************************************************************************************
15573:
15574: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
15575:
15576: INSERT INTO pa_structures_tasks_tmp
15577: (
15578: parent_project_id
15579: , element_Number
15580: , element_Name

Line 16374: UPDATE pa_structures_tasks_tmp

16370: -- Bug # 4875311.
16371:
16372: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
16373:
16374: UPDATE pa_structures_tasks_tmp
16375: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
16376: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
16377: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
16378: ETC_Cost =null