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 1625: INSERT INTO pa_structures_tasks_tmp

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: (
1627: parent_project_id
1628: , element_Number
1629: , element_Name

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

2430: AND ppv.parent_structure_version_id = p_structure_version_id
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;

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

2437: l_rowid_tbl.delete;
2438: l_pc_tbl.delete;
2439: l_desc_tbl.delete;
2440: rec_count :=0;
2441: FOR rec IN (SELECT rowid, project_id, proj_element_id, as_of_date FROM PA_STRUCTURES_TASKS_TMP) LOOP
2442:
2443:
2444: BEGIN
2445:

Line 2473: UPDATE PA_STRUCTURES_TASKS_TMP

2469: END LOOP;
2470:
2471: FORALL zz IN 1..l_rowid_tbl.COUNT
2472:
2473: UPDATE PA_STRUCTURES_TASKS_TMP
2474: SET Progress_comments =l_pc_tbl(zz)
2475: ,Progress_brief_overview =l_desc_tbl(zz)
2476: WHERE rowid=l_rowid_tbl(zz);
2477:

Line 2479: --in PA_STRUCTURES_TASKS_TMP

2475: ,Progress_brief_overview =l_desc_tbl(zz)
2476: WHERE rowid=l_rowid_tbl(zz);
2477:
2478: --Bug 5580992. End of changes for stamping Progress_comments and Progress_brief_overview
2479: --in PA_STRUCTURES_TASKS_TMP
2480:
2481:
2482: -- ************************************************************************************************************************
2483: -- if p_task_version_id is passed in, populate all the immediate child task records for the given task version.

Line 2488: INSERT INTO pa_structures_tasks_tmp

2484: -- ************************************************************************************************************************
2485:
2486: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
2487:
2488: INSERT INTO pa_structures_tasks_tmp
2489: (
2490: parent_project_id
2491: , element_Number
2492: , element_Name

Line 3308: UPDATE pa_structures_tasks_tmp

3304:
3305:
3306: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
3307:
3308: UPDATE pa_structures_tasks_tmp
3309: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
3310: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
3311: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
3312: ETC_Cost =null

Line 3427: INSERT INTO pa_structures_tasks_tmp

3423: -- ************************************************************************************************************************
3424:
3425: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
3426:
3427: INSERT INTO pa_structures_tasks_tmp
3428: (
3429: parent_project_id
3430: , element_Number
3431: , element_Name

Line 4252: INSERT INTO pa_structures_tasks_tmp

4248: -- ************************************************************************************************************************
4249:
4250: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
4251:
4252: INSERT INTO pa_structures_tasks_tmp
4253: (
4254: parent_project_id
4255: , element_Number
4256: , element_Name

Line 5078: INSERT INTO pa_structures_tasks_tmp

5074: -- ************************************************************************************************************************
5075:
5076: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
5077:
5078: INSERT INTO pa_structures_tasks_tmp
5079: (
5080: parent_project_id
5081: , element_Number
5082: , element_Name

Line 5914: UPDATE pa_structures_tasks_tmp

5910: */
5911:
5912: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
5913:
5914: UPDATE pa_structures_tasks_tmp
5915: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
5916: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
5917: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
5918: ETC_Cost =null

Line 6000: FROM pa_structures_tasks_tmp a,

5996:
5997: CURSOR cur_get_parent_disp( c_subproject_id NUMBER, c_subproj_struc_ver_id NUMBER )
5998: IS
5999: SELECT a.display_sequence
6000: FROM pa_structures_tasks_tmp a,
6001: pa_object_relationships b
6002: WHERE b.object_id_to1=c_subproj_struc_ver_id
6003: AND b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
6004: AND b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 6068: delete from pa_structures_tasks_tmp pstt

6064: -- the user navigates between the parent projects, this fix serves to remove the sub-project
6065: -- records populated in the context of the previously accessed parent project, because they are
6066: -- re-populated in the context of the currently accessed parent project.
6067:
6068: delete from pa_structures_tasks_tmp pstt
6069: where pstt.project_id in (select por1.object_id_to2
6070: from pa_object_relationships por1
6071: ,pa_proj_element_versions ppv
6072: where por1.relationship_type = 'LW'

Line 6095: INSERT INTO pa_structures_tasks_tmp

6091: -- End of Bug Fix 5609629
6092:
6093:
6094: -- bug 4416432: insert working structures
6095: INSERT INTO pa_structures_tasks_tmp
6096: (
6097: parent_project_id
6098: , element_Number
6099: , element_Name

Line 7334: Update pa_structures_tasks_tmp

7330: --move the sub-project record rowcount places ahead. This is required if there are multiple sub-projects originating
7331: --from the same linked task.
7332:
7333: --update the structure record with the global_sequnece
7334: Update pa_structures_tasks_tmp
7335: set display_sequence = global_sequence_number
7336: where element_version_id = l_struc_ver_id
7337: and project_id= l_project_id
7338: ;

Line 7372: UPDATE pa_structures_tasks_tmp

7368: /* IF p_calling_page_name = 'GANTT_REGION'
7369: THEN
7370:
7371: --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.
7372: UPDATE pa_structures_tasks_tmp
7373: SET display_sequence = display_sequence + global_sequence_number + global_sub_proj_task_count
7374: WHERE project_id = l_immediate_parent_proj_id
7375: AND display_sequence > l_sub_proj_str_disp_seq
7376: AND element_version_id <> l_struc_ver_id;

Line 7380: from pa_structures_tasks_tmp

7376: AND element_version_id <> l_struc_ver_id;
7377:
7378: --Move the next sub-proj structure after the last task of previous sub-proj structure is inserted
7379: select max(display_sequence) + 1 into global_sequence_number
7380: from pa_structures_tasks_tmp
7381: where project_id = l_immediate_parent_proj_id;
7382: END IF; */ --bug 7434683
7383: --bug 4448499
7384:

Line 7485: INSERT INTO pa_structures_tasks_tmp

7481: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
7482: -- End of Bug Fix 5609629
7483:
7484: --Populate published versions records first.
7485: INSERT INTO pa_structures_tasks_tmp
7486: (
7487: parent_project_id
7488: , element_Number
7489: , element_Name

Line 8245: INSERT INTO pa_structures_tasks_tmp

8241: l_versioning_enabled_flag := pa_workplan_attr_utils.check_wp_versioning_enabled(p_project_id);
8242: -- End of Bug Fix 5609629
8243:
8244:
8245: INSERT INTO pa_structures_tasks_tmp
8246: (
8247: parent_project_id
8248: , element_Number
8249: , element_Name

Line 9034: INSERT INTO pa_structures_tasks_tmp

9030:
9031:
9032: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
9033:
9034: INSERT INTO pa_structures_tasks_tmp
9035: (
9036: parent_project_id
9037: , element_Number
9038: , element_Name

Line 9861: INSERT INTO pa_structures_tasks_tmp

9857: -- ************************************************************************************************************************
9858:
9859: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
9860:
9861: INSERT INTO pa_structures_tasks_tmp
9862: (
9863: parent_project_id
9864: , element_Number
9865: , element_Name

Line 10689: INSERT INTO pa_structures_tasks_tmp

10685: -- ************************************************************************************************************************
10686:
10687: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
10688:
10689: INSERT INTO pa_structures_tasks_tmp
10690: (
10691: parent_project_id
10692: , element_Number
10693: , element_Name

Line 11517: UPDATE pa_structures_tasks_tmp

11513: -- Bug # 4875311.
11514:
11515: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
11516:
11517: UPDATE pa_structures_tasks_tmp
11518: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
11519: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
11520: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
11521: ETC_Cost =null

Line 11648: INSERT INTO pa_structures_tasks_tmp

11644:
11645:
11646: if ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and (p_wbs_display_depth = -1)) then
11647:
11648: INSERT INTO pa_structures_tasks_tmp
11649: (
11650: parent_project_id
11651: , element_Number
11652: , element_Name

Line 12444: INSERT INTO pa_structures_tasks_tmp

12440: -- ************************************************************************************************************************
12441:
12442: elsif ((p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) and ( p_wbs_display_depth <> -1)) then
12443:
12444: INSERT INTO pa_structures_tasks_tmp
12445: (
12446: parent_project_id
12447: , element_Number
12448: , element_Name

Line 13241: INSERT INTO pa_structures_tasks_tmp

13237: -- ************************************************************************************************************************
13238:
13239: elsif (p_task_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
13240:
13241: INSERT INTO pa_structures_tasks_tmp
13242: (
13243: parent_project_id
13244: , element_Number
13245: , element_Name

Line 14038: UPDATE pa_structures_tasks_tmp

14034: -- Bug # 4875311.
14035:
14036: IF pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id) <> 'Y' THEN
14037:
14038: UPDATE pa_structures_tasks_tmp
14039: set raw_cost = null,burdened_cost=null,planned_cost=null,Percent_Spent_Cost=null,Percent_Complete_Cost=null,
14040: Actual_Cost = null,Baseline_Cost=null,Estimate_At_Completion_Cost=null,
14041: Planned_Cost_Per_Unit=null,Actual_Cost_Per_Unit=null,Variance_At_Completion_Cost=null,
14042: ETC_Cost =null