APPS.PA_MAINT_PROJECT_ACCUMS dependencies on PA_PROJECT_ACCUM_BUDGETS

Line 3244: -- This Procedure Initializes the figures in the PA_PROJECT_ACCUM_BUDGETS

3240: x_err_code := SQLCODE;
3241: RAISE;
3242: End Initialize_actuals;
3243:
3244: -- This Procedure Initializes the figures in the PA_PROJECT_ACCUM_BUDGETS
3245: -- Table. The Initialization will happen in case the current period is
3246: -- greater than the previously accumulated period. The procedure would
3247: -- be called only if the run-mod is 'I' (Incremental) .Also,the initialization
3248: -- would be done only for those budget-types which are not being

Line 3306: Update PA_PROJECT_ACCUM_BUDGETS SET

3302:
3303: If x_current_start_date > x_prev_accum_start_date then
3304: If X_prev_period = x_prev_accum_period then
3305: If x_current_year > x_prev_accum_year then
3306: Update PA_PROJECT_ACCUM_BUDGETS SET
3307: BASE_RAW_COST_YTD = 0,
3308: BASE_RAW_COST_PP = BASE_RAW_COST_PTD,
3309: BASE_RAW_COST_PTD = 0,
3310: ORIG_RAW_COST_YTD = 0,

Line 3342: Update PA_PROJECT_ACCUM_BUDGETS SET

3338: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3339: PAH.Project_Id = x_project_id) And
3340: Budget_Type_Code <> Nvl(x_budget_type,'00');
3341: Else
3342: Update PA_PROJECT_ACCUM_BUDGETS SET
3343: BASE_RAW_COST_PP = BASE_RAW_COST_PTD,
3344: BASE_RAW_COST_PTD = 0,
3345: ORIG_RAW_COST_PP = ORIG_RAW_COST_PTD,
3346: ORIG_RAW_COST_PTD = 0,

Line 3371: Update PA_PROJECT_ACCUM_BUDGETS SET

3367: Budget_Type_Code <> Nvl(x_budget_type,'00');
3368: End If;
3369: ElsIf X_prev_start_date > x_prev_accum_start_date then
3370: If x_current_year > x_prev_accum_year then
3371: Update PA_PROJECT_ACCUM_BUDGETS SET
3372: BASE_RAW_COST_YTD = 0,
3373: BASE_RAW_COST_PP = 0,
3374: BASE_RAW_COST_PTD = 0,
3375: ORIG_RAW_COST_YTD = 0,

Line 3407: Update PA_PROJECT_ACCUM_BUDGETS SET

3403: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3404: PAH.Project_Id = x_project_id) And
3405: Budget_Type_Code <> Nvl(x_budget_type,'00');
3406: Else
3407: Update PA_PROJECT_ACCUM_BUDGETS SET
3408: BASE_RAW_COST_PP = 0,
3409: BASE_RAW_COST_PTD = 0,
3410: ORIG_RAW_COST_PP = 0,
3411: ORIG_RAW_COST_PTD = 0,