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.

[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_ELEMENTS

Line 106: FROM pa_proj_elements a, pa_proj_element_versions b,

102: --status control is not used anymore
103: CURSOR get_system_status_code(c_element_version_id NUMBER)
104: IS
105: SELECT decode(project_system_status_code, 'CANCELLED', 'N', 'Y')
106: FROM pa_proj_elements a, pa_proj_element_versions b,
107: pa_project_statuses c
108: where a.proj_element_id = b.proj_element_id
109: and a.project_id = b.project_id
110: and b.element_version_id = c_element_version_id

Line 122: pa_proj_elements ppe,

118: SELECT ppe.proj_element_id,
119: ppev.element_version_id lnk_task_ver_id,
120: ppev.project_id lnk_task_project_id
121: FROM pa_proj_element_versions ppev,
122: pa_proj_elements ppe,
123: pa_proj_elem_ver_schedule pevs,
124: --bug 4541039
125: pa_object_relationships por,
126: pa_proj_elem_ver_structure pevst

Line 528: ' pa_object_relationships c, pa_proj_elements d WHERE '||

524: ' NVL(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
525: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
526: ' c.object_type_from FROM '||
527: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
528: ' pa_object_relationships c, pa_proj_elements d WHERE '||
529: ' a.element_version_id = c.object_id_to1(+) AND '||
530: ' c.relationship_type(+)= '||''''||'S'||''''||' AND '||
531: ' a.project_id = b.project_id AND '||
532: ' a.element_version_id = b.element_version_id AND '||

Line 552: ' pa_object_relationships c, pa_proj_elements d WHERE '||

548: ' nvl(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
549: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
550: ' c.object_type_from FROM '||
551: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
552: ' pa_object_relationships c, pa_proj_elements d WHERE '||
553: ' a.element_version_id = c.object_id_to1 AND '||
554: ' c.relationship_type = '||''''||'S'||''''||' AND '||
555: ' a.project_id = b.project_id AND '||
556: ' a.element_version_id = b.element_version_id AND '||

Line 1276: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(

1272:
1273: -- hsiu added for task partial rollup
1274: CURSOR get_rollup_flag(c_element_version_id NUMBER)
1275: IS
1276: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(
1277: a.STATUS_CODE, 'PLAN_ROLLUP')
1278: FROM pa_proj_elements a, pa_proj_element_versions b
1279: WHERE a.proj_element_id = b.proj_element_id
1280: AND a.project_id = b.project_id

Line 1278: FROM pa_proj_elements a, pa_proj_element_versions b

1274: CURSOR get_rollup_flag(c_element_version_id NUMBER)
1275: IS
1276: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(
1277: a.STATUS_CODE, 'PLAN_ROLLUP')
1278: FROM pa_proj_elements a, pa_proj_element_versions b
1279: WHERE a.proj_element_id = b.proj_element_id
1280: AND a.project_id = b.project_id
1281: AND b.element_version_id = c_element_version_id;
1282:

Line 1288: FROM pa_proj_elements a, pa_proj_element_versions b,

1284: --status control is not used anymore
1285: CURSOR get_system_status_code(c_element_version_id NUMBER)
1286: IS
1287: SELECT decode(project_system_status_code, 'CANCELLED', 'N', 'Y')
1288: FROM pa_proj_elements a, pa_proj_element_versions b,
1289: pa_project_statuses c
1290: where a.proj_element_id = b.proj_element_id
1291: and a.project_id = b.project_id
1292: and b.element_version_id = c_element_version_id

Line 1413: -- FPM bug 3301192 : Added pa_proj_elements join and link_task_flag condition

1409: --first select stmt - get all parents along the branch of the element
1410: --second select stmt - get direct child of all parents
1411: --third select stmt - get input element
1412: -- hsiu: removing third one because the second statment should cover it
1413: -- FPM bug 3301192 : Added pa_proj_elements join and link_task_flag condition
1414:
1415: -- Added IF condition for Huawei enhancement bug 13923366 by skkoppul
1416: -- During bulk add tasks mode, get just the parent details of each of the nodes
1417: -- that are being added instead of getting all parents nodes in the branch

Line 1425: ' pa_object_relationships c, pa_proj_elements d where '||

1421: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1422: ' b.scheduled_finish_date, c.object_id_from1, '||
1423: ' c.object_type_from from '||
1424: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1425: ' pa_object_relationships c, pa_proj_elements d where '||
1426: ' a.element_version_id = c.object_id_to1 and '||
1427: ' c.relationship_type = '||''''||'S'||''''||' and '||
1428: ' a.project_id = b.project_id and '||
1429: ' a.element_version_id = b.element_version_id and '||

Line 1448: ' pa_object_relationships c, pa_proj_elements d where '||

1444: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1445: ' b.scheduled_finish_date, c.object_id_from1, '||
1446: ' c.object_type_from from '||
1447: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1448: ' pa_object_relationships c, pa_proj_elements d where '||
1449: ' a.element_version_id = c.object_id_to1(+) and '||
1450: ' c.relationship_type(+)= '||''''||'S'||''''||' and '||
1451: ' a.project_id = b.project_id and '||
1452: ' a.element_version_id = b.element_version_id and '||

Line 1472: ' pa_object_relationships c, pa_proj_elements d where '||

1468: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1469: ' b.scheduled_finish_date, c.object_id_from1, '||
1470: ' c.object_type_from from '||
1471: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1472: ' pa_object_relationships c, pa_proj_elements d where '||
1473: ' a.element_version_id = c.object_id_to1 and '||
1474: ' c.relationship_type = '||''''||'S'||''''||' and '||
1475: ' a.project_id = b.project_id and '||
1476: ' a.element_version_id = b.element_version_id and '||

Line 2270: from pa_proj_elements a,

2266: CURSOR get_task_version_id(c_input NUMBER) IS
2267: select a.proj_element_id, a.object_type, b.wbs_level,
2268: decode(d.object_type, 'PA_STRUCTURES', NULL, d.proj_element_id) object_id_from1, decode(d.object_type, 'PA_STRUCTURES', NULL, d.object_type) object_type_from, c.PROJECT_STATUS_WEIGHT,
2269: a.status_code
2270: from pa_proj_elements a,
2271: pa_proj_element_versions b,
2272: pa_project_statuses c,
2273: pa_proj_element_versions d,
2274: pa_object_relationships e

Line 2316: from pa_proj_elements a,

2312: CURSOR get_task_version_details IS
2313: select a.proj_element_id, a.object_type, b.wbs_level,
2314: decode(d.object_type, 'PA_STRUCTURES', NULL, d.proj_element_id) object_id_from1, decode(d.object_type, 'PA_STRUCTURES', NULL, d.object_type) object_type_from, c.PROJECT_STATUS_WEIGHT,
2315: a.status_code
2316: from pa_proj_elements a,
2317: pa_proj_element_versions b,
2318: pa_project_statuses c,
2319: pa_proj_element_versions d,
2320: pa_object_relationships e

Line 2361: pa_proj_elements ppe,

2357: select 1
2358: from pa_object_relationships rel,
2359: pa_proj_element_versions a,
2360: pa_proj_element_versions b,
2361: pa_proj_elements ppe,
2362: pa_project_statuses pps
2363: where a.proj_element_id = c_element_id
2364: and a.parent_structure_version_id = p_structure_version_id
2365: and a.element_version_id = rel.object_id_from1

Line 2384: TYPE t_status_code IS TABLE OF pa_proj_elements.status_code%TYPE

2380: l_task_version_details_rec get_task_version_details%ROWTYPE; -- added for Huawei enhancement bug 13923366 skkoppul
2381: l_rollup_table PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE;
2382: l_cnt NUMBER;
2383:
2384: TYPE t_status_code IS TABLE OF pa_proj_elements.status_code%TYPE
2385: INDEX BY BINARY_INTEGER;
2386: l_status_codes t_status_code;
2387:
2388: --hsiu: bug 2800553: added for performance improvement

Line 2534: UPDATE PA_PROJ_ELEMENTS

2530: -- END IF;
2531:
2532: --check if status has been modified
2533: IF (l_final_status_weight <> l_rollup_table(l_cnt).TASK_STATUS2) THEN
2534: UPDATE PA_PROJ_ELEMENTS
2535: set status_code = l_final_status_code,
2536: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
2537: LAST_UPDATE_DATE = SYSDATE,
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2589: from pa_proj_elements a,

2585: IS
2586: CURSOR get_zero_weight_status IS
2587: select a.project_id, a.proj_element_id,
2588: b.element_version_id, a.status_code
2589: from pa_proj_elements a,
2590: pa_proj_element_versions b,
2591: pa_project_statuses c
2592: where a.project_id = b.project_id
2593: and a.proj_element_id = b.proj_element_id