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_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 45: FROM PA_PROJ_ELEMENT_VERSIONS

41:
42: CURSOR get_project_id_csr(c_version_id NUMBER)
43: IS
44: SELECT project_id
45: FROM PA_PROJ_ELEMENT_VERSIONS
46: WHERE element_version_id = c_version_id;
47:
48: x_ret_code VARCHAR2(1) := fnd_api.g_false;
49: l_dummy VARCHAR2(1) := null;

Line 560: l_structure_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

556: IS
557: l_api_name CONSTANT VARCHAR(30) := 'CREATE_STRUCTURE_VERSION';
558: l_api_version CONSTANT NUMBER := 1.0;
559:
560: l_structure_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
561: l_return_status VARCHAR2(1);
562: l_msg_count NUMBER;
563: l_msg_data VARCHAR2(250);
564: l_data VARCHAR2(250);

Line 1383: pa_proj_element_versions pev,

1379: pevs.pev_structure_id, pevs.record_version_number,
1380: pevsh.pev_schedule_id, pevsh.record_version_number,
1381: pevsh.rowid
1382: from pa_proj_elements pe,
1383: pa_proj_element_versions pev,
1384: pa_proj_elem_ver_structure pevs,
1385: pa_proj_elem_ver_schedule pevsh
1386: where pev.element_version_id = p_structure_version_id and
1387: pev.proj_element_id = pe.proj_element_id and

Line 1395: from pa_proj_element_versions

1391: pev.element_version_id = pevsh.element_version_id (+);
1392:
1393: CURSOR is_last_version(p_structure_id NUMBER) IS
1394: select 'N'
1395: from pa_proj_element_versions
1396: where proj_element_id = p_structure_id;
1397:
1398: CURSOR get_top_tasks IS
1399: select v.element_version_id

Line 1400: from pa_proj_element_versions v,

1396: where proj_element_id = p_structure_id;
1397:
1398: CURSOR get_top_tasks IS
1399: select v.element_version_id
1400: from pa_proj_element_versions v,
1401: pa_object_relationships r
1402: where v.element_version_id = r.object_id_to1
1403: and r.object_id_from1 = p_structure_version_id
1404: and r.object_type_from = 'PA_STRUCTURES';

Line 1411: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;

1407: select record_version_number
1408: from pa_proj_workplan_attr
1409: where proj_element_id = c_proj_element_id;
1410:
1411: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;
1412: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;
1413: l_pe_rvn PA_PROJ_ELEMENTS.RECORD_VERSION_NUMBER%TYPE;
1414: l_element_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1415: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

Line 1414: l_element_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

1410:
1411: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;
1412: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;
1413: l_pe_rvn PA_PROJ_ELEMENTS.RECORD_VERSION_NUMBER%TYPE;
1414: l_element_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1415: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1416: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
1417: l_pevs_rvn PA_PROJ_ELEM_VER_STRUCTURE.RECORD_VERSION_NUMBER%TYPE;
1418: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;

Line 1415: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

1411: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;
1412: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;
1413: l_pe_rvn PA_PROJ_ELEMENTS.RECORD_VERSION_NUMBER%TYPE;
1414: l_element_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1415: l_pev_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1416: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
1417: l_pevs_rvn PA_PROJ_ELEM_VER_STRUCTURE.RECORD_VERSION_NUMBER%TYPE;
1418: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
1419: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;

Line 1422: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

1418: l_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE;
1419: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;
1420: l_pevsh_rowid VARCHAR2(255);
1421:
1422: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1423: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1424: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;
1425:
1426: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;

Line 1423: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

1419: l_pevsh_rvn PA_PROJ_ELEM_VER_SCHEDULE.RECORD_VERSION_NUMBER%TYPE;
1420: l_pevsh_rowid VARCHAR2(255);
1421:
1422: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1423: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1424: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;
1425:
1426: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
1427: l_structure_type pa_structure_types.STRUCTURE_TYPE_CLASS_CODE%TYPE; --Amit

Line 1426: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;

1422: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
1423: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
1424: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;
1425:
1426: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
1427: l_structure_type pa_structure_types.STRUCTURE_TYPE_CLASS_CODE%TYPE; --Amit
1428:
1429: -- SWM/IPM enhancement merger into R12.
1430: -- Bug 6046307

Line 1567: from pa_proj_element_versions

