DBA Data[Home] [Help]

APPS.FA_ADJUSTMENTS_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 31: INSERT INTO fa_adjustments_mrc_v(

27: BEGIN
28:
29: if (X_mrc_sob_type_code = 'R') then
30:
31: INSERT INTO fa_adjustments_mrc_v(
32: transaction_header_id,
33: source_type_code,
34: adjustment_type,
35: debit_credit_flag,

Line 257: UPDATE fa_adjustments_mrc_v

253:
254: BEGIN
255:
256: if (X_mrc_sob_type_code = 'R') then
257: UPDATE fa_adjustments_mrc_v
258: SET
259: transaction_header_id = X_Transaction_Header_Id,
260: source_type_code = X_Source_Type_Code,
261: adjustment_type = X_Adjustment_Type,

Line 279: UPDATE fa_adjustments_mrc_v

275: period_counter_created = X_Period_Counter_Created,
276: asset_invoice_id = X_Asset_Invoice_Id
277: WHERE rowid = X_Rowid;
278: else
279: UPDATE fa_adjustments_mrc_v
280: SET
281: transaction_header_id = X_Transaction_Header_Id,
282: source_type_code = X_Source_Type_Code,
283: adjustment_type = X_Adjustment_Type,

Line 326: DELETE FROM fa_adjustments_mrc_v

322: BEGIN
323:
324: if (X_mrc_sob_type_code = 'R') then
325: if X_Rowid is not null then
326: DELETE FROM fa_adjustments_mrc_v
327: WHERE rowid = X_Rowid;
328: elsif X_Asset_Id is not null then
329: DELETE FROM fa_adjustments_mrc_v
330: WHERE asset_id = X_Asset_id;

Line 329: DELETE FROM fa_adjustments_mrc_v

325: if X_Rowid is not null then
326: DELETE FROM fa_adjustments_mrc_v
327: WHERE rowid = X_Rowid;
328: elsif X_Asset_Id is not null then
329: DELETE FROM fa_adjustments_mrc_v
330: WHERE asset_id = X_Asset_id;
331: end if;
332: else
333: if X_Rowid is not null then