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 113: -- Retrieve tasks from PA_PROJ_ELEMENTS table

109: SELECT PROJECT_ID
110: FROM PA_TEMP_IMPORT_TASKS
111: WHERE PROJECT_ID = c_project_id;
112:
113: -- Retrieve tasks from PA_PROJ_ELEMENTS table
114: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
115: IS
116: 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
117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

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

110: FROM PA_TEMP_IMPORT_TASKS
111: WHERE PROJECT_ID = c_project_id;
112:
113: -- Retrieve tasks from PA_PROJ_ELEMENTS table
114: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
115: IS
116: 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
117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
118: WHERE ppe.project_id = c_project_id

Line 117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

113: -- Retrieve tasks from PA_PROJ_ELEMENTS table
114: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
115: IS
116: 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
117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
118: WHERE ppe.project_id = c_project_id
119: AND ppe.project_id = ppev.project_id -- 3693934 added for peformance fix
120: AND ppe.object_type = 'PA_TASKS'
121: AND ppe.proj_element_id = ppev.proj_element_id

Line 126: l_proj_elements_rec pa_proj_elements_csr%ROWTYPE;

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

Line 173: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

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

Line 252: -- Fetch task info from PA_PROJ_ELEMENTS table

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

Line 254: OPEN PA_PROJ_ELEMENTS_CSR(p_structure_version_id, p_project_id);

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

Line 257: FETCH PA_PROJ_ELEMENTS_CSR INTO l_proj_elements_rec;

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

Line 258: EXIT WHEN PA_PROJ_ELEMENTS_CSR%NOTFOUND;

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

Line 282: update pa_proj_elements

278: update pa_tasks
279: set pm_task_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
280: where task_id = l_exist_pa_task_id;
281:
282: update pa_proj_elements
283: set pm_source_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
284: where proj_element_id = l_exist_pa_task_id;
285:
286: END IF;

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

348:
349: l_stage := '3.6';
350:
351: -- populate the temp table
352: -- note that we are populating with the proj_element_id from PA_PROJ_ELEMENTS,
353: -- not the task_id from fetch_task_id
354: -- this is because fetch_task_id will only return those task ids in PA_TASKS, but
355: -- we need the proj_element_id to sync up with the task ids created by AMG later
356:

Line 406: CLOSE PA_PROJ_ELEMENTS_CSR;

402:
403: END LOOP;
404: --hyau
405:
406: CLOSE PA_PROJ_ELEMENTS_CSR;
407:
408: l_stage := '4';
409:
410: end if; -- calling_mode

Line 601: FROM pa_proj_elements

597: -- cursor to get the number of structures in a project
598: CURSOR l_get_structure_count_csr(c_project_id NUMBER)
599: IS
600: SELECT count(proj_element_id)
601: FROM pa_proj_elements
602: WHERE project_id = c_project_id
603: and object_type = 'PA_STRUCTURES'
604: GROUP BY proj_element_id;
605:

Line 610: FROM pa_proj_elements

606: -- cursor to get the number of structures in a project
607: CURSOR l_get_structure_id_csr(c_project_id NUMBER)
608: IS
609: SELECT proj_element_id
610: FROM pa_proj_elements
611: WHERE project_id = c_project_id
612: and object_type = 'PA_STRUCTURES';
613:
614: -- 3693934 for performance bug fix commented below cursor definition

Line 632: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs

628:
629: CURSOR l_get_working_version_csr(c_structure_id NUMBER)
630: IS
631: SELECT ppevs.element_version_id
632: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs
633: WHERE ppev.proj_element_id = c_structure_id
634: AND ppev.project_id = ppevs.project_id
635: AND ppev.proj_element_id = ppevs.proj_element_id
636: AND ppevs.published_date is null;

Line 659: FROM pa_proj_elements

655: -- HY check for valid project id, structure id combination.
656: CURSOR l_check_proj_struct_id_csr(c_project_id NUMBER, c_structure_id NUMBER)
657: IS
658: SELECT 'Y'
659: FROM pa_proj_elements
660: WHERE project_id = c_project_id
661: and proj_element_id = c_structure_id;
662:
663: -- HY check for valid project id, structure version id combination.

Line 973: -- Sync pa_proj_elements with pa_tasks

969: */
970:
971: if p_calling_mode = 'PUBLISH' then
972:
973: -- Sync pa_proj_elements with pa_tasks
974:
975: -- get the values associated to the project_id
976:
977: OPEN l_get_project_csr(p_project_id);

Line 1127: -- as the tasks in pa_proj_elements

1123: and b.task_id = pt.top_task_id)
1124: where pt.project_id = p_project_id;
1125:
1126: -- Need to update pa_tasks so that the newly created financial task have the same task_id
1127: -- as the tasks in pa_proj_elements
1128: UPDATE PA_TASKS pt
1129: SET pt.task_id =
1130: (select task_id
1131: from PA_TEMP_IMPORT_TASKS temp

Line 1136: UPDATE PA_PROJ_ELEMENTS e

1132: where temp.project_id = p_project_id
1133: and temp.task_reference = pt.pm_task_reference)
1134: WHERE pt.project_id = p_project_id;
1135:
1136: UPDATE PA_PROJ_ELEMENTS e
1137: set e.pm_source_reference = (
1138: select PM_TASK_REFERENCE
1139: from PA_TASKS t
1140: where t.task_id = e.proj_element_id

Line 1368: FROM pa_proj_elements

1364:
1365: CURSOR l_get_task_csr (c_project_id NUMBER, c_pm_task_reference VARCHAR2)
1366: IS
1367: SELECT proj_element_id
1368: FROM pa_proj_elements
1369: WHERE project_id = c_project_id
1370: AND pm_source_reference = c_pm_task_reference;
1371:
1372: BEGIN

Line 1463: from pa_proj_elements

1459: l_unique VARCHAR2(1) :='Y';
1460: BEGIN
1461:
1462: select 'N' into l_unique
1463: from pa_proj_elements
1464: where project_id = p_project_id
1465: and pm_source_reference = p_new_task_reference
1466: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug# 3601700
1467: FROM pa_proj_elements ppe,

Line 1467: FROM pa_proj_elements ppe,

1463: from pa_proj_elements
1464: where project_id = p_project_id
1465: and pm_source_reference = p_new_task_reference
1466: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug# 3601700
1467: FROM pa_proj_elements ppe,
1468: pa_proj_structure_types ppst,
1469: pa_structure_types pst
1470: WHERE ppe.proj_element_id = ppst.proj_element_id
1471: AND ppe.project_id = p_project_id