APPS.FA_DEPRN_SUMMARY_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 40: CURSOR C_ds_mc IS SELECT rowid FROM fa_mc_deprn_summary

36: WHERE asset_id = X_Asset_Id
37: AND book_type_code = X_Book_Type_Code
38: AND period_counter = X_Period_Counter;
39:
40: CURSOR C_ds_mc IS SELECT rowid FROM fa_mc_deprn_summary
41: WHERE asset_id = X_Asset_Id
42: AND book_type_code = X_Book_Type_Code
43: AND period_counter = X_Period_Counter
44: AND set_of_books_id = X_set_of_books_id;

Line 51: INSERT INTO fa_mc_deprn_summary(

47: BEGIN
48:
49: if (X_mrc_sob_type_code = 'R') then
50:
51: INSERT INTO fa_mc_deprn_summary(
52: set_of_books_id,
53: book_type_code,
54: asset_id,
55: deprn_run_date,

Line 333: UPDATE fa_mc_deprn_summary

329: if (X_rowid is not null) then
330:
331: if (X_mrc_sob_type_code = 'R') then
332:
333: UPDATE fa_mc_deprn_summary
334: SET
335: book_type_code = decode(X_Book_Type_Code,
336: NULL, book_type_code,
337: FND_API.G_MISS_CHAR, null,

Line 538: UPDATE fa_mc_deprn_summary

534:
535: else -- rowid is null (use asset,book,pc)
536:
537: if (X_mrc_sob_type_code = 'R') then
538: UPDATE fa_mc_deprn_summary
539: SET
540: book_type_code = decode(X_Book_Type_Code,
541: NULL, book_type_code,
542: FND_API.G_MISS_CHAR, null,

Line 769: DELETE FROM fa_mc_deprn_summary

765: BEGIN
766:
767: if (X_mrc_sob_type_code = 'R') then
768: if X_Rowid is not null then
769: DELETE FROM fa_mc_deprn_summary
770: WHERE rowid = X_Rowid;
771: elsif X_Asset_Id is not null then
772: DELETE FROM fa_mc_deprn_summary
773: WHERE asset_id = X_Asset_Id

Line 772: DELETE FROM fa_mc_deprn_summary

768: if X_Rowid is not null then
769: DELETE FROM fa_mc_deprn_summary
770: WHERE rowid = X_Rowid;
771: elsif X_Asset_Id is not null then
772: DELETE FROM fa_mc_deprn_summary
773: WHERE asset_id = X_Asset_Id
774: AND set_of_books_id = X_set_of_books_id;
775: else
776: -- print error message