eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.17.12020000.2 2012/07/19 11:23:14 mswetha 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: g_log_level_rec fa_api_types.log_level_rec_type;
20:
21: TYPE number_tbl_type IS TABLE OF number INDEX BY BINARY_INTEGER;

Line 271: from fa_deferred_deprn def

267: AND AJ.Adjustment_Type (+) = 'RESERVE'
268: AND nvl(AJ.Track_Member_Flag,'N') = 'N'
269: AND exists
270: (select 1
271: from fa_deferred_deprn def
272: where def.asset_id = AJ.asset_id
273: and def.corp_book_type_code = p_corp_book
274: and def.tax_book_type_code = p_tax_book
275: and def.corp_period_counter = p_corp_period_ctr

Line 301: from fa_deferred_deprn def

297: AND AJ.Adjustment_Type (+) = 'RESERVE'
298: AND nvl(AJ.Track_Member_Flag,'N') = 'N'
299: AND exists
300: (select 1
301: from fa_deferred_deprn def
302: where def.asset_id = AJ.asset_id
303: and def.corp_book_type_code = p_corp_book
304: and def.tax_book_type_code = p_tax_book
305: and def.corp_period_counter = p_corp_period_ctr

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

390:
391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
392: fnd_log.string(G_LEVEL_STATEMENT,
393: G_MODULE_NAME||l_procedure_name,
394: 'bulk inserting into fa_deferred_deprn*' || p_mrc_sob_type_code);
395: END IF;
396:
397: if (p_mrc_sob_type_code = 'R') then
398:

Line 430: INSERT INTO FA_DEFERRED_DEPRN

426: 0,
427: 0);
428: else
429: FORALL i in 1..l_asset_id.count
430: INSERT INTO FA_DEFERRED_DEPRN
431: (corp_book_type_code,
432: tax_book_type_code,
433: asset_id,
434: distribution_id,

Line 566: 'bulk updating fa_deferred_deprn for corp adj' || p_mrc_sob_type_code);

562:
563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
564: fnd_log.string(G_LEVEL_STATEMENT,
565: G_MODULE_NAME||l_procedure_name,
566: 'bulk updating fa_deferred_deprn for corp adj' || p_mrc_sob_type_code);
567: END IF;
568:
569:
570: if (p_mrc_sob_type_code = 'R') then

Line 587: UPDATE FA_DEFERRED_DEPRN

583:
584: else
585:
586: FORALL i in 1..l_asset_id.count
587: UPDATE FA_DEFERRED_DEPRN
588: SET deferred_deprn_expense_amount = deferred_deprn_expense_amount + l_rsv_adj(i),
589: deferred_deprn_reserve_amount = deferred_deprn_reserve_amount + l_rsv_adj(i)
590: WHERE corp_book_type_code = p_corp_book
591: AND tax_book_type_code = p_tax_book

Line 676: from fa_deferred_deprn

672: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
673:
674: cursor c_deferred_events is
675: select asset_id, min(rowid)
676: from fa_deferred_deprn
677: where corp_book_type_code = p_corp_book
678: and tax_book_type_code = p_tax_book
679: and corp_period_counter = p_corp_period_counter
680: and tax_period_counter = p_tax_period_counter

Line 787: 'bulk inserting into fa_deferred_deprn_events');

783:
784: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
785: fnd_log.string(G_LEVEL_STATEMENT,
786: G_MODULE_NAME||l_procedure_name,
787: 'bulk inserting into fa_deferred_deprn_events');
788: END IF;
789:
790: FORALL l_count in 1..l_asset_id_tbl.count
791: INSERT into fa_deferred_deprn_events

Line 791: INSERT into fa_deferred_deprn_events

787: 'bulk inserting into fa_deferred_deprn_events');
788: END IF;
789:
790: FORALL l_count in 1..l_asset_id_tbl.count
791: INSERT into fa_deferred_deprn_events
792: (asset_id ,
793: corp_book_type_code ,
794: tax_book_type_code ,
795: corp_period_counter ,

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

806:
807: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
808: fnd_log.string(G_LEVEL_STATEMENT,
809: G_MODULE_NAME||l_procedure_name,
810: 'bulk updating fa_deferred_deprn with event ids');
811: END IF;
812:
813: FORALL l_count in 1..l_asset_id_tbl.count
814: update fa_deferred_deprn

Line 814: update fa_deferred_deprn

810: 'bulk updating fa_deferred_deprn with event ids');
811: END IF;
812:
813: FORALL l_count in 1..l_asset_id_tbl.count
814: update fa_deferred_deprn
815: set event_id = l_event_id_tbl(l_count)
816: where asset_id = l_asset_id_tbl(l_count)
817: AND corp_book_type_code = p_corp_book
818: AND tax_book_type_code = p_tax_book

Line 920: 'bulk inserting into fa_deferred_deprn_events');

916:
917: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
918: fnd_log.string(G_LEVEL_STATEMENT,
919: G_MODULE_NAME||l_procedure_name,
920: 'bulk inserting into fa_deferred_deprn_events');
921: END IF;
922:
923: FORALL l_count in 1..l_asset_id_tbl.count
924: INSERT into fa_deferred_deprn_events

Line 924: INSERT into fa_deferred_deprn_events

920: 'bulk inserting into fa_deferred_deprn_events');
921: END IF;
922:
923: FORALL l_count in 1..l_asset_id_tbl.count
924: INSERT into fa_deferred_deprn_events
925: (asset_id ,
926: corp_book_type_code ,
927: tax_book_type_code ,
928: corp_period_counter ,

Line 1093: from fa_deferred_deprn

1089: begin
1090:
1091: select 1
1092: into l_deferred_exists_count
1093: from fa_deferred_deprn
1094: where tax_book_type_code = p_tax_book_type_code
1095: and corp_book_type_code =
1096: fa_cache_pkg.fazcbc_record.distribution_source_book
1097: and tax_period_counter = l_tax_period_counter

Line 1196: END FA_DEFERRED_DEPRN_PKG;

1192: retcode := 2;
1193:
1194: end do_deferred;
1195:
1196: END FA_DEFERRED_DEPRN_PKG;