DBA Data[Home] [Help]

APPS.FA_RES_LDG_PKG dependencies on FA_RESERVE_LEDGER_GT

Line 289: OPERATION := 'Inserting into FA_RESERVE_LEDGER_GT';

285: ,DP.period_close_date
286: ,DP.period_counter;
287: END IF;
288:
289: OPERATION := 'Inserting into FA_RESERVE_LEDGER_GT';
290:
291: -- run only if CRL not installed
292: IF (NVL(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) THEN
293:

Line 296: INSERT INTO FA_RESERVE_LEDGER_GT

292: IF (NVL(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) THEN
293:
294: IF (h_reporting_flag = 'R') THEN
295: --FND_FILE.PUT_LINE(FND_FILE.LOG,'1)INSERT INTO ');
296: INSERT INTO FA_RESERVE_LEDGER_GT
297: (asset_id
298: ,dh_ccid
299: ,deprn_reserve_acct
300: ,date_placed_in_service

Line 437: INSERT INTO FA_RESERVE_LEDGER_GT

433: AND DH.date_effective <= ucd
434: AND NVL(DH.date_ineffective, SYSDATE) > tod;
435: ELSE
436: --FND_FILE.PUT_LINE(FND_FILE.LOG,'2)INSERT INTO ');
437: INSERT INTO FA_RESERVE_LEDGER_GT
438: (asset_id
439: ,dh_ccid
440: ,deprn_reserve_acct
441: ,date_placed_in_service

Line 580: INSERT INTO FA_RESERVE_LEDGER_GT

576: ELSIF (NVL(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) THEN
577:
578: IF (h_reporting_flag = 'R') THEN
579: --FND_FILE.PUT_LINE(FND_FILE.LOG,'3)INSERT INTO ');
580: INSERT INTO FA_RESERVE_LEDGER_GT
581: (asset_id
582: ,dh_ccid
583: ,deprn_reserve_acct
584: ,date_placed_in_service

Line 657: INSERT INTO FA_RESERVE_LEDGER_GT

653: AND NVL(DH.date_ineffective, SYSDATE) > tod
654: AND BOOKS.group_asset_id IS NULL;
655: ELSE
656: --FND_FILE.PUT_LINE(FND_FILE.LOG,'4)INSERT INTO ');
657: INSERT INTO FA_RESERVE_LEDGER_GT
658: (asset_id
659: ,dh_ccid
660: ,deprn_reserve_acct
661: ,date_placed_in_service

Line 733: INSERT INTO FA_RESERVE_LEDGER_GT

729: AND BOOKS.group_asset_id IS NULL;
730: END IF;
731: IF (h_reporting_flag = 'R') THEN
732: --FND_FILE.PUT_LINE(FND_FILE.LOG,'5)INSERT INTO ');
733: INSERT INTO FA_RESERVE_LEDGER_GT
734: (asset_id
735: ,dh_ccid
736: ,deprn_reserve_acct
737: ,date_placed_in_service

Line 790: INSERT INTO FA_RESERVE_LEDGER_GT

786: AND GAR.date_effective <= DP.calendar_period_close_date
787: AND NVL(GAR.date_ineffective, (DP.calendar_period_close_date + 1))> DP.calendar_period_close_date;
788: ELSE
789: --FND_FILE.PUT_LINE(FND_FILE.LOG,'6)INSERT INTO ');
790: INSERT INTO FA_RESERVE_LEDGER_GT
791: (asset_id
792: ,dh_ccid
793: ,deprn_reserve_acct
794: ,date_placed_in_service

Line 852: INSERT INTO FA_RESERVE_LEDGER_GT

848:
849:
850: IF (h_reporting_flag = 'R') THEN
851: --FND_FILE.PUT_LINE(FND_FILE.LOG,'7)INSERT INTO ');
852: INSERT INTO FA_RESERVE_LEDGER_GT
853: (asset_id
854: ,dh_ccid
855: ,deprn_reserve_acct
856: ,date_placed_in_service

Line 911: INSERT INTO FA_RESERVE_LEDGER_GT

907: AND SGR.date_effective <= DP.calendar_period_close_date
908: AND nvl(SGR.date_ineffective, (DP.calendar_period_close_date + 1))> DP.calendar_period_close_date;
909: ELSE
910: --FND_FILE.PUT_LINE(FND_FILE.LOG,'8)INSERT INTO ');
911: INSERT INTO FA_RESERVE_LEDGER_GT
912: (asset_id
913: ,dh_ccid
914: ,deprn_reserve_acct
915: ,date_placed_in_service