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 PA_PROJECT_ACCUM_HEADERS

Line 1333: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

1329: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
1330: Where Budget_Type_Code = x_Budget_rec.BUDGET_TYPE_CODE
1331: AND
1332: (PAB.Project_Accum_id In
1333: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1334: Where Pah.Project_id = x_project_id and
1335: pah.Resource_list_member_id = 0 and
1336: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
1337: start with pt.task_id = x_budget_rec.TASK_ID

Line 1342: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

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 =
1345: x_Budget_rec.RESOURCE_LIST_MEMBER_ID and
1346: Pah.Task_id in (select 0 from sys.dual union

Line 1391: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

1387: x_err_stack||'->PA_MAINT_PROJECT_BUDGETS.create_accum_budgets';
1388:
1389: -- This checks for budgets record in PA_PROJECT_ACCUM_BUDGETS for this
1390: -- project and task combination. It is possible that there might be a
1391: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
1392: -- no corresponding detail record. The procedure called below,will
1393: -- check for the existence of the detail records and if not available
1394: -- would create it.
1395:

Line 1430: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

1426: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
1427: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
1428: -- in the Project_accum_budgets table. The next time , if the given task
1429: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
1430: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
1431: -- two records would have been processed by the Update statements.
1432:
1433: If v_noof_tasks > 0 Then
1434: For i in 1..v_noof_tasks LOOP

Line 1435: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1431: -- two records would have been processed by the Update statements.
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),

Line 1523: PA_PROJECT_ACCUM_HEADERS

1519:
1520: CURSOR Proj_Res_level_Cur IS
1521: SELECT Project_Accum_Id
1522: FROM
1523: PA_PROJECT_ACCUM_HEADERS
1524: WHERE Project_id = X_project_id
1525: AND Task_Id = 0
1526: AND Resource_list_Member_id = X_resource_list_member_id;
1527:

Line 1542: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

1538: X_err_stack ||'->PA_MAINT_PROJECT_BUDGETS.create_accum_budgets_res';
1539:
1540: -- This checks for budgets record in PA_PROJECT_ACCUM_ACTUALS for this
1541: -- project,task and resource combination.It is possible that there might be a
1542: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
1543: -- no corresponding detail record. The procedure called below,will
1544: -- check for the existence of the detail records and if not available
1545: -- would create it.
1546:

Line 1561: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but

1557: Recs_processed := Recs_processed + Res_recs_processed;
1558:
1559: -- This checks for budgets record in PA_PROJECT_ACCUM_ACTUALS for this
1560: -- project and Resource combination. It is possible that there might be a
1561: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
1562: -- no corresponding detail record. The procedure called below,will
1563: -- check for the existence of the detail records and if not available
1564: -- would create it.
1565:

Line 1600: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those

1596: -- 1.1.1, then the first time, Get_all_higher_tasks would return,
1597: -- 1.1.1, 1.1, and 1. We create three header records and three detail records
1598: -- in the Project_accum_budgets table. The next time , if the given task
1599: -- is 1.1.2, the Get_all_higher_tasks would return only 1.1.2, since
1600: -- 1.1 and 1 are already available in the Pa_project_accum_headers. Those
1601: -- two records would have been processed by the Update statements.
1602:
1603: If v_noof_tasks > 0 Then
1604: For i in 1..v_noof_tasks LOOP

Line 1605: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1601: -- two records would have been processed by the Update statements.
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),

Line 1672: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

1668: -- and if not present create the Header and Detail records for budgets
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,

Line 1757: -- task) which are not in PA_PROJECT_ACCUM_HEADERS

1753:
1754:
1755: -- Get_all_higher_tasks_bud - For the given Task Id returns all the
1756: -- higher level tasks in the WBS (including the given
1757: -- task) which are not in PA_PROJECT_ACCUM_HEADERS
1758: -- (Tasks with the given Resource )
1759:
1760: CURSOR Tasks_Cur IS
1761: SELECT task_id

Line 2135: from pa_project_accum_headers

2131: -- records and the Project-Resource level record(Task id = 0 and
2132: -- Resourcelist member id <> 0)
2133: begin
2134: Select project_accum_id into V_Accum_id
2135: from pa_project_accum_headers
2136: where project_id = x_project_id
2137: and task_id = x_task_id
2138: and resource_list_member_id = x_resource_list_member_id;
2139:

Line 2141: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

2137: and task_id = x_task_id
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,

Line 2143: Insert into PA_PROJECT_ACCUM_HEADERS

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,
2147: REQUEST_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN

Line 2450: from pa_project_accum_headers

2446: -- records and the Project-Resource level record(Task id = 0 and
2447: -- Resourcelist member id <> 0)
2448: begin
2449: Select project_accum_id into V_Accum_id
2450: from pa_project_accum_headers
2451: where project_id = x_project_id
2452: and task_id = x_task_id
2453: and resource_list_member_id = x_resource_list_member_id;
2454:

Line 2456: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

2452: and task_id = x_task_id
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,

Line 2458: Insert into PA_PROJECT_ACCUM_HEADERS

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,
2462: REQUEST_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN )

Line 2762: from pa_project_accum_headers

2758: -- records and the Project-Resource level record(Task id = 0 and
2759: -- Resourcelist member id <> 0)
2760: begin
2761: Select project_accum_id into V_Accum_id
2762: from pa_project_accum_headers
2763: where project_id = x_project_id
2764: and task_id = x_task_id
2765: and resource_list_member_id = x_resource_list_member_id;
2766:

Line 2768: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id

2764: and task_id = x_task_id
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,

Line 2770: Insert into PA_PROJECT_ACCUM_HEADERS

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,
2774: REQUEST_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN )