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_CORE2 dependencies on PA_PROJECT_STATUS_CONTROLS

Line 1370: SELECT 'x' FROM pa_project_status_controls

1366:
1367:
1368: l_old_stack varchar2(630);
1369: CURSOR l_get_controls_csr IS
1370: SELECT 'x' FROM pa_project_status_controls
1371: WHERE project_status_code = X_Project_Status_Code
1372: AND project_system_status_code IS NULL;
1373: l_dummy VARCHAR2(1);
1374: x_status_type VARCHAR2(30);

Line 1387: INSERT INTO pa_project_status_controls (

1383: INTO x_status_type
1384: From pa_project_statuses
1385: Where project_status_code=X_Project_Status_Code ;
1386:
1387: INSERT INTO pa_project_status_controls (
1388: PROJECT_STATUS_CODE,
1389: PROJECT_SYSTEM_STATUS_CODE,
1390: ACTION_CODE,
1391: SORT_ORDER,

Line 1419: FROM pa_project_status_controls pas1

1415: FND_GLOBAL.User_ID,
1416: FND_GLOBAL.Login_ID,
1417: x_status_type,
1418: COPY_TO_USER_STATUS_FLAG
1419: FROM pa_project_status_controls pas1
1420: WHERE pas1.project_system_status_code = X_Project_System_Status_Code
1421: AND nvl(pas1.copy_to_user_status_flag,'Y') <> 'N'
1422: AND NOT EXISTS
1423: (SELECT 'x' FROM pa_project_status_controls

Line 1423: (SELECT 'x' FROM pa_project_status_controls

1419: FROM pa_project_status_controls pas1
1420: WHERE pas1.project_system_status_code = X_Project_System_Status_Code
1421: AND nvl(pas1.copy_to_user_status_flag,'Y') <> 'N'
1422: AND NOT EXISTS
1423: (SELECT 'x' FROM pa_project_status_controls
1424: WHERE project_status_code = X_Project_Status_Code
1425: AND action_code = pas1.action_code
1426: AND project_system_status_code IS NULL);
1427: EXCEPTION