DBA Data[Home] [Help]

APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_DEFERRED_DEPRN

Line 437: from fa_deferred_deprn

433: p_tax_period_counter number
434: ) IS
435: select rowid,
436: asset_id
437: from fa_deferred_deprn
438: where corp_book_type_code = p_corp_book_type_code
439: and tax_book_type_code = p_tax_book_type_code
440: and corp_period_counter = p_corp_period_counter
441: and tax_period_counter = p_tax_period_counter

Line 517: UPDATE FA_DEFERRED_DEPRN

513: p_calling_fn => l_calling_fn,
514: p_log_level_rec => g_log_level_rec);
515:
516: FORALL l_count in 1..l_asset_id_tbl.count
517: UPDATE FA_DEFERRED_DEPRN
518: SET event_id = l_event_id_tbl(l_count)
519: WHERE rowid = l_rowid_tbl(l_count);
520:
521: -- now process all matching mrc rows

Line 535: INSERT into fa_deferred_deprn_events

531: commit;
532:
533:
534: FORALL l_count in 1..l_asset_id_tbl.count
535: INSERT into fa_deferred_deprn_events
536: (asset_id ,
537: corp_book_type_code ,
538: tax_book_type_code ,
539: corp_period_counter ,

Line 617: INSERT into fa_deferred_deprn_events

613: AND tax_period_counter = p_tax_period_counter;
614:
615:
616: FORALL l_count in 1..l_asset_id_tbl.count
617: INSERT into fa_deferred_deprn_events
618: (asset_id ,
619: corp_book_type_code ,
620: tax_book_type_code ,
621: corp_period_counter ,