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_PROJ_ACCUM_MAIN

Line 1327: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

1323: BASE_QUANTITY_TOT = NVL(BASE_QUANTITY_TOT,0) +
1324: V_Base_Qty,
1325: ORIG_QUANTITY_TOT = NVL(ORIG_QUANTITY_TOT,0) +
1326: V_Orig_Qty,
1327: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
1328: LAST_UPDATE_DATE = Trunc(Sysdate),
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

Line 1329: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

1325: ORIG_QUANTITY_TOT = NVL(ORIG_QUANTITY_TOT,0) +
1326: V_Orig_Qty,
1327: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
1328: LAST_UPDATE_DATE = Trunc(Sysdate),
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

Line 1488: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

1484: 0,0,0,0,
1485: 0,0,0,0,
1486: NULL,NULL,
1487: 0,0,0,0,0,0,0,0,0,0,
1488: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1489: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1490: Recs_processed := Recs_processed + 1;
1491: END LOOP;
1492:

Line 1489: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

1485: 0,0,0,0,
1486: NULL,NULL,
1487: 0,0,0,0,0,0,0,0,0,0,
1488: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1489: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1490: Recs_processed := Recs_processed + 1;
1491: END LOOP;
1492:
1493: End If;

Line 1661: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

1657: 0,0,0,0,
1658: 0,0,0,0,
1659: NULL,NULL,
1660: 0,0,0,0,0,0,0,0,0,0,
1661: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1662: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1663:
1664: Recs_processed := Recs_processed + 1;
1665: END LOOP;

Line 1662: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

1658: 0,0,0,0,
1659: NULL,NULL,
1660: 0,0,0,0,0,0,0,0,0,0,
1661: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1662: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1663:
1664: Recs_processed := Recs_processed + 1;
1665: END LOOP;
1666: End If;

Line 1729: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

1725: 0,0,0,0,
1726: 0,0,0,0,
1727: NULL,NULL,
1728: 0,0,0,0,0,0,0,0,0,0,
1729: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1730: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1731: Recs_processed := Recs_processed + 1;
1732: END IF;
1733: Close Proj_Res_level_Cur;

Line 1730: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

1726: 0,0,0,0,
1727: NULL,NULL,
1728: 0,0,0,0,0,0,0,0,0,0,
1729: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
1730: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
1731: Recs_processed := Recs_processed + 1;
1732: END IF;
1733: Close Proj_Res_level_Cur;
1734: x_recs_processed := Recs_processed;

Line 2153: pa_proj_accum_main.x_last_updated_by,

2149: Values (v_accum_id,X_project_id,x_task_id,
2150: x_current_period,
2151: x_resource_id,x_resource_list_id,
2152: x_resource_list_assignment_id,x_resource_list_Member_id,
2153: pa_proj_accum_main.x_last_updated_by,
2154: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2155: trunc(sysdate),
2156: pa_proj_accum_main.x_created_by,
2157: pa_proj_accum_main.x_last_update_login

Line 2154: Trunc(sysdate),pa_proj_accum_main.x_request_id,

2150: x_current_period,
2151: x_resource_id,x_resource_list_id,
2152: x_resource_list_assignment_id,x_resource_list_Member_id,
2153: pa_proj_accum_main.x_last_updated_by,
2154: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2155: trunc(sysdate),
2156: pa_proj_accum_main.x_created_by,
2157: pa_proj_accum_main.x_last_update_login
2158: );

Line 2156: pa_proj_accum_main.x_created_by,

2152: x_resource_list_assignment_id,x_resource_list_Member_id,
2153: pa_proj_accum_main.x_last_updated_by,
2154: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2155: trunc(sysdate),
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 (

Line 2157: pa_proj_accum_main.x_last_update_login

2153: pa_proj_accum_main.x_last_updated_by,
2154: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2155: trunc(sysdate),
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,

Line 2214: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

2210: TOT_BASE_RAW_COST,TOT_BASE_BURDENED_COST,TOT_ORIG_RAW_COST,
2211: TOT_ORIG_BURDENED_COST,TOT_BASE_REVENUE,TOT_ORIG_REVENUE,
2212: TOT_BASE_LABOR_HOURS,TOT_ORIG_LABOR_HOURS,TOT_BASE_QUANTITY,
2213: TOT_ORIG_QUANTITY,
2214: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2215: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2216: x_fin_plan_type_id
2217: );
2218: x_pab := false;

Line 2215: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,

2211: TOT_ORIG_BURDENED_COST,TOT_BASE_REVENUE,TOT_ORIG_REVENUE,
2212: TOT_BASE_LABOR_HOURS,TOT_ORIG_LABOR_HOURS,TOT_BASE_QUANTITY,
2213: TOT_ORIG_QUANTITY,
2214: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2215: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2216: x_fin_plan_type_id
2217: );
2218: x_pab := false;
2219: end;

Line 2324: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

2320: ORIG_QUANTITY_TOT = NVL(ORIG_QUANTITY_TOT,0) +
2321: TOT_ORIG_QUANTITY,
2322: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
2323: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
2324: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
2325: LAST_UPDATE_DATE = Trunc(Sysdate),
2326: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,
2327: FIN_PLAN_TYPE_ID = x_fin_plan_type_id
2328: Where Budget_Type_Code = x_Budget_type_code

