APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_BUDGET_LINES

Line 1082: DELETE FROM pa_budget_lines

1078: END IF;
1079: /* end if for chking gen src code not equal to resource schedule */
1080:
1081: IF p_ret_manual_lns_flag = 'N' THEN
1082: DELETE FROM pa_budget_lines
1083: WHERE budget_version_id = P_BUDGET_VERSION_ID;
1084:
1085: DELETE FROM pa_resource_assignments
1086: WHERE budget_version_id = P_BUDGET_VERSION_ID;

Line 1143: DELETE FROM PA_BUDGET_LINES

1139: transaction_source_code IS NOT NULL;
1140:
1141: IF (l_res_asg_id_del_tab.count > 0) THEN
1142: FORALL i IN 1 .. l_res_asg_id_del_tab.count
1143: DELETE FROM PA_BUDGET_LINES
1144: WHERE resource_assignment_id = l_res_asg_id_del_tab(i);
1145:
1146: FORALL j IN 1 .. l_res_asg_id_del_tab.count
1147: UPDATE PA_RESOURCE_ASSIGNMENTS

Line 1197: DELETE FROM pa_budget_lines

1193: END IF; --IF (l_res_asg_id_del_tab.count > 0) THEN
1194:
1195: /* Clean up actuals budget line data. */
1196: IF l_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1197: DELETE FROM pa_budget_lines
1198: WHERE budget_version_id = p_budget_version_id
1199: AND start_date <= p_actuals_thru_date;
1200: ELSIF l_fp_cols_rec.x_time_phased_code = 'N' THEN
1201: UPDATE pa_budget_lines

Line 1201: UPDATE pa_budget_lines

1197: DELETE FROM pa_budget_lines
1198: WHERE budget_version_id = p_budget_version_id
1199: AND start_date <= p_actuals_thru_date;
1200: ELSIF l_fp_cols_rec.x_time_phased_code = 'N' THEN
1201: UPDATE pa_budget_lines
1202: SET quantity = quantity - NVL(init_quantity,0),
1203: raw_cost = raw_cost - NVL(init_raw_cost,0),
1204: burdened_cost = burdened_cost - NVL(init_burdened_cost,0),
1205: revenue = revenue - NVL(init_revenue,0),

Line 1218: UPDATE pa_budget_lines

1214: l_last_updated_by := FND_GLOBAL.USER_ID;
1215: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1216: l_sysdate := SYSDATE;
1217:
1218: UPDATE pa_budget_lines
1219: SET init_quantity = null,
1220: init_raw_cost = null,
1221: init_burdened_cost = null,
1222: init_revenue = null,