[Home] [Help]
12: /* Bug 2680486 -- Performance changes, Added c_project_id in the following cursor parameter and added condition accordingly */
13: CURSOR get_user_locked_status_csr(c_version_id NUMBER, c_user_id NUMBER, c_project_id NUMBER)
14: IS
15: SELECT 'Y'
16: FROM PA_PROJ_ELEM_VER_STRUCTURE pevs,
17: FND_USER fu
18: WHERE pevs.element_version_id = c_version_id
19: AND pevs.lock_status_code = 'LOCKED'
20: AND fu.user_id = c_user_id
25:
26: CURSOR get_locked_status_csr(c_version_id NUMBER, c_project_id NUMBER)
27: IS
28: SELECT 'Y'
29: FROM PA_PROJ_ELEM_VER_STRUCTURE
30: WHERE element_version_id = c_version_id
31: AND lock_status_code = 'LOCKED'
32: AND project_id = c_project_id;
33:
33:
34: CURSOR get_published_status_csr(c_version_id NUMBER, c_project_id NUMBER)
35: IS
36: SELECT 'Y'
37: FROM PA_PROJ_ELEM_VER_STRUCTURE
38: WHERE element_version_id = c_version_id
39: AND published_date is not null
40: AND project_id = c_project_id;
41:
177:
178: /* Bug 2680486 -- Performance changes -- Commented the following query. We have obtained project_id at the top itself.*/
179: /* SELECT project_id
180: INTO l_project_id
181: FROM PA_PROJ_ELEM_VER_STRUCTURE
182: WHERE element_version_id = p_version_id;
183: */
184:
185: PA_SECURITY_PVT.check_user_privilege
731: IS
732: l_api_name CONSTANT VARCHAR(30) := 'CREATE_STRUCTURE_VERSION_ATTR';
733: l_api_version CONSTANT NUMBER := 1.0;
734:
735: l_pev_structure_id PA_PROJ_ELEM_VER_STRUCTURE.PEV_STRUCTURE_ID%TYPE;
736: l_return_status VARCHAR2(1);
737: l_msg_count NUMBER;
738: l_msg_data VARCHAR2(250);
739: l_data VARCHAR2(250);
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
1388: pev.project_id = pevs.project_id and
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;
1420: l_pevsh_rowid VARCHAR2(255);
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;
1420: l_pevsh_rowid VARCHAR2(255);
1421:
1427: l_structure_type pa_structure_types.STRUCTURE_TYPE_CLASS_CODE%TYPE; --Amit
1428:
1429: -- SWM/IPM enhancement merger into R12.
1430: -- Bug 6046307
1431: l_strucutre_status PA_PROJ_ELEM_VER_STRUCTURE.STATUS_CODE%TYPE;
1432: l_str SYSTEM.PA_NUM_TBL_TYPE;
1433: l_rvn SYSTEM.PA_NUM_TBL_TYPE;
1434: i BINARY_INTEGER := 0;
1435:
1901: l_record_version_number NUMBER;
1902:
1903: cursor c2(c_project_id NUMBER, c_structure_version_id NUMBER) IS
1904: select record_version_number
1905: from pa_proj_elem_ver_structure
1906: where project_id = c_project_id
1907: and element_version_id = c_structure_version_id;
1908:
1909: CURSOR c1 IS