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

Line 203: SELECT PA_PROJ_ELEMENT_VERSIONS_S.NEXTVAL

199: pa_debug.debug('CREATE_LIFECYCLE PVT:Obtaining proj_element_version_id...');
200: END IF;
201:
202:
203: SELECT PA_PROJ_ELEMENT_VERSIONS_S.NEXTVAL
204: INTO l_pev_id
205: FROM dual;
206:
207: IF(p_debug_mode = 'Y') THEN

Line 208: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_element_versions...');

204: INTO l_pev_id
205: FROM dual;
206:
207: IF(p_debug_mode = 'Y') THEN
208: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_element_versions...');
209: END IF;
210:
211: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
212: X_ROW_ID => l_row_id ,

Line 211: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(

207: IF(p_debug_mode = 'Y') THEN
208: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_element_versions...');
209: END IF;
210:
211: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
212: X_ROW_ID => l_row_id ,
213: X_ELEMENT_VERSION_ID => l_pev_id ,
214: X_PROJ_ELEMENT_ID => l_lifecycle_id ,
215: X_OBJECT_TYPE => c_object_type ,

Line 512: , pa_proj_element_versions phasever

508: SELECT 'N'
509: FROM dual
510: WHERE exists(Select 'XYZ'
511: FROM pa_proj_elements pelem
512: , pa_proj_element_versions phasever
513: WHERE phasever.PARENT_STRUCTURE_VERSION_ID = l_life_elem_ver_id
514: AND phasever.PROJECT_ID = c_project_id
515: AND phasever.OBJECT_TYPE = c_object_type
516: AND phasever.PROJ_ELEMENT_ID = pelem.PROJ_ELEMENT_ID

Line 524: FROM pa_proj_element_versions

520:
521: CURSOR l_get_life_elem_ver_id
522: IS
523: SELECT ELEMENT_VERSION_ID
524: FROM pa_proj_element_versions
525: WHERE PROJ_ELEMENT_ID = p_lifecycle_id;
526:
527: BEGIN
528:

Line 670: SELECT PA_PROJ_ELEMENT_VERSIONS_S.NEXTVAL

666: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phase:Obtaining proj_element_version_id...');
667: END IF;
668:
669:
670: SELECT PA_PROJ_ELEMENT_VERSIONS_S.NEXTVAL
671: INTO l_pev_id
672: FROM dual;
673:
674: IF(p_debug_mode = 'Y') THEN

Line 675: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into pa_proj_element_versions...');

671: INTO l_pev_id
672: FROM dual;
673:
674: IF(p_debug_mode = 'Y') THEN
675: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into pa_proj_element_versions...');
676: END IF;
677:
678: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
679: X_ROW_ID => l_row_id ,

Line 678: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(

674: IF(p_debug_mode = 'Y') THEN
675: pa_debug.debug('CREATE_LIFECYCLE PVT.create_lifecyle_phas:Inserting into pa_proj_element_versions...');
676: END IF;
677:
678: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
679: X_ROW_ID => l_row_id ,
680: X_ELEMENT_VERSION_ID => l_pev_id ,
681: X_PROJ_ELEMENT_ID => l_phase_id ,
682: X_OBJECT_TYPE => c_object_type ,

Line 890: FROM pa_proj_element_versions

886:
887: CURSOR l_row_proj_element_versions
888: IS
889: SELECT rowid,element_version_id
890: FROM pa_proj_element_versions
891: WHERE proj_element_id = P_lifecycle_id
892: AND project_id = c_project_id
893: AND object_type = c_object_type;
894:

Line 1069: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');

1065: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);
1066:
1067:
1068: IF (p_debug_mode = 'Y') THEN
1069: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');
1070: END IF;
1071:
1072: OPEN l_row_proj_element_versions;
1073: FETCH l_row_proj_element_versions into l_rowid,l_element_version_id;

Line 1076: PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row(l_rowid);

1072: OPEN l_row_proj_element_versions;
1073: FETCH l_row_proj_element_versions into l_rowid,l_element_version_id;
1074: CLOSE l_row_proj_element_versions;
1075:
1076: PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row(l_rowid);
1077:
1078: IF (p_debug_mode = 'Y') THEN
1079: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENT_SCH_PKG.delete_Row');
1080: END IF;

Line 1224: From pa_proj_element_versions

1220:
1221: CURSOR l_row_proj_element_versions
1222: IS
1223: Select rowid,element_version_id,parent_structure_version_id
1224: From pa_proj_element_versions
1225: Where proj_element_id = P_phase_id
1226: AND project_id = c_project_id
1227: AND object_type = c_object_type;
1228:

Line 1360: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');

1356:
1357: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);
1358:
1359: IF (p_debug_mode = 'Y') THEN
1360: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row');
1361: END IF;
1362:
1363: OPEN l_row_proj_element_versions;
1364: FETCH l_row_proj_element_versions into l_rowid,l_element_version_id, l_par_element_version_id;

Line 1368: PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row(l_rowid);

1364: FETCH l_row_proj_element_versions into l_rowid,l_element_version_id, l_par_element_version_id;
1365: CLOSE l_row_proj_element_versions;
1366:
1367:
1368: PA_PROJ_ELEMENT_VERSIONS_PKG.delete_Row(l_rowid);
1369:
1370:
1371:
1372: IF (p_debug_mode = 'Y') THEN

Line 1677: FROM pa_proj_element_versions

1673:
1674: CURSOR l_row_proj_element_versions
1675: IS
1676: SELECT element_version_id
1677: FROM pa_proj_element_versions
1678: WHERE proj_element_id = P_lifecycle_id
1679: AND project_id = c_project_id
1680: AND object_type = c_object_type;
1681:

Line 2123: From pa_proj_element_versions

2119:
2120: CURSOR l_row_proj_elem_vers
2121: IS
2122: Select rowid,element_version_id,parent_structure_version_id,record_version_number
2123: From pa_proj_element_versions
2124: Where proj_element_id = P_lifecycle_phase_id
2125: AND project_id = c_project_id
2126: AND object_type = c_object_type;
2127:

Line 2303: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENT_VERSIONS...');

2299: FETCH l_row_proj_elem_vers into l_rowid, l_elem_vers_id,l_parent_elem_vers_id,l_record_version_number ;
2300: CLOSE l_row_proj_elem_vers;
2301:
2302: IF(p_debug_mode = 'Y') THEN
2303: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENT_VERSIONS...');
2304: END IF;
2305:
2306: PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row(
2307: X_ROW_ID => l_rowid ,

Line 2306: PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row(

2302: IF(p_debug_mode = 'Y') THEN
2303: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENT_VERSIONS...');
2304: END IF;
2305:
2306: PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row(
2307: X_ROW_ID => l_rowid ,
2308: X_ELEMENT_VERSION_ID =>l_elem_vers_id ,
2309: X_PROJ_ELEMENT_ID =>P_lifecycle_phase_id ,
2310: X_OBJECT_TYPE => c_object_type ,

Line 2475: from pa_proj_element_versions

2471:
2472: begin
2473: select element_version_id
2474: into l_parent_elem_ver_id
2475: from pa_proj_element_versions
2476: where proj_element_id = P_lifecycle_id
2477: and object_type = 'PA_STRUCTURES'
2478: and project_id = c_project_id;
2479: exception

Line 2487: from pa_proj_element_versions

2483:
2484: begin
2485: select element_version_id
2486: into l_child_elem_ver_id
2487: from pa_proj_element_versions
2488: where proj_element_id = P_lifecycle_phase_id
2489: and object_type = 'PA_TASKS'
2490: and project_id = c_project_id;
2491: exception

Line 2537: from pa_proj_element_versions child

2533: select FND_API.G_FALSE into l_delete_ok
2534: from sys.dual
2535: where exists(
2536: select 'xyz'
2537: from pa_proj_element_versions child
2538: ,pa_proj_elements tasks
2539: where child.parent_structure_version_id = l_parent_elem_ver_id
2540: and child.project_id = c_project_id
2541: and child.object_type = 'PA_TASKS'