DBA Data[Home] [Help]

APPS.FA_DEPRN_DETAIL_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

Line 46: INSERT INTO fa_deprn_detail_mrc_v(

42: BEGIN
43:
44: if (X_mrc_sob_type_code = 'R') then
45:
46: INSERT INTO fa_deprn_detail_mrc_v(
47: book_type_code,
48: asset_id,
49: period_counter,
50: distribution_id,

Line 330: UPDATE fa_deprn_detail_mrc_v

326:
327: if (X_rowid is not null) then
328:
329: if (X_mrc_sob_type_code = 'R') then
330: UPDATE fa_deprn_detail_mrc_v
331: SET
332: book_type_code = decode(X_Book_Type_Code,
333: NULL, book_type_code,
334: FND_API.G_MISS_CHAR, null,

Line 507: UPDATE fa_deprn_detail_mrc_v

503: WHERE rowid = X_Rowid;
504: end if;
505: else
506: if (X_mrc_sob_type_code = 'R') then
507: UPDATE fa_deprn_detail_mrc_v
508: SET
509: book_type_code = decode(X_Book_Type_Code,
510: NULL, book_type_code,
511: FND_API.G_MISS_CHAR, null,

Line 718: DELETE FROM fa_deprn_detail_mrc_v

714: BEGIN
715:
716: if (X_mrc_sob_type_code = 'R') then
717: if X_Rowid is not null then
718: DELETE FROM fa_deprn_detail_mrc_v
719: WHERE rowid = X_Rowid;
720: elsif X_Asset_Id is not null then
721: DELETE FROM fa_deprn_detail_mrc_v
722: WHERE asset_id = X_Asset_Id;

Line 721: DELETE FROM fa_deprn_detail_mrc_v

717: if X_Rowid is not null then
718: DELETE FROM fa_deprn_detail_mrc_v
719: WHERE rowid = X_Rowid;
720: elsif X_Asset_Id is not null then
721: DELETE FROM fa_deprn_detail_mrc_v
722: WHERE asset_id = X_Asset_Id;
723: else
724: -- error message
725: null;