DBA Data[Home] [Help]

APPS.FA_ADJUSTMENTS_PKG dependencies on FA_MC_ADJUSTMENTS

Line 32: INSERT INTO fa_mc_adjustments(

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

Line 261: UPDATE fa_mc_adjustments

257:
258: BEGIN
259:
260: if (X_mrc_sob_type_code = 'R') then
261: UPDATE fa_mc_adjustments
262: SET
263: transaction_header_id = X_Transaction_Header_Id,
264: source_type_code = X_Source_Type_Code,
265: adjustment_type = X_Adjustment_Type,

Line 329: DELETE FROM fa_mc_adjustments

325: BEGIN
326:
327: if (X_mrc_sob_type_code = 'R') then
328: if X_Rowid is not null then
329: DELETE FROM fa_mc_adjustments
330: WHERE rowid = X_Rowid;
331: elsif X_Asset_Id is not null then
332: DELETE FROM fa_mc_adjustments
333: WHERE asset_id = X_Asset_id

Line 332: DELETE FROM fa_mc_adjustments

328: if X_Rowid is not null then
329: DELETE FROM fa_mc_adjustments
330: WHERE rowid = X_Rowid;
331: elsif X_Asset_Id is not null then
332: DELETE FROM fa_mc_adjustments
333: WHERE asset_id = X_Asset_id
334: AND set_of_books_id = X_set_of_books_id;
335: end if;
336: else