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_MAINT_PROJECT_BUDGETS dependencies on DUAL

Line 1340: select to_number(X_Proj_accum_id) from sys.dual

1336: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
1337: start with pt.task_id = x_budget_rec.TASK_ID
1338: connect by prior pt.parent_task_id = pt.task_id)
1339: UNION
1340: select to_number(X_Proj_accum_id) from sys.dual
1341: UNION
1342: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1343: Where Pah.Project_id = x_project_id and
1344: pah.Resource_list_member_id =

Line 1346: Pah.Task_id in (select 0 from sys.dual union

1342: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1343: Where Pah.Project_id = x_project_id and
1344: pah.Resource_list_member_id =
1345: x_Budget_rec.RESOURCE_LIST_MEMBER_ID and
1346: Pah.Task_id in (select 0 from sys.dual union
1347: Select Pt.Task_Id from PA_TASKS pt
1348: start with pt.task_id = x_budget_rec.TASK_ID
1349: connect by prior pt.parent_task_id = pt.task_id)))
1350: );

Line 1436: From sys.Dual;

1432:
1433: If v_noof_tasks > 0 Then
1434: For i in 1..v_noof_tasks LOOP
1435: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1436: From sys.Dual;
1437: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks
1438: (X_project_id,
1439: v_task_array(i),
1440: x_current_period,

Line 1606: From sys.Dual;

1602:
1603: If v_noof_tasks > 0 Then
1604: For i in 1..v_noof_tasks LOOP
1605: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1606: From sys.Dual;
1607: PA_process_accum_actuals_res.insert_headers_res
1608: (x_project_id,
1609: v_task_array(i),
1610: x_resource_list_id ,

Line 1673: From sys.Dual;

1669: Open Proj_Res_level_Cur;
1670: Fetch Proj_Res_level_Cur Into V_Accum_Id;
1671: IF Proj_Res_level_Cur%NOTFOUND Then
1672: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
1673: From sys.Dual;
1674: PA_process_accum_actuals_res.insert_headers_res
1675: (x_project_id,
1676: 0,
1677: x_resource_list_id ,

Line 2142: from sys.dual;

2138: and resource_list_member_id = x_resource_list_member_id;
2139:
2140: exception when no_data_found then
2141: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2142: from sys.dual;
2143: Insert into PA_PROJECT_ACCUM_HEADERS
2144: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2145: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
2146: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 2457: from sys.dual;

2453: and resource_list_member_id = x_resource_list_member_id;
2454:
2455: exception when no_data_found then
2456: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2457: from sys.dual;
2458: Insert into PA_PROJECT_ACCUM_HEADERS
2459: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2460: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
2461: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,

Line 2769: from sys.dual;

2765: and resource_list_member_id = x_resource_list_member_id;
2766:
2767: exception when no_data_found then
2768: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2769: from sys.dual;
2770: Insert into PA_PROJECT_ACCUM_HEADERS
2771: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2772: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,
2773: RESOURCE_LIST_MEMBER_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,