31: WHERE asset_id = X_Asset_Id
32: AND book_type_code = X_Book_Type_Code
33: AND period_counter = X_Period_Counter;
34:
35: CURSOR C_ds_mc IS SELECT rowid FROM fa_deprn_summary_mrc_v
36: WHERE asset_id = X_Asset_Id
37: AND book_type_code = X_Book_Type_Code
38: AND period_counter = X_Period_Counter;
39:
41: BEGIN
42:
43: if (X_mrc_sob_type_code = 'R') then
44:
45: INSERT INTO fa_deprn_summary_mrc_v(
46: book_type_code,
47: asset_id,
48: deprn_run_date,
49: deprn_amount,
300: if (X_rowid is not null) then
301:
302: if (X_mrc_sob_type_code = 'R') then
303:
304: UPDATE fa_deprn_summary_mrc_v
305: SET
306: book_type_code = decode(X_Book_Type_Code,
307: NULL, book_type_code,
308: FND_API.G_MISS_CHAR, null,
482:
483: else -- rowid is null (use asset,book,pc)
484:
485: if (X_mrc_sob_type_code = 'R') then
486: UPDATE fa_deprn_summary_mrc_v
487: SET
488: book_type_code = decode(X_Book_Type_Code,
489: NULL, book_type_code,
490: FND_API.G_MISS_CHAR, null,
692: BEGIN
693:
694: if (X_mrc_sob_type_code = 'R') then
695: if X_Rowid is not null then
696: DELETE FROM fa_deprn_summary_mrc_v
697: WHERE rowid = X_Rowid;
698: elsif X_Asset_Id is not null then
699: DELETE FROM fa_deprn_summary_mrc_v
700: WHERE asset_id = X_Asset_Id;
695: if X_Rowid is not null then
696: DELETE FROM fa_deprn_summary_mrc_v
697: WHERE rowid = X_Rowid;
698: elsif X_Asset_Id is not null then
699: DELETE FROM fa_deprn_summary_mrc_v
700: WHERE asset_id = X_Asset_Id;
701: else
702: -- print error message
703: null;