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_XC_PROJECT_PUB dependencies on PA_PROJ_ELEMENTS

Line 24: -- 22-Jul-2004 - dthakker 3693934 Changed pa_proj_elements_csr cursor for performance fix

20: -- check_ref_unique
21: -- For Procedure fetch_task_idchanged parameter p_task_index type to VARCHAR2
22: -- from NUMBER. Changed the logic for populating task reference. It is now
23: -- used as VARCHAR2 instead of number. All changes are tagged by bug no.3302732
24: -- 22-Jul-2004 - dthakker 3693934 Changed pa_proj_elements_csr cursor for performance fix
25: -- Changed pa_schedule_dates_csr cursor for performance fix
26: -- Commented l_get_working_version_csr existing cursor definition and added new definition
27: -- for the same
28: -- 23-JUL-04 adarora Bug 3627124 :

Line 115: -- Retrieve tasks from PA_PROJ_ELEMENTS table

111: SELECT PROJECT_ID
112: FROM PA_TEMP_IMPORT_TASKS
113: WHERE PROJECT_ID = c_project_id;
114:
115: -- Retrieve tasks from PA_PROJ_ELEMENTS table
116: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
117: IS
118: SELECT ppe.proj_element_id, ppe.name, ppe.element_number, ppe.description, ppe.pm_source_reference, ppe.manager_person_id, ppe.carrying_out_organization_id
119: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

Line 116: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)

112: FROM PA_TEMP_IMPORT_TASKS
113: WHERE PROJECT_ID = c_project_id;
114:
115: -- Retrieve tasks from PA_PROJ_ELEMENTS table
116: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
117: IS
118: SELECT ppe.proj_element_id, ppe.name, ppe.element_number, ppe.description, ppe.pm_source_reference, ppe.manager_person_id, ppe.carrying_out_organization_id
119: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
120: WHERE ppe.project_id = c_project_id

Line 119: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

115: -- Retrieve tasks from PA_PROJ_ELEMENTS table
116: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
117: IS
118: SELECT ppe.proj_element_id, ppe.name, ppe.element_number, ppe.description, ppe.pm_source_reference, ppe.manager_person_id, ppe.carrying_out_organization_id
119: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
120: WHERE ppe.project_id = c_project_id
121: AND ppe.project_id = ppev.project_id -- 3693934 added for peformance fix
122: AND ppe.object_type = 'PA_TASKS'
123: AND ppe.proj_element_id = ppev.proj_element_id

Line 128: l_proj_elements_rec pa_proj_elements_csr%ROWTYPE;

124: AND ppev.parent_structure_version_id = c_structure_version_id
125: AND ppev.financial_task_flag = 'Y'
126: ORDER BY ppev.display_sequence;
127:
128: l_proj_elements_rec pa_proj_elements_csr%ROWTYPE;
129:
130: -- Retrieve task Scheduled Start and Scheduled End Date from PA_PROJ_ELEM_VER_SCHEDULE table
131: CURSOR pa_schedule_dates_csr (c_structure_version_id NUMBER, c_proj_element_id NUMBER)
132: IS

Line 175: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

171: --hsiu added
172: --Bug 3302732: Commenting this cursor.
173: /*cursor l_pm_source_ref(c_structure_version_id NUMBER, c_project_id NUMBER) IS
174: select min(to_Number(ppe.pm_source_reference))
175: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
176: WHERE ppe.project_id = c_project_id
177: AND ppe.object_type = 'PA_TASKS'
178: AND ppe.proj_element_id = ppev.proj_element_id
179: AND ppev.parent_structure_version_id = c_structure_version_id; */

Line 254: -- Fetch task info from PA_PROJ_ELEMENTS table

250:
251: l_stage := '3';
252: l_counter :=0;
253:
254: -- Fetch task info from PA_PROJ_ELEMENTS table
255:
256: OPEN PA_PROJ_ELEMENTS_CSR(p_structure_version_id, p_project_id);
257: LOOP
258:

Line 256: OPEN PA_PROJ_ELEMENTS_CSR(p_structure_version_id, p_project_id);

