APPS.FA_DEFERRED_DEPRN_PKG dependencies on FA_DEFERRED_DEPRN

Line 1: PACKAGE BODY fa_deferred_deprn_pkg AS

1: PACKAGE BODY fa_deferred_deprn_pkg AS
2: /* $Header: FAXDEFB.pls 120.8.12010000.2 2009/01/20 15:35:13 bridgway ship $ */
3:
4: ---------------------------------------------------
5: -- Declaration of global variables --

Line 17: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_deferred_deprn_pkg.';

13: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
15: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16:
17: G_MODULE_NAME CONSTANT VARCHAR2(50):= 'fa.plsql.fa_deferred_deprn_pkg.';
18:
19: TYPE number_tbl_type IS TABLE OF number INDEX BY BINARY_INTEGER;
20: TYPE char_tbl_type IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
21: TYPE rowid_tbl_type IS TABLE OF varchar2(64) INDEX BY BINARY_INTEGER;

Line 276: 'bulk inserting into fa_deferred_deprn*' || p_mrc_sob_type_code);

272:
273: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
274: fnd_log.string(G_LEVEL_STATEMENT,
275: G_MODULE_NAME||l_procedure_name,
276: 'bulk inserting into fa_deferred_deprn*' || p_mrc_sob_type_code);
277: END IF;
278:
279: if (p_mrc_sob_type_code = 'R') then
280:

Line 282: INSERT INTO FA_DEFERRED_DEPRN_MRC_V

278:
279: if (p_mrc_sob_type_code = 'R') then
280:
281: FORALL i in 1..l_asset_id.count
282: INSERT INTO FA_DEFERRED_DEPRN_MRC_V
283: (set_of_books_id,
284: corp_book_type_code,
285: tax_book_type_code,
286: asset_id,

Line 315: INSERT INTO FA_DEFERRED_DEPRN

311: 0);
312:
313: else
314: FORALL i in 1..l_asset_id.count
315: INSERT INTO FA_DEFERRED_DEPRN
316: (corp_book_type_code,
317: tax_book_type_code,
318: asset_id,
319: distribution_id,

Line 419: from fa_deferred_deprn

415: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
416:
417: cursor c_deferred_events is
418: select asset_id, min(rowid)
419: from fa_deferred_deprn
420: where corp_book_type_code = p_corp_book
421: and tax_book_type_code = p_tax_book
422: and corp_period_counter = p_corp_period_counter
423: and tax_period_counter = p_tax_period_counter

Line 525: 'bulk inserting into fa_deferred_deprn_events');

521:
522: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
523: fnd_log.string(G_LEVEL_STATEMENT,
524: G_MODULE_NAME||l_procedure_name,
525: 'bulk inserting into fa_deferred_deprn_events');
526: END IF;
527:
528: FORALL l_count in 1..l_asset_id_tbl.count
529: INSERT into fa_deferred_deprn_events

Line 529: INSERT into fa_deferred_deprn_events

525: 'bulk inserting into fa_deferred_deprn_events');
526: END IF;
527:
528: FORALL l_count in 1..l_asset_id_tbl.count
529: INSERT into fa_deferred_deprn_events
530: (asset_id ,
531: corp_book_type_code ,
532: tax_book_type_code ,
533: corp_period_counter ,

Line 548: 'bulk updating fa_deferred_deprn with event ids');

544:
545: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
546: fnd_log.string(G_LEVEL_STATEMENT,
547: G_MODULE_NAME||l_procedure_name,
548: 'bulk updating fa_deferred_deprn with event ids');
549: END IF;
550:
551: FORALL l_count in 1..l_asset_id_tbl.count
552: update fa_deferred_deprn

Line 552: update fa_deferred_deprn

548: 'bulk updating fa_deferred_deprn with event ids');
549: END IF;
550:
551: FORALL l_count in 1..l_asset_id_tbl.count
552: update fa_deferred_deprn
553: set event_id = l_event_id_tbl(l_count)
554: where asset_id = l_asset_id_tbl(l_count)
555: AND corp_book_type_code = p_corp_book
556: AND tax_book_type_code = p_tax_book

Line 656: 'bulk inserting into fa_deferred_deprn_events');

652:
653: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
654: fnd_log.string(G_LEVEL_STATEMENT,
655: G_MODULE_NAME||l_procedure_name,
656: 'bulk inserting into fa_deferred_deprn_events');
657: END IF;
658:
659: FORALL l_count in 1..l_asset_id_tbl.count
660: INSERT into fa_deferred_deprn_events

Line 660: INSERT into fa_deferred_deprn_events

656: 'bulk inserting into fa_deferred_deprn_events');
657: END IF;
658:
659: FORALL l_count in 1..l_asset_id_tbl.count
660: INSERT into fa_deferred_deprn_events
661: (asset_id ,
662: corp_book_type_code ,
663: tax_book_type_code ,
664: corp_period_counter ,

Line 872: END FA_DEFERRED_DEPRN_PKG;

868: retcode := 2;
869:
870: end do_deferred;
871:
872: END FA_DEFERRED_DEPRN_PKG;