Line 2326: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,

2322: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
2323: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
2324: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
2325: LAST_UPDATE_DATE = Trunc(Sysdate),
2326: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,
2327: FIN_PLAN_TYPE_ID = x_fin_plan_type_id
2328: Where Budget_Type_Code = x_Budget_type_code
2329: And PAB.Project_Accum_id = v_accum_id;
2330:

Line 2386: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

2382: TOT_BASE_RAW_COST,TOT_BASE_BURDENED_COST,TOT_ORIG_RAW_COST,
2383: TOT_ORIG_BURDENED_COST,TOT_BASE_REVENUE,TOT_ORIG_REVENUE,
2384: TOT_BASE_LABOR_HOURS,TOT_ORIG_LABOR_HOURS,TOT_BASE_QUANTITY,
2385: TOT_ORIG_QUANTITY,
2386: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2387: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2388: x_fin_plan_type_id
2389: );
2390: end if;

Line 2387: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,

2383: TOT_ORIG_BURDENED_COST,TOT_BASE_REVENUE,TOT_ORIG_REVENUE,
2384: TOT_BASE_LABOR_HOURS,TOT_ORIG_LABOR_HOURS,TOT_BASE_QUANTITY,
2385: TOT_ORIG_QUANTITY,
2386: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2387: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2388: x_fin_plan_type_id
2389: );
2390: end if;
2391: end if;

Line 2467: pa_proj_accum_main.x_last_updated_by,

2463: Values (v_accum_id,X_project_id,x_task_id,
2464: x_current_period,
2465: x_resource_id,x_resource_list_id,
2466: x_resource_list_assignment_id,x_resource_list_Member_id,
2467: pa_proj_accum_main.x_last_updated_by,
2468: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2469: trunc(sysdate),
2470: pa_proj_accum_main.x_created_by,
2471: pa_proj_accum_main.x_last_update_login );

Line 2468: Trunc(sysdate),pa_proj_accum_main.x_request_id,

2464: x_current_period,
2465: x_resource_id,x_resource_list_id,
2466: x_resource_list_assignment_id,x_resource_list_Member_id,
2467: pa_proj_accum_main.x_last_updated_by,
2468: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2469: trunc(sysdate),
2470: pa_proj_accum_main.x_created_by,
2471: pa_proj_accum_main.x_last_update_login );
2472:

Line 2470: pa_proj_accum_main.x_created_by,

2466: x_resource_list_assignment_id,x_resource_list_Member_id,
2467: pa_proj_accum_main.x_last_updated_by,
2468: Trunc(sysdate),pa_proj_accum_main.x_request_id,
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,

Line 2471: pa_proj_accum_main.x_last_update_login );

2467: pa_proj_accum_main.x_last_updated_by,
2468: Trunc(sysdate),pa_proj_accum_main.x_request_id,
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,

Line 2527: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

2523: Tsk_BASE_RAW_COST,Tsk_BASE_BURDENED_COST,Tsk_ORIG_RAW_COST,
2524: Tsk_ORIG_BURDENED_COST,Tsk_BASE_REVENUE,Tsk_ORIG_REVENUE,
2525: Tsk_BASE_LABOR_HOURS,Tsk_ORIG_LABOR_HOURS,Tsk_BASE_QUANTITY,
2526: Tsk_ORIG_QUANTITY,
2527: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2528: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2529: x_fin_plan_type_id
2530: );
2531: x_pab := false;

Line 2528: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,

2524: Tsk_ORIG_BURDENED_COST,Tsk_BASE_REVENUE,Tsk_ORIG_REVENUE,
2525: Tsk_BASE_LABOR_HOURS,Tsk_ORIG_LABOR_HOURS,Tsk_BASE_QUANTITY,
2526: Tsk_ORIG_QUANTITY,
2527: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2528: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2529: x_fin_plan_type_id
2530: );
2531: x_pab := false;
2532: end;

Line 2637: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

2633: ORIG_QUANTITY_TOT = NVL(ORIG_QUANTITY_TOT,0) +
2634: Tsk_ORIG_QUANTITY,
2635: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
2636: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
2637: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
2638: LAST_UPDATE_DATE = Trunc(Sysdate),
2639: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,
2640: FIN_PLAN_TYPE_ID = x_fin_plan_type_id
2641: Where Budget_Type_Code = x_Budget_type_code

Line 2639: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,

2635: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
2636: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
2637: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
2638: LAST_UPDATE_DATE = Trunc(Sysdate),
2639: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,
2640: FIN_PLAN_TYPE_ID = x_fin_plan_type_id
2641: Where Budget_Type_Code = x_Budget_type_code
2642: And PAB.Project_Accum_id = v_accum_id;
2643:

Line 2699: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