252: l_counter :=0;
253:
254: -- Fetch task info from PA_PROJ_ELEMENTS table
255:
256: OPEN PA_PROJ_ELEMENTS_CSR(p_structure_version_id, p_project_id);
257: LOOP
258:
259: FETCH PA_PROJ_ELEMENTS_CSR INTO l_proj_elements_rec;
260: EXIT WHEN PA_PROJ_ELEMENTS_CSR%NOTFOUND;

Line 259: FETCH PA_PROJ_ELEMENTS_CSR INTO l_proj_elements_rec;

255:
256: OPEN PA_PROJ_ELEMENTS_CSR(p_structure_version_id, p_project_id);
257: LOOP
258:
259: FETCH PA_PROJ_ELEMENTS_CSR INTO l_proj_elements_rec;
260: EXIT WHEN PA_PROJ_ELEMENTS_CSR%NOTFOUND;
261:
262: l_counter := l_counter+1;
263: l_stage := '3.1 Loop '||to_char(l_counter);

Line 260: EXIT WHEN PA_PROJ_ELEMENTS_CSR%NOTFOUND;

256: OPEN PA_PROJ_ELEMENTS_CSR(p_structure_version_id, p_project_id);
257: LOOP
258:
259: FETCH PA_PROJ_ELEMENTS_CSR INTO l_proj_elements_rec;
260: EXIT WHEN PA_PROJ_ELEMENTS_CSR%NOTFOUND;
261:
262: l_counter := l_counter+1;
263: l_stage := '3.1 Loop '||to_char(l_counter);
264:

Line 293: update pa_proj_elements

289: update pa_tasks
290: set pm_task_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
291: where task_id = l_exist_pa_task_id;
292:
293: update pa_proj_elements
294: set pm_source_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
295: where proj_element_id = l_exist_pa_task_id;
296:
297: END IF;

Line 363: -- note that we are populating with the proj_element_id from PA_PROJ_ELEMENTS,

359:
360: l_stage := '3.6';
361:
362: -- populate the temp table
363: -- note that we are populating with the proj_element_id from PA_PROJ_ELEMENTS,
364: -- not the task_id from fetch_task_id
365: -- this is because fetch_task_id will only return those task ids in PA_TASKS, but
366: -- we need the proj_element_id to sync up with the task ids created by AMG later
367:

Line 417: CLOSE PA_PROJ_ELEMENTS_CSR;

413:
414: END LOOP;
415: --hyau
416:
417: CLOSE PA_PROJ_ELEMENTS_CSR;
418:
419: l_stage := '4';
420:
421: end if; -- calling_mode

Line 612: FROM pa_proj_elements

608: -- cursor to get the number of structures in a project
609: CURSOR l_get_structure_count_csr(c_project_id NUMBER)
610: IS
611: SELECT count(proj_element_id)
612: FROM pa_proj_elements
613: WHERE project_id = c_project_id
614: and object_type = 'PA_STRUCTURES'
615: GROUP BY proj_element_id;
616:

Line 621: FROM pa_proj_elements

617: -- cursor to get the number of structures in a project
618: CURSOR l_get_structure_id_csr(c_project_id NUMBER)
619: IS
620: SELECT proj_element_id
621: FROM pa_proj_elements
622: WHERE project_id = c_project_id
623: and object_type = 'PA_STRUCTURES';
624:
625: -- 3693934 for performance bug fix commented below cursor definition

Line 643: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs

639:
640: CURSOR l_get_working_version_csr(c_structure_id NUMBER)
641: IS
642: SELECT ppevs.element_version_id
643: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs
644: WHERE ppev.proj_element_id = c_structure_id
645: AND ppev.project_id = ppevs.project_id
646: AND ppev.proj_element_id = ppevs.proj_element_id
647: AND ppevs.published_date is null;

Line 670: FROM pa_proj_elements

666: -- HY check for valid project id, structure id combination.
667: CURSOR l_check_proj_struct_id_csr(c_project_id NUMBER, c_structure_id NUMBER)
668: IS
669: SELECT 'Y'
670: FROM pa_proj_elements
671: WHERE project_id = c_project_id
672: and proj_element_id = c_structure_id;
673:
674: -- HY check for valid project id, structure version id combination.

Line 984: -- Sync pa_proj_elements with pa_tasks

