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 107: pa_project_statuses c

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

Line 1289: pa_project_statuses c

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

Line 2272: pa_project_statuses c,

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

Line 2318: pa_project_statuses c,

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

Line 2348: from pa_project_statuses a

2344: );
2345:
2346: CURSOR get_task_status IS
2347: select a.project_status_code, a.project_status_weight
2348: from pa_project_statuses a
2349: where a.predefined_flag = 'Y'
2350: and a.STATUS_TYPE = 'TASK';
2351: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2352: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;

Line 2351: l_temp_status_code pa_project_statuses.project_status_code%TYPE;

2347: select a.project_status_code, a.project_status_weight
2348: from pa_project_statuses a
2349: where a.predefined_flag = 'Y'
2350: and a.STATUS_TYPE = 'TASK';
2351: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2352: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2353: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2354: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2355:

Line 2352: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;

2348: from pa_project_statuses a
2349: where a.predefined_flag = 'Y'
2350: and a.STATUS_TYPE = 'TASK';
2351: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2352: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2353: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2354: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2355:
2356: CURSOR check_completed_ok(c_element_id NUMBER) IS

Line 2353: l_final_status_code pa_project_statuses.project_status_code%TYPE;

2349: where a.predefined_flag = 'Y'
2350: and a.STATUS_TYPE = 'TASK';
2351: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2352: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2353: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2354: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2355:
2356: CURSOR check_completed_ok(c_element_id NUMBER) IS
2357: select 1

Line 2354: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;

2350: and a.STATUS_TYPE = 'TASK';
2351: l_temp_status_code pa_project_statuses.project_status_code%TYPE;
2352: l_temp_status_weight pa_project_statuses.project_status_weight%TYPE;
2353: l_final_status_code pa_project_statuses.project_status_code%TYPE;
2354: l_final_status_weight pa_project_statuses.project_status_weight%TYPE;
2355:
2356: CURSOR check_completed_ok(c_element_id NUMBER) IS
2357: select 1
2358: from pa_object_relationships rel,

Line 2362: pa_project_statuses pps

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

Line 2591: pa_project_statuses c

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