APPS.FA_DEFERRED_DEPRN_PKG dependencies on FA_MC_DEFERRED_DEPRN

Line 400: INSERT INTO FA_MC_DEFERRED_DEPRN

396:
397: if (p_mrc_sob_type_code = 'R') then
398:
399: FORALL i in 1..l_asset_id.count
400: INSERT INTO FA_MC_DEFERRED_DEPRN
401: (set_of_books_id,
402: corp_book_type_code,
403: tax_book_type_code,
404: asset_id,

Line 573: UPDATE FA_MC_DEFERRED_DEPRN

569:
570: if (p_mrc_sob_type_code = 'R') then
571:
572: FORALL i in 1..l_asset_id.count
573: UPDATE FA_MC_DEFERRED_DEPRN
574: SET deferred_deprn_expense_amount = deferred_deprn_expense_amount + l_rsv_adj(i),
575: deferred_deprn_reserve_amount = deferred_deprn_reserve_amount + l_rsv_adj(i)
576: WHERE set_of_books_id = l_tax_sob_id(i)
577: AND corp_book_type_code = p_corp_book

Line 686: from fa_mc_deferred_deprn

682: group by asset_id;
683:
684: cursor c_mc_deferred_events (p_set_of_books_id number) is
685: select asset_id, min(rowid)
686: from fa_mc_deferred_deprn
687: where corp_book_type_code = p_corp_book
688: and tax_book_type_code = p_tax_book
689: and corp_period_counter = p_corp_period_counter
690: and tax_period_counter = p_tax_period_counter

Line 825: 'bulk updating fa_mc_deferred_deprn with event ids');

821:
822: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
823: fnd_log.string(G_LEVEL_STATEMENT,
824: G_MODULE_NAME||l_procedure_name,
825: 'bulk updating fa_mc_deferred_deprn with event ids');
826: END IF;
827:
828: -- now process all matching mrc rows
829: FORALL l_count in 1..l_asset_id_tbl.count

Line 830: update fa_mc_deferred_deprn

826: END IF;
827:
828: -- now process all matching mrc rows
829: FORALL l_count in 1..l_asset_id_tbl.count
830: update fa_mc_deferred_deprn
831: SET event_id = l_event_id_tbl(l_count)
832: WHERE asset_id = l_asset_id_tbl(l_count)
833: AND corp_book_type_code = p_corp_book
834: AND tax_book_type_code = p_tax_book

Line 943: 'bulk updating fa_mc_deferred_deprn with event ids');

939:
940: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
941: fnd_log.string(G_LEVEL_STATEMENT,
942: G_MODULE_NAME||l_procedure_name,
943: 'bulk updating fa_mc_deferred_deprn with event ids');
944: END IF;
945:
946: FORALL l_count in 1..l_asset_id_tbl.count
947: UPDATE FA_MC_DEFERRED_DEPRN

Line 947: UPDATE FA_MC_DEFERRED_DEPRN

943: 'bulk updating fa_mc_deferred_deprn with event ids');
944: END IF;
945:
946: FORALL l_count in 1..l_asset_id_tbl.count
947: UPDATE FA_MC_DEFERRED_DEPRN
948: SET event_id = l_event_id_tbl(l_count)
949: WHERE asset_id = l_asset_id_tbl(l_count)
950: AND corp_book_type_code = p_corp_book
951: AND tax_book_type_code = p_tax_book