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_ELEMENTS

Line 92: WHERE exists(Select 'XYZ' from pa_proj_elements

88: BEGIN
89: SELECT 'N'
90: INTO l_is_uniq
91: FROM dual
92: WHERE exists(Select 'XYZ' from pa_proj_elements
93: WHERE element_number = P_lifecycle_short_name
94: AND object_type=c_object_type
95: AND project_id=c_project_id);
96: EXCEPTION

Line 143: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elements...');

139: INTO l_lifecycle_id
140: FROM dual;
141:
142: IF(p_debug_mode = 'Y') THEN
143: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elements...');
144: END IF;
145:
146: PA_PROJ_ELEMENTS_PKG.Insert_Row(
147: X_ROW_ID => l_row_id ,

Line 146: PA_PROJ_ELEMENTS_PKG.Insert_Row(

142: IF(p_debug_mode = 'Y') THEN
143: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into pa_proj_elements...');
144: END IF;
145:
146: PA_PROJ_ELEMENTS_PKG.Insert_Row(
147: X_ROW_ID => l_row_id ,
148: X_PROJ_ELEMENT_ID => l_lifecycle_id ,
149: X_PROJECT_ID => c_project_id ,
150: X_OBJECT_TYPE => c_object_type ,

Line 511: FROM pa_proj_elements pelem

507: IS
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

Line 609: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase:Inserting into pa_proj_elements...');

605: FROM dual;
606:
607:
608: if(p_debug_mode = 'Y') then
609: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase:Inserting into pa_proj_elements...');
610: end if;
611:
612: PA_PROJ_ELEMENTS_PKG.Insert_Row(
613: X_ROW_ID => l_row_id ,

Line 612: PA_PROJ_ELEMENTS_PKG.Insert_Row(

608: if(p_debug_mode = 'Y') then
609: pa_debug.debug('CREATE_LIFECYCLE_PVT.create_lifecycle_phase:Inserting into pa_proj_elements...');
610: end if;
611:
612: PA_PROJ_ELEMENTS_PKG.Insert_Row(
613: X_ROW_ID => l_row_id ,
614: x_proj_element_id => l_phase_id ,
615: x_project_id => c_project_id ,
616: x_object_type => c_object_type ,

Line 963: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phase: Locking on pa_proj_elements...');

959:
960: x_return_status := FND_API.G_RET_STS_SUCCESS;
961:
962: IF(p_debug_mode = 'Y') THEN
963: pa_debug.debug('CREATE_LIFECYCLE_PVT.delete_lifecycle_phase: Locking on pa_proj_elements...');
964: end if;
965:
966:
967: --Lock record

Line 973: FROM pa_proj_elements

969: BEGIN
970: -- BEGIN lock
971:
972: SELECT rowid into l_rowid
973: FROM pa_proj_elements
974: WHERE proj_element_id = P_lifecycle_id
975: AND record_version_number = p_record_version_number
976: AND project_id = c_project_id
977: AND object_type = c_object_type

Line 1018: FROM pa_proj_elements

1014: -- IF p_validate_only IS true
1015: BEGIN
1016:
1017: SELECT rowid into l_rowid
1018: FROM pa_proj_elements
1019: WHERE proj_element_id = P_lifecycle_id
1020: AND project_id = c_project_id
1021: AND object_type = c_object_type
1022: AND record_version_number = p_record_version_number;

Line 1062: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');

1058: RAISE FND_API.G_EXC_ERROR;
1059: End if;
1060:
1061: IF (p_debug_mode = 'Y') THEN
1062: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');
1063: END IF;
1064:
1065: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);
1066:

Line 1065: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);

1061: IF (p_debug_mode = 'Y') THEN
1062: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');
1063: END IF;
1064:
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');

Line 1272: pa_debug.debug('PA_LIFECYCLES_PVT.delete_lifecycle_phase:Locking record for pa_proj_elements...');

1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270:
1271: if(p_debug_mode = 'Y') then
1272: pa_debug.debug('PA_LIFECYCLES_PVT.delete_lifecycle_phase:Locking record for pa_proj_elements...');
1273: end if;
1274:
1275: --Lock record
1276: IF (p_validate_only <> FND_API.G_TRUE) THEN

Line 1280: FROM pa_proj_elements

1276: IF (p_validate_only <> FND_API.G_TRUE) THEN
1277: BEGIN
1278: --lock
1279: SELECT rowid into l_rowid
1280: FROM pa_proj_elements
1281: WHERE proj_element_id = p_phase_id
1282: AND project_id = c_project_id
1283: AND object_type = c_object_type
1284: AND record_version_number = p_record_version_number

Line 1315: FROM pa_proj_elements

1311: ELSE
1312: -- IF p_validate_only EQUALS TRUE
1313: BEGIN
1314: SELECT rowid into l_rowid
1315: FROM pa_proj_elements
1316: WHERE proj_element_id = p_phase_id
1317: AND project_id = c_project_id
1318: AND object_type = c_object_type
1319: AND record_version_number = p_record_version_number;

Line 1353: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');

1349: RAISE FND_API.G_EXC_ERROR;
1350: End if;
1351:
1352: IF (p_debug_mode = 'Y') THEN
1353: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');
1354: END IF;
1355:
1356:
1357: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);

Line 1357: PA_PROJ_ELEMENTS_PKG.delete_Row(l_rowid);

1353: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle_phases:Calling PA_PROJ_ELEMENTS_PKG.delete_Row');
1354: END IF;
1355:
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;

Line 1827: from pa_proj_elements

1823: IF (p_validate_only <> FND_API.G_TRUE) THEN
1824: BEGIN
1825: --lock
1826: select rowid into l_rowid
1827: from pa_proj_elements
1828: where proj_element_id = p_lifecycle_id
1829: AND record_version_number = p_record_version_number
1830: AND project_id = c_project_id
1831: AND object_type = c_object_type

Line 1862: FROM pa_proj_elements

1858: END;
1859: ELSE
1860: BEGIN
1861: SELECT rowid into l_rowid
1862: FROM pa_proj_elements
1863: WHERE proj_element_id = P_lifecycle_id
1864: AND project_id = c_project_id
1865: AND object_type = c_object_type
1866: AND record_version_number = p_record_version_number;

Line 1899: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into pa_proj_elements...');

1895: RAISE FND_API.G_EXC_ERROR;
1896: End if;
1897:
1898: IF(p_debug_mode = 'Y') THEN
1899: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into pa_proj_elements...');
1900: END IF;
1901:
1902:
1903:

Line 1904: PA_PROJ_ELEMENTS_PKG.UPDATE_ROW(

1900: END IF;
1901:
1902:
1903:
1904: PA_PROJ_ELEMENTS_PKG.UPDATE_ROW(
1905: X_ROW_ID => l_rowid ,
1906: X_PROJ_ELEMENT_ID => P_lifecycle_id ,
1907: X_PROJECT_ID =>c_project_id ,
1908: X_OBJECT_TYPE =>c_object_type ,

Line 2166: from pa_proj_elements

2162: IF (p_validate_only <> FND_API.G_TRUE) THEN
2163: BEGIN
2164: --lock
2165: select rowid into l_rowid
2166: from pa_proj_elements
2167: where proj_element_id = p_lifecycle_phase_id
2168: AND record_version_number = p_record_version_number
2169: AND project_id = c_project_id
2170: AND object_type = c_object_type

Line 2204: FROM pa_proj_elements

2200: END;
2201: ELSE
2202: BEGIN
2203: SELECT rowid into l_rowid
2204: FROM pa_proj_elements
2205: WHERE proj_element_id = p_lifecycle_phase_id
2206: AND project_id = c_project_id
2207: AND object_type = c_object_type
2208: AND record_version_number = p_record_version_number;

Line 2244: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENTS...');

2240: RAISE FND_API.G_EXC_ERROR;
2241: End if;
2242:
2243: IF(p_debug_mode = 'Y') THEN
2244: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENTS...');
2245: END IF;
2246:
2247: PA_PROJ_ELEMENTS_PKG.UPDATE_ROW(
2248: X_ROW_ID => l_rowid ,

Line 2247: PA_PROJ_ELEMENTS_PKG.UPDATE_ROW(

2243: IF(p_debug_mode = 'Y') THEN
2244: pa_debug.debug('PA_LIFECYCLES_PVT.update_lifecycle_phase: Updating PA_PROJ_ELEMENTS...');
2245: END IF;
2246:
2247: PA_PROJ_ELEMENTS_PKG.UPDATE_ROW(
2248: X_ROW_ID => l_rowid ,
2249: X_PROJ_ELEMENT_ID => P_lifecycle_phase_id ,
2250: X_PROJECT_ID =>c_project_id ,
2251: X_OBJECT_TYPE =>c_object_type ,

Line 2538: ,pa_proj_elements tasks

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'
2542: and tasks.phase_version_id = child.element_version_id