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

Line 104: FROM pa_proj_elements a, pa_proj_element_versions b,

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

Line 120: pa_proj_elements ppe,

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

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

496: ' NVL(a.wbs_level,0), b.scheduled_start_date+NVL(b.scheduled_start_date_rollup,0), '||
497: ' b.scheduled_finish_date+NVL(b.scheduled_finish_date_rollup,0), c.object_id_from1, '||
498: ' c.object_type_from FROM '||
499: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
500: ' pa_object_relationships c, pa_proj_elements d WHERE '||
501: ' a.element_version_id = c.object_id_to1(+) AND '||
502: ' c.relationship_type(+)= '||''''||'S'||''''||' AND '||
503: ' a.project_id = b.project_id AND '||
504: ' a.element_version_id = b.element_version_id AND '||

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

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

Line 1229: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(

1225:
1226: -- hsiu added for task partial rollup
1227: CURSOR get_rollup_flag(c_element_version_id NUMBER)
1228: IS
1229: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(
1230: a.STATUS_CODE, 'PLAN_ROLLUP')
1231: FROM pa_proj_elements a, pa_proj_element_versions b
1232: WHERE a.proj_element_id = b.proj_element_id
1233: AND a.project_id = b.project_id

Line 1231: FROM pa_proj_elements a, pa_proj_element_versions b

1227: CURSOR get_rollup_flag(c_element_version_id NUMBER)
1228: IS
1229: SELECT PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_STUS_ACTION_ALLOWED(
1230: a.STATUS_CODE, 'PLAN_ROLLUP')
1231: FROM pa_proj_elements a, pa_proj_element_versions b
1232: WHERE a.proj_element_id = b.proj_element_id
1233: AND a.project_id = b.project_id
1234: AND b.element_version_id = c_element_version_id;
1235:

Line 1241: FROM pa_proj_elements a, pa_proj_element_versions b,

1237: --status control is not used anymore
1238: CURSOR get_system_status_code(c_element_version_id NUMBER)
1239: IS
1240: SELECT decode(project_system_status_code, 'CANCELLED', 'N', 'Y')
1241: FROM pa_proj_elements a, pa_proj_element_versions b,
1242: pa_project_statuses c
1243: where a.proj_element_id = b.proj_element_id
1244: and a.project_id = b.project_id
1245: and b.element_version_id = c_element_version_id

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

1362: --first select stmt - get all parents along the branch of the element
1363: --second select stmt - get direct child of all parents
1364: --third select stmt - get input element
1365: -- hsiu: removing third one because the second statment should cover it
1366: -- FPM bug 3301192 : Added pa_proj_elements join and link_task_flag condition
1367: l_sql :=
1368: ' select a.project_id, a.element_version_id,'||
1369: ' a.object_type, b.PLANNED_EFFORT, '||
1370: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||

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

1370: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1371: ' b.scheduled_finish_date, c.object_id_from1, '||
1372: ' c.object_type_from from '||
1373: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1374: ' pa_object_relationships c, pa_proj_elements d where '||
1375: ' a.element_version_id = c.object_id_to1(+) and '||
1376: ' c.relationship_type(+)= '||''''||'S'||''''||' and '||
1377: ' a.project_id = b.project_id and '||
1378: ' a.element_version_id = b.element_version_id and '||

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

1394: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1395: ' b.scheduled_finish_date, c.object_id_from1, '||
1396: ' c.object_type_from from '||
1397: ' pa_proj_element_versions a, pa_proj_elem_ver_schedule b, '||
1398: ' pa_object_relationships c, pa_proj_elements d where '||
1399: ' a.element_version_id = c.object_id_to1 and '||
1400: ' c.relationship_type = '||''''||'S'||''''||' and '||
1401: ' a.project_id = b.project_id and '||
1402: ' a.element_version_id = b.element_version_id and '||

Line 2182: from pa_proj_elements a,

2178: CURSOR get_task_version_id(c_input NUMBER) IS
2179: select a.proj_element_id, a.object_type, b.wbs_level,
2180: 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,
2181: a.status_code
2182: from pa_proj_elements a,
2183: pa_proj_element_versions b,
2184: pa_project_statuses c,
2185: pa_proj_element_versions d,
2186: pa_object_relationships e

Line 2239: pa_proj_elements ppe,

2235: select 1
2236: from pa_object_relationships rel,
2237: pa_proj_element_versions a,
2238: pa_proj_element_versions b,
2239: pa_proj_elements ppe,
2240: pa_project_statuses pps
2241: where a.proj_element_id = c_element_id
2242: and a.parent_structure_version_id = p_structure_version_id
2243: and a.element_version_id = rel.object_id_from1

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

2257: l_get_task_ver_id_rec get_task_version_id%ROWTYPE;
2258: l_rollup_table PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE;
2259: l_cnt NUMBER;
2260:
2261: TYPE t_status_code IS TABLE OF pa_proj_elements.status_code%TYPE
2262: INDEX BY BINARY_INTEGER;
2263: l_status_codes t_status_code;
2264:
2265: --hsiu: bug 2800553: added for performance improvement

Line 2379: UPDATE PA_PROJ_ELEMENTS

2375: -- END IF;
2376:
2377: --check if status has been modified
2378: IF (l_final_status_weight <> l_rollup_table(l_cnt).TASK_STATUS2) THEN
2379: UPDATE PA_PROJ_ELEMENTS
2380: set status_code = l_final_status_code,
2381: RECORD_VERSION_NUMBER = NVL(RECORD_VERSION_NUMBER,1)+1,
2382: LAST_UPDATE_DATE = SYSDATE,
2383: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 2434: from pa_proj_elements a,

2430: IS
2431: CURSOR get_zero_weight_status IS
2432: select a.project_id, a.proj_element_id,
2433: b.element_version_id, a.status_code
2434: from pa_proj_elements a,
2435: pa_proj_element_versions b,
2436: pa_project_statuses c
2437: where a.project_id = b.project_id
2438: and a.proj_element_id = b.proj_element_id