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_PROJECT_STATUSES

Line 105: pa_project_statuses c

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
109: and a.status_code = c.project_status_code

Line 1242: pa_project_statuses c

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
1246: and a.status_code = c.project_status_code

Line 2184: pa_project_statuses c,

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
2187: where a.project_id = b.project_id
2188: and a.proj_element_id = b.proj_element_id

Line 2226: from pa_project_statuses a

2222: );
2223:
2224: CURSOR get_task_status IS
2225: select a.project_status_code, a.project_status_weight
2226: from pa_project_statuses a
2227: where a.predefined_flag = 'Y'
2228: and a.STATUS_TYPE = 'TASK';
2229: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2230: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;

Line 2229: l_temp_status_code pa_project_statuses.project_status_code%TYPE;

2225: select a.project_status_code, a.project_status_weight
2226: from pa_project_statuses a
2227: where a.predefined_flag = 'Y'
2228: and a.STATUS_TYPE = 'TASK';
2229: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2230: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2231: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2232: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2233:

Line 2230: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;

2226: from pa_project_statuses a
2227: where a.predefined_flag = 'Y'
2228: and a.STATUS_TYPE = 'TASK';
2229: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2230: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2231: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2232: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2233:
2234: CURSOR check_completed_ok(c_element_id NUMBER) IS

Line 2231: l_final_status_code pa_project_statuses.project_status_code%TYPE;

2227: where a.predefined_flag = 'Y'
2228: and a.STATUS_TYPE = 'TASK';
2229: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2230: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2231: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2232: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2233:
2234: CURSOR check_completed_ok(c_element_id NUMBER) IS
2235: select 1

Line 2232: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;

2228: and a.STATUS_TYPE = 'TASK';
2229: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2230: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2231: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2232: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2233:
2234: CURSOR check_completed_ok(c_element_id NUMBER) IS
2235: select 1
2236: from pa_object_relationships rel,

Line 2240: pa_project_statuses pps

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
2244: and a.object_type = rel.object_type_from

Line 2436: pa_project_statuses c

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
2439: and b.parent_structure_version_id = p_structure_version_id
2440: and c.project_status_code = a.status_code