2695: Tsk_BASE_RAW_COST,Tsk_BASE_BURDENED_COST,Tsk_ORIG_RAW_COST,
2696: Tsk_ORIG_BURDENED_COST,Tsk_BASE_REVENUE,Tsk_ORIG_REVENUE,
2697: Tsk_BASE_LABOR_HOURS,Tsk_ORIG_LABOR_HOURS,Tsk_BASE_QUANTITY,
2698: Tsk_ORIG_QUANTITY,
2699: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2700: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2701: x_fin_plan_type_id
2702: );
2703: end if;

Line 2700: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,

2696: Tsk_ORIG_BURDENED_COST,Tsk_BASE_REVENUE,Tsk_ORIG_REVENUE,
2697: Tsk_BASE_LABOR_HOURS,Tsk_ORIG_LABOR_HOURS,Tsk_BASE_QUANTITY,
2698: Tsk_ORIG_QUANTITY,
2699: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2700: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2701: x_fin_plan_type_id
2702: );
2703: end if;
2704: end if;

Line 2779: pa_proj_accum_main.x_last_updated_by,

2775: Values (v_accum_id,X_project_id,x_task_id,
2776: x_current_period,
2777: x_resource_id,x_resource_list_id,
2778: x_resource_list_assignment_id,x_resource_list_Member_id,
2779: pa_proj_accum_main.x_last_updated_by,
2780: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2781: trunc(sysdate),
2782: pa_proj_accum_main.x_created_by,
2783: pa_proj_accum_main.x_last_update_login );

Line 2780: Trunc(sysdate),pa_proj_accum_main.x_request_id,

2776: x_current_period,
2777: x_resource_id,x_resource_list_id,
2778: x_resource_list_assignment_id,x_resource_list_Member_id,
2779: pa_proj_accum_main.x_last_updated_by,
2780: Trunc(sysdate),pa_proj_accum_main.x_request_id,
2781: trunc(sysdate),
2782: pa_proj_accum_main.x_created_by,
2783: pa_proj_accum_main.x_last_update_login );
2784:

Line 2782: pa_proj_accum_main.x_created_by,

2778: x_resource_list_assignment_id,x_resource_list_Member_id,
2779: pa_proj_accum_main.x_last_updated_by,
2780: Trunc(sysdate),pa_proj_accum_main.x_request_id,
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,

Line 2783: pa_proj_accum_main.x_last_update_login );

2779: pa_proj_accum_main.x_last_updated_by,
2780: Trunc(sysdate),pa_proj_accum_main.x_request_id,
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,

Line 2839: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

2835: Prj_BASE_RAW_COST,Prj_BASE_BURDENED_COST,Prj_ORIG_RAW_COST,
2836: Prj_ORIG_BURDENED_COST,Prj_BASE_REVENUE,Prj_ORIG_REVENUE,
2837: Prj_BASE_LABOR_HOURS,Prj_ORIG_LABOR_HOURS,Prj_BASE_QUANTITY,
2838: Prj_ORIG_QUANTITY,
2839: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2840: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2841: x_fin_plan_type_id
2842: );
2843: x_pab := false;

Line 2840: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,

2836: Prj_ORIG_BURDENED_COST,Prj_BASE_REVENUE,Prj_ORIG_REVENUE,
2837: Prj_BASE_LABOR_HOURS,Prj_ORIG_LABOR_HOURS,Prj_BASE_QUANTITY,
2838: Prj_ORIG_QUANTITY,
2839: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
2840: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
2841: x_fin_plan_type_id
2842: );
2843: x_pab := false;
2844: end;

Line 2949: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

2945: ORIG_QUANTITY_TOT = NVL(ORIG_QUANTITY_TOT,0) +
2946: Prj_ORIG_QUANTITY,
2947: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
2948: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
2949: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
2950: LAST_UPDATE_DATE = Trunc(Sysdate),
2951: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,
2952: FIN_PLAN_TYPE_ID = x_fin_plan_type_id
2953: Where Budget_Type_Code = x_Budget_type_code

Line 2951: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,

2947: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
2948: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
2949: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
2950: LAST_UPDATE_DATE = Trunc(Sysdate),
2951: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login,
2952: FIN_PLAN_TYPE_ID = x_fin_plan_type_id
2953: Where Budget_Type_Code = x_Budget_type_code
2954: And PAB.Project_Accum_id = v_accum_id;
2955:

Line 3011: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

3007: Prj_BASE_RAW_COST,Prj_BASE_BURDENED_COST,Prj_ORIG_RAW_COST,
3008: Prj_ORIG_BURDENED_COST,Prj_BASE_REVENUE,Prj_ORIG_REVENUE,
3009: Prj_BASE_LABOR_HOURS,Prj_ORIG_LABOR_HOURS,Prj_BASE_QUANTITY,
3010: Prj_ORIG_QUANTITY,
3011: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
3012: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
3013: x_fin_plan_type_id
3014: );
3015: end if;

Line 3012: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,

3008: Prj_ORIG_BURDENED_COST,Prj_BASE_REVENUE,Prj_ORIG_REVENUE,
3009: Prj_BASE_LABOR_HOURS,Prj_ORIG_LABOR_HOURS,Prj_BASE_QUANTITY,
3010: Prj_ORIG_QUANTITY,
3011: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
3012: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login,
3013: x_fin_plan_type_id
3014: );
3015: end if;
3016: end if;