APPS.FA_DEPRN_DETAIL_PKG dependencies on FA_MC_DEPRN_DETAIL

Line 38: CURSOR C_dd_mc IS SELECT rowid FROM fa_mc_deprn_detail

34: CURSOR C_dd IS SELECT rowid FROM fa_deprn_detail
35: WHERE distribution_id = X_Distribution_Id
36: AND book_type_code = X_Book_Type_Code
37: AND period_counter = X_Period_Counter;
38: CURSOR C_dd_mc IS SELECT rowid FROM fa_mc_deprn_detail
39: WHERE distribution_id = X_Distribution_Id
40: AND book_type_code = X_Book_Type_Code
41: AND period_counter = X_Period_Counter
42: AND set_of_books_id = X_set_of_books_id;

Line 48: INSERT INTO fa_mc_deprn_detail(

44: BEGIN
45:
46: if (X_mrc_sob_type_code = 'R') then
47:
48: INSERT INTO fa_mc_deprn_detail(
49: set_of_books_id,
50: book_type_code,
51: asset_id,
52: period_counter,

Line 334: UPDATE fa_mc_deprn_detail

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

Line 511: UPDATE fa_mc_deprn_detail

507: WHERE rowid = X_Rowid;
508: end if;
509: else
510: if (X_mrc_sob_type_code = 'R') then
511: UPDATE fa_mc_deprn_detail
512: SET
513: book_type_code = decode(X_Book_Type_Code,
514: NULL, book_type_code,
515: FND_API.G_MISS_CHAR, null,

Line 722: DELETE FROM fa_mc_deprn_detail

718: BEGIN
719:
720: if (X_mrc_sob_type_code = 'R') then
721: if X_Rowid is not null then
722: DELETE FROM fa_mc_deprn_detail
723: WHERE rowid = X_Rowid;
724: elsif X_Asset_Id is not null then
725: DELETE FROM fa_mc_deprn_detail
726: WHERE asset_id = X_Asset_Id

Line 725: DELETE FROM fa_mc_deprn_detail

721: if X_Rowid is not null then
722: DELETE FROM fa_mc_deprn_detail
723: WHERE rowid = X_Rowid;
724: elsif X_Asset_Id is not null then
725: DELETE FROM fa_mc_deprn_detail
726: WHERE asset_id = X_Asset_Id
727: AND set_of_books_id = X_set_of_books_id;
728: else
729: -- error message