APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_BUDGET_LINES

Line 1355: DELETE FROM pa_budget_lines

1351: END IF;
1352: /* end if for chking gen src code not equal to resource schedule */
1353:
1354: IF p_ret_manual_lns_flag = 'N' THEN
1355: DELETE FROM pa_budget_lines
1356: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1357:
1358: DELETE FROM pa_resource_assignments
1359: WHERE budget_version_id = P_BUDGET_VERSION_ID;

Line 1424: DELETE FROM PA_BUDGET_LINES

1420: transaction_source_code IS NOT NULL;
1421:
1422: IF (l_res_asg_id_del_tab.count > 0) THEN
1423: FORALL i IN 1 .. l_res_asg_id_del_tab.count
1424: DELETE FROM PA_BUDGET_LINES
1425: WHERE resource_assignment_id = l_res_asg_id_del_tab(i);
1426:
1427: FORALL j IN 1 .. l_res_asg_id_del_tab.count
1428: UPDATE PA_RESOURCE_ASSIGNMENTS

Line 1478: DELETE FROM pa_budget_lines

1474: END IF; --IF (l_res_asg_id_del_tab.count > 0) THEN
1475:
1476: /* Clean up actuals budget line data. */
1477: IF l_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1478: DELETE FROM pa_budget_lines
1479: WHERE budget_version_id = p_budget_version_id
1480: AND start_date <= p_actuals_thru_date;
1481: ELSIF l_fp_cols_rec.x_time_phased_code = 'N' THEN
1482: UPDATE pa_budget_lines

Line 1482: UPDATE pa_budget_lines

1478: DELETE FROM pa_budget_lines
1479: WHERE budget_version_id = p_budget_version_id
1480: AND start_date <= p_actuals_thru_date;
1481: ELSIF l_fp_cols_rec.x_time_phased_code = 'N' THEN
1482: UPDATE pa_budget_lines
1483: SET quantity = quantity - NVL(init_quantity,0),
1484: raw_cost = raw_cost - NVL(init_raw_cost,0),
1485: burdened_cost = burdened_cost - NVL(init_burdened_cost,0),
1486: revenue = revenue - NVL(init_revenue,0),

Line 1499: UPDATE pa_budget_lines

1495: l_last_updated_by := FND_GLOBAL.USER_ID;
1496: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1497: l_sysdate := SYSDATE;
1498:
1499: UPDATE pa_budget_lines
1500: SET init_quantity = null,
1501: init_raw_cost = null,
1502: init_burdened_cost = null,
1503: init_revenue = null,