DBA Data[Home] [Help]

APPS.PA_MAINT_PROJECT_BUDGETS dependencies on PA_PROJECT_ACCUM_BUDGETS

Line 1306: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

1302: -- resource
1303: -- Project and fetched task and all upper tasks with the fetched resource
1304: -- Project and fetched resource
1305:
1306: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
1307: BASE_RAW_COST_TOT = NVL(BASE_RAW_COST_TOT,0 ) +
1308: x_budget_rec.BASE_RAW_COST,
1309: BASE_BURDENED_COST_TOT = NVL(BASE_BURDENED_COST_TOT,0) +
1310: x_budget_rec.BASE_BURDENED_COST,

Line 1363: -- This procedure creates the records in pa_project_accum_budgets

1359: x_err_code := SQLCODE;
1360: RAISE;
1361: End Process_Budget_Tot;
1362:
1363: -- This procedure creates the records in pa_project_accum_budgets
1364: -- for all the task break down hierarachy
1365:
1366: Procedure create_accum_budgets
1367: (x_project_id In Number,

Line 1389: -- This checks for budgets record in PA_PROJECT_ACCUM_BUDGETS for this

1385: V_Old_Stack := x_err_stack;
1386: x_err_stack :=
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

Line 1447: Insert into PA_PROJECT_ACCUM_BUDGETS (

1443: x_err_stage,
1444: x_err_code);
1445:
1446: Recs_processed := Recs_processed + 1;
1447: Insert into PA_PROJECT_ACCUM_BUDGETS (
1448: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
1449: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
1450: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
1451: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 1620: Insert into PA_PROJECT_ACCUM_BUDGETS (

1616: x_err_stack,
1617: x_err_stage,
1618: x_err_code);
1619: Recs_processed := Recs_processed + 1;
1620: Insert into PA_PROJECT_ACCUM_BUDGETS (
1621: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
1622: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
1623: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
1624: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 1688: Insert into PA_PROJECT_ACCUM_BUDGETS (

1684: x_err_stage,
1685: x_err_code);
1686:
1687: Recs_processed := Recs_processed + 1;
1688: Insert into PA_PROJECT_ACCUM_BUDGETS (
1689: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
1690: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
1691: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
1692: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 2160: Insert into PA_PROJECT_ACCUM_BUDGETS (

2156: pa_proj_accum_main.x_created_by,
2157: pa_proj_accum_main.x_last_update_login
2158: );
2159:
2160: Insert into PA_PROJECT_ACCUM_BUDGETS (
2161: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
2162: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
2163: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
2164: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 2221: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

2217: );
2218: x_pab := false;
2219: end;
2220: If x_pab = true then
2221: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
2222: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) +
2223: NVL(V_Base_Raw_Cost_itd,0),
2224: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) +
2225: NVL(V_Base_Raw_Cost_ytd,0),

Line 2332: Insert into PA_PROJECT_ACCUM_BUDGETS (

2328: Where Budget_Type_Code = x_Budget_type_code
2329: And PAB.Project_Accum_id = v_accum_id;
2330:
2331: if sql%notfound then
2332: Insert into PA_PROJECT_ACCUM_BUDGETS (
2333: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
2334: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
2335: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
2336: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 2473: Insert into PA_PROJECT_ACCUM_BUDGETS (

2469: trunc(sysdate),
2470: pa_proj_accum_main.x_created_by,
2471: pa_proj_accum_main.x_last_update_login );
2472:
2473: Insert into PA_PROJECT_ACCUM_BUDGETS (
2474: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
2475: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
2476: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
2477: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 2534: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

2530: );
2531: x_pab := false;
2532: end;
2533: If x_pab = true then
2534: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
2535: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) +
2536: NVL(Tsk_Base_Raw_Cost_itd,0),
2537: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) +
2538: NVL(Tsk_Base_Raw_Cost_ytd,0),

Line 2645: Insert into PA_PROJECT_ACCUM_BUDGETS (

2641: Where Budget_Type_Code = x_Budget_type_code
2642: And PAB.Project_Accum_id = v_accum_id;
2643:
2644: if sql%notfound then
2645: Insert into PA_PROJECT_ACCUM_BUDGETS (
2646: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
2647: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
2648: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
2649: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 2785: Insert into PA_PROJECT_ACCUM_BUDGETS (

2781: trunc(sysdate),
2782: pa_proj_accum_main.x_created_by,
2783: pa_proj_accum_main.x_last_update_login );
2784:
2785: Insert into PA_PROJECT_ACCUM_BUDGETS (
2786: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
2787: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
2788: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
2789: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 2846: Update PA_PROJECT_ACCUM_BUDGETS PAB SET

2842: );
2843: x_pab := false;
2844: end;
2845: If x_pab = true then
2846: Update PA_PROJECT_ACCUM_BUDGETS PAB SET
2847: BASE_RAW_COST_ITD = NVL(BASE_RAW_COST_ITD,0) +
2848: NVL(Prj_Base_Raw_Cost_itd,0),
2849: BASE_RAW_COST_YTD = NVL(BASE_RAW_COST_YTD,0) +
2850: NVL(Prj_Base_Raw_Cost_ytd,0),

Line 2957: Insert into PA_PROJECT_ACCUM_BUDGETS (

2953: Where Budget_Type_Code = x_Budget_type_code
2954: And PAB.Project_Accum_id = v_accum_id;
2955:
2956: if sql%notfound then
2957: Insert into PA_PROJECT_ACCUM_BUDGETS (
2958: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
2959: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
2960: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
2961: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,