APPS.FA_INS_DETAIL_PKG dependencies on FA_DEPRN_DETAIL

Line 185: FROM fa_deprn_detail

181: else
182:
183: SELECT sum(nvl(deprn_adjustment_amount,0))
184: INTO h_deprn_adjustment_amount
185: FROM fa_deprn_detail
186: WHERE book_type_code = X_book_type_code
187: AND asset_id = X_asset_id
188: AND deprn_source_code = 'B';
189:

Line 481: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.

477: h_dist_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
478:
479: h_msg_name := 'FA_SHARED_DATA_ERR_DH';
480:
481: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
482: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */
483: IF X_mrc_sob_type_code = 'R' THEN
484: SELECT COUNT(*)
485: INTO h_count

Line 493: FROM FA_DEPRN_DETAIL

489: period_counter = h_period_counter;
490: ELSE
491: SELECT COUNT(*)
492: INTO h_count
493: FROM FA_DEPRN_DETAIL
494: WHERE book_type_code = h_book_type_code AND
495: asset_id = h_asset_id AND
496: period_counter = h_period_counter;
497: END IF;

Line 565: DELETE FROM fa_deprn_detail

561: asset_id = h_asset_id AND
562: period_counter = h_period_counter AND
563: set_of_books_id = X_set_of_books_id;
564: else
565: DELETE FROM fa_deprn_detail
566: WHERE book_type_code = h_book_type_code AND
567: asset_id = h_asset_id AND
568: period_counter = h_period_counter;
569: end if; -- end mrc

Line 586: -- Insert rows into fa_deprn_detail for the

582: h_sysdate := sysdate;
583: END IF;
584:
585: -- Bug 5984105 -- Start
586: -- Insert rows into fa_deprn_detail for the
587: -- transfered out distributions
588: h_full_ytd := X_dpr_dtl.ytd;
589:
590: if (p_log_level_rec.statement_level) then

Line 623: FROM fa_deprn_detail

619: and set_of_books_id = X_set_of_books_id;
620: else
621: SELECT ytd_deprn
622: INTO h_part_ytd
623: FROM fa_deprn_detail
624: WHERE book_type_code = h_book_type_code
625: and asset_id = h_asset_id
626: and distribution_id = h_dist_id
627: and period_counter = (select max(period_counter)

Line 628: from fa_deprn_detail fdd2

624: WHERE book_type_code = h_book_type_code
625: and asset_id = h_asset_id
626: and distribution_id = h_dist_id
627: and period_counter = (select max(period_counter)
628: from fa_deprn_detail fdd2
629: where fdd2.asset_id = h_asset_id
630: and fdd2.book_type_code = h_book_type_code
631: and fdd2.distribution_id = h_dist_id);
632: end if;

Line 704: INSERT INTO fa_deprn_detail(

700: 0,
701: 0);
702:
703: else
704: INSERT INTO fa_deprn_detail(
705: BOOK_TYPE_CODE,
706: ASSET_ID,
707: DISTRIBUTION_ID,
708: PERIOD_COUNTER,

Line 784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.

780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
785: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */
786: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Brahma2 before Loop','BRAHMA',p_log_level_rec => p_log_level_rec);
787: IF h_count > 0 THEN
788: IF X_mrc_sob_type_code = 'R' THEN

Line 1126: INSERT INTO fa_deprn_detail(BOOK_TYPE_CODE,

1122: h_part_general_fund);
1123:
1124: else
1125:
1126: INSERT INTO fa_deprn_detail(BOOK_TYPE_CODE,
1127: ASSET_ID,
1128: DISTRIBUTION_ID,
1129: PERIOD_COUNTER,
1130: DEPRN_RUN_DATE,