1563: --Get record version number for task, as it will change everytime
1564: --a task is deleted.
1565: select record_version_number, parent_structure_version_id
1566: into l_task_rvn, l_parent_struc_ver_id
1567: from pa_proj_element_versions
1568: where element_version_id = l_task_version_id;
1569:
1570: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',
1571: p_debug_mode => p_debug_mode,

Line 1911: from pa_proj_element_versions

1907: and element_version_id = c_structure_version_id;
1908:
1909: CURSOR c1 IS
1910: select project_id
1911: from pa_proj_element_versions
1912: where element_version_id = p_structure_version_id;
1913:
1914: BEGIN
1915: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE');

Line 2299: l_new_struct_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

2295: IS
2296: l_api_name CONSTANT VARCHAR(30) := 'COPY_STRUCTURE_VERSION';
2297: l_api_version CONSTANT NUMBER := 1.0;
2298:
2299: l_new_struct_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
2300: l_return_status VARCHAR2(1);
2301: l_msg_count NUMBER;
2302: l_msg_data VARCHAR2(250);
2303: l_data VARCHAR2(250);

Line 2971: from pa_proj_element_versions

2967: l_error_message_code VARCHAR2(30);
2968:
2969: CURSOR c1 IS
2970: select project_id
2971: from pa_proj_element_versions
2972: where element_version_id = p_structure_version_id;
2973: l_project_id NUMBER;
2974:
2975: BEGIN

Line 3294: l_record_version_number PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

3290:
3291: l_task_id NUMBER;
3292: l_parent_structure_id NUMBER;
3293: l_parent_structure_version_id NUMBER;
3294: l_record_version_number PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
3295: l_rowid VARCHAR2(255);
3296: l_check_sharing_enabled VARCHAR(1);
3297: l_proj_element_id NUMBER;
3298: l_api_name CONSTANT VARCHAR(30) := 'DISABLE_FINANCIAL_STRUCTURE';

Line 3312: FROM pa_proj_element_versions

3308: l_err_stage VARCHAR2(80);
3309:
3310: CURSOR get_struc_ver_info(c_structure_id NUMBER) IS
3311: SELECT element_version_id, record_version_number
3312: FROM pa_proj_element_versions
3313: where proj_element_id = c_structure_id
3314: and project_id = p_project_id;
3315:
3316: BEGIN

Line 3377: UPDATE PA_PROJ_ELEMENT_VERSIONS

3373: x_err_code => l_err_code,
3374: x_err_stage => l_err_stage,
3375: x_err_stack => l_err_stack);
3376:
3377: UPDATE PA_PROJ_ELEMENT_VERSIONS
3378: SET FINANCIAL_TASK_FLAG = 'N'
3379: WHERE PROJECT_ID = p_project_id
3380: AND PROJ_ELEMENT_ID = l_task_id;
3381: ELSE

Line 3446: FROM pa_proj_element_versions

3442: END IF;
3443:
3444: /* hsiu commented 3305199
3445: SELECT record_version_number into l_record_version_number
3446: FROM pa_proj_element_versions
3447: WHERE element_version_id = l_parent_structure_version_id;
3448: */
3449:
3450: /*Introducing the following IF CLAUSE For Bug 3938654

Line 3633: UPDATE PA_PROJ_ELEMENT_VERSIONS

3629: FND_MSG_PUB.initialize;
3630: END IF;
3631:
3632: IF (p_structure_version_id IS NOT NULL) THEN
3633: UPDATE PA_PROJ_ELEMENT_VERSIONS
3634: SET FINANCIAL_TASK_FLAG = 'N'
3635: WHERE PROJECT_ID = p_project_id
3636: AND PARENT_STRUCTURE_VERSION_ID = p_structure_version_id;
3637: END IF;

Line 3640: UPDATE PA_PROJ_ELEMENT_VERSIONS

3636: AND PARENT_STRUCTURE_VERSION_ID = p_structure_version_id;
3637: END IF;
3638:
3639: IF (p_task_version_id is NOT NULL) THEN
3640: UPDATE PA_PROJ_ELEMENT_VERSIONS
3641: SET FINANCIAL_TASK_FLAG='N'
3642: WHERE PROJECT_ID = p_project_id
3643: AND ELEMENT_VERSION_ID = p_task_version_id;
3644: END IF;