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 1427: SELECT 'x' FROM pa_project_status_controls

1423:
1424:
1425: l_old_stack varchar2(630);
1426: CURSOR l_get_controls_csr IS
1427: SELECT 'x' FROM pa_project_status_controls
1428: WHERE project_status_code = X_Project_Status_Code
1429: AND project_system_status_code IS NULL;
1430: l_dummy VARCHAR2(1);
1431: x_status_type VARCHAR2(30);

Line 1444: INSERT INTO pa_project_status_controls (

1440: INTO x_status_type
1441: From pa_project_statuses
1442: Where project_status_code=X_Project_Status_Code ;
1443:
1444: INSERT INTO pa_project_status_controls (
1445: PROJECT_STATUS_CODE,
1446: PROJECT_SYSTEM_STATUS_CODE,
1447: ACTION_CODE,
1448: SORT_ORDER,

Line 1476: FROM pa_project_status_controls pas1

1472: FND_GLOBAL.User_ID,
1473: FND_GLOBAL.Login_ID,
1474: x_status_type,
1475: COPY_TO_USER_STATUS_FLAG
1476: FROM pa_project_status_controls pas1
1477: WHERE pas1.project_system_status_code = X_Project_System_Status_Code
1478: AND nvl(pas1.copy_to_user_status_flag,'Y') <> 'N'
1479: AND NOT EXISTS
1480: (SELECT 'x' FROM pa_project_status_controls

Line 1480: (SELECT 'x' FROM pa_project_status_controls

1476: FROM pa_project_status_controls pas1
1477: WHERE pas1.project_system_status_code = X_Project_System_Status_Code
1478: AND nvl(pas1.copy_to_user_status_flag,'Y') <> 'N'
1479: AND NOT EXISTS
1480: (SELECT 'x' FROM pa_project_status_controls
1481: WHERE project_status_code = X_Project_Status_Code
1482: AND action_code = pas1.action_code
1483: AND project_system_status_code IS NULL);
1484: EXCEPTION