980: */
981:
982: if p_calling_mode = 'PUBLISH' then
983:
984: -- Sync pa_proj_elements with pa_tasks
985:
986: -- get the values associated to the project_id
987:
988: OPEN l_get_project_csr(p_project_id);

Line 1138: -- as the tasks in pa_proj_elements

1134: and b.task_id = pt.top_task_id)
1135: where pt.project_id = p_project_id;
1136:
1137: -- Need to update pa_tasks so that the newly created financial task have the same task_id
1138: -- as the tasks in pa_proj_elements
1139: UPDATE PA_TASKS pt
1140: SET pt.task_id =
1141: (select task_id
1142: from PA_TEMP_IMPORT_TASKS temp

Line 1147: UPDATE PA_PROJ_ELEMENTS e

1143: where temp.project_id = p_project_id
1144: and temp.task_reference = pt.pm_task_reference)
1145: WHERE pt.project_id = p_project_id;
1146:
1147: UPDATE PA_PROJ_ELEMENTS e
1148: set e.pm_source_reference = (
1149: select PM_TASK_REFERENCE
1150: from PA_TASKS t
1151: where t.task_id = e.proj_element_id

Line 1379: FROM pa_proj_elements

1375:
1376: CURSOR l_get_task_csr (c_project_id NUMBER, c_pm_task_reference VARCHAR2)
1377: IS
1378: SELECT proj_element_id
1379: FROM pa_proj_elements
1380: WHERE project_id = c_project_id
1381: AND pm_source_reference = c_pm_task_reference;
1382:
1383: BEGIN

Line 1476: from pa_proj_elements

1472:
1473: BEGIN
1474: /* Bug 7615805
1475: select 'N' into l_unique
1476: from pa_proj_elements
1477: where project_id = p_project_id
1478: and pm_source_reference = p_new_task_reference
1479: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug# 3601700
1480: FROM pa_proj_elements ppe,

Line 1480: FROM pa_proj_elements ppe,

1476: from pa_proj_elements
1477: where project_id = p_project_id
1478: and pm_source_reference = p_new_task_reference
1479: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug# 3601700
1480: FROM pa_proj_elements ppe,
1481: pa_proj_structure_types ppst,
1482: pa_structure_types pst
1483: WHERE ppe.proj_element_id = ppst.proj_element_id
1484: AND ppe.project_id = p_project_id

Line 1494: -- If the PA_PROJ_ELEMENTS is having multiple records for

1490:
1491: ---------------------------------------------------------------
1492: -- The above query is commented out as it can throw
1493: -- ORA-01422: exact fetch returns more than requested number of rows
1494: -- If the PA_PROJ_ELEMENTS is having multiple records for
1495: -- same PM_SOURCE_REFERENCE or same PARENT_STRUCTURE_ID
1496: ---------------------------------------------------------------
1497: -- Bug # 7615805
1498: SELECT COUNT(*)

Line 1500: FROM PA_PROJ_ELEMENTS

1496: ---------------------------------------------------------------
1497: -- Bug # 7615805
1498: SELECT COUNT(*)
1499: INTO L_COUNT
1500: FROM PA_PROJ_ELEMENTS
1501: WHERE PROJECT_ID = P_PROJECT_ID
1502: AND PM_SOURCE_REFERENCE = P_NEW_TASK_REFERENCE
1503: AND PARENT_STRUCTURE_ID = ( SELECT PPE.PROJ_ELEMENT_ID
1504: FROM PA_PROJ_ELEMENTS PPE,

Line 1504: FROM PA_PROJ_ELEMENTS PPE,

1500: FROM PA_PROJ_ELEMENTS
1501: WHERE PROJECT_ID = P_PROJECT_ID
1502: AND PM_SOURCE_REFERENCE = P_NEW_TASK_REFERENCE
1503: AND PARENT_STRUCTURE_ID = ( SELECT PPE.PROJ_ELEMENT_ID
1504: FROM PA_PROJ_ELEMENTS PPE,
1505: PA_PROJ_STRUCTURE_TYPES PPST,
1506: PA_STRUCTURE_TYPES PST
1507: WHERE PPE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
1508: AND PPE.PROJECT_ID = P_PROJECT_ID