APPS.PA_LIFECYCLES_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 246: SELECT PA_PROJ_ELEM_VER_STRUCTURE_S.NEXTVAL

242: IF(p_debug_mode = 'Y') THEN
243: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_element_version_structure_id...');
244: END IF;
245:
246: SELECT PA_PROJ_ELEM_VER_STRUCTURE_S.NEXTVAL
247: INTO l_pev_struct_id
248: FROM dual;
249:
250: IF(p_debug_mode = 'Y') THEN

Line 255: PA_PROJ_ELEM_VER_STRUCTURE_PKG.insert_row(

251: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elem_version_structure...');
252: END IF;
253:
254:
255: PA_PROJ_ELEM_VER_STRUCTURE_PKG.insert_row(
256: X_ROWID => l_row_id ,
257: X_PEV_STRUCTURE_ID => l_pev_struct_id ,
258: X_ELEMENT_VERSION_ID => l_pev_id ,
259: X_VERSION_NUMBER => 1 ,

Line 916: FROM pa_proj_elem_ver_structure

912:
913: CURSOR l_row_proj_elem_ver_structure
914: IS
915: SELECT rowid
916: FROM pa_proj_elem_ver_structure
917: WHERE element_version_id = l_element_version_id
918: AND proj_element_id = P_lifecycle_id
919: AND project_id = c_project_id;
920:

Line 1091: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row');

1087:
1088:
1089:
1090: IF (p_debug_mode = 'Y') THEN
1091: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row');
1092: END IF;
1093:
1094: OPEN l_row_proj_elem_ver_structure;
1095: FETCH l_row_proj_elem_ver_structure into l_rowid;

Line 1098: PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row(l_rowid);

1094: OPEN l_row_proj_elem_ver_structure;
1095: FETCH l_row_proj_elem_ver_structure into l_rowid;
1096: CLOSE l_row_proj_elem_ver_structure;
1097:
1098: PA_PROJ_ELEM_VER_STRUCTURE_PKG.delete_Row(l_rowid);
1099:
1100: IF (p_debug_mode = 'Y') THEN
1101: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row');
1102: END IF;

Line 1699: From pa_proj_elem_ver_structure

1695:
1696: CURSOR l_row_proj_elem_ver_structure
1697: IS
1698: Select rowid,PEV_STRUCTURE_ID,element_version_id,record_version_number
1699: From pa_proj_elem_ver_structure
1700: WHERE element_version_id = l_element_version_id
1701: AND proj_element_id = P_lifecycle_id
1702: AND project_id = c_project_id;
1703:

Line 1960: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_PROJ_ELEM_VER_STRUCTURE...');

1956: FETCH l_row_proj_elem_ver_structure into l_rowid,l_pev_id,l_elem_vers_id,l_record_version_number;
1957: CLOSE l_row_proj_elem_ver_structure;
1958:
1959: IF(p_debug_mode = 'Y') THEN
1960: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_PROJ_ELEM_VER_STRUCTURE...');
1961: END IF;
1962:
1963: PA_PROJ_ELEM_VER_STRUCTURE_PKG.UPDATE_ROW (
1964: X_ROWID =>l_rowid ,

Line 1963: PA_PROJ_ELEM_VER_STRUCTURE_PKG.UPDATE_ROW (

1959: IF(p_debug_mode = 'Y') THEN
1960: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_PROJ_ELEM_VER_STRUCTURE...');
1961: END IF;
1962:
1963: PA_PROJ_ELEM_VER_STRUCTURE_PKG.UPDATE_ROW (
1964: X_ROWID =>l_rowid ,
1965: X_PEV_STRUCTURE_ID =>l_pev_id ,
1966: X_ELEMENT_VERSION_ID =>l_elem_vers_id ,
1967: X_VERSION_NUMBER => 1 ,

Line 2116: From pa_proj_elem_ver_structure

2112:
2113: CURSOR l_row_proj_elem_ver_structure
2114: IS
2115: Select rowid,PEV_STRUCTURE_ID,element_version_id
2116: From pa_proj_elem_ver_structure
2117: Where proj_element_id = P_lifecycle_id
2118: AND project_id = c_project_id;
2119:
2120: CURSOR l_row_proj_elem_vers