APPS.PA_BUDGET_MATRIX_LINES_V_PKG dependencies on PA_BUDGET_LINES

Line 62: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

58: new_rowid varchar2(18);
59:
60:
61: /* FPB2: MRC */
62: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
63: l_return_status VARCHAR2(1);
64: l_msg_data VARCHAR2(2000);
65: l_msg_count NUMBER;
66:

Line 82: UPDATE pa_budget_lines

78: RAISE FND_API.G_EXC_ERROR;
79: END IF;
80: */
81:
82: UPDATE pa_budget_lines
83: SET
84: start_date = X_Start_Date,
85: last_update_date = X_Last_Update_Date,
86: last_updated_by = X_Last_Updated_By,

Line 156: DELETE FROM pa_budget_lines

152:
153: l_budget_line_id := Null; /* Since even if delete doesnt delete any rows, the value in
154: l_budget_line_id will be retained. */
155:
156: DELETE FROM pa_budget_lines
157: WHERE rowid = X_Rowid
158: and ((quantity is null) and (raw_cost is null) and (burdened_cost is null) and (revenue is null))
159: returning budget_line_id into l_budget_line_id;
160:

Line 195: from pa_budget_lines

191: delete pa_resource_assignments
192: where resource_assignment_id = x_resource_assignment_id
193: and not exists
194: (select 1
195: from pa_budget_lines
196: where resource_assignment_id = x_resource_assignment_id);
197:
198:
199: END Update_Row;

Line 219: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;

215: x_last_updated_by number;
216: x_last_update_login number;
217:
218: /* FPB2: MRC */
219: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
220: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
221: l_return_status VARCHAR2(1);
222: l_msg_data VARCHAR2(2000);
223: l_msg_count NUMBER;

Line 220: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;

216: x_last_update_login number;
217:
218: /* FPB2: MRC */
219: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
220: l_budget_version_id PA_BUDGET_LINES.BUDGET_VERSION_ID%type;
221: l_return_status VARCHAR2(1);
222: l_msg_data VARCHAR2(2000);
223: l_msg_count NUMBER;
224:

Line 238: UPDATE pa_budget_lines

234: RAISE FND_API.G_EXC_ERROR;
235: END IF;
236: */
237:
238: UPDATE pa_budget_lines
239: SET
240: last_update_date = sysdate,
241: last_updated_by = X_Last_Updated_By,
242: last_update_login = X_Last_Update_Login,

Line 285: from pa_budget_lines

281: */
282:
283: select resource_assignment_id
284: into x_resource_assignment_id
285: from pa_budget_lines
286: WHERE rowid = X_Rowid;
287:
288: DELETE FROM pa_budget_lines
289: WHERE rowid = X_Rowid

Line 288: DELETE FROM pa_budget_lines

284: into x_resource_assignment_id
285: from pa_budget_lines
286: WHERE rowid = X_Rowid;
287:
288: DELETE FROM pa_budget_lines
289: WHERE rowid = X_Rowid
290: and ((quantity is null) and (raw_cost is null) and (burdened_cost is null) and (revenue is null))
291: returning budget_line_id into l_budget_line_id;
292:

Line 327: from pa_budget_lines

323: delete pa_resource_assignments
324: where resource_assignment_id = x_resource_assignment_id
325: and not exists
326: (select 1
327: from pa_budget_lines
328: where resource_assignment_id = x_resource_assignment_id);
329: Exception
330: When no_data_found then
331: null;

Line 402: pa_budget_lines l

398: a.resource_list_member_id,
399: a.unit_of_measure,
400: a.track_as_labor_flag
401: FROM pa_resource_assignments a,
402: pa_budget_lines l
403: WHERE l.rowid = X_Rowid
404: AND l.resource_assignment_id = a.resource_assignment_id
405: FOR UPDATE NOWAIT;
406: Recinfo C%ROWTYPE;