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.JL_CO_FA_PURGE_PKG dependencies on JL_CO_FA_ADJUSTMENTS

Line 37: -- Use this procedure to purge jl_co_fa_adjustments table --

33: -- PROCEDURE --
34: -- purge_adjustment --
35: -- --
36: -- DESCRIPTION --
37: -- Use this procedure to purge jl_co_fa_adjustments table --
38: -- --
39: -- PURPOSE: --
40: -- Oracle Applications Rel 11.0 --
41: -- --

Line 414: x_adj_table := 'JL_CO_FA_ADJUSTMENTS'||TO_CHAR(x_index);

410: FROM jl_co_fa_purge
411: WHERE book_type_code = p_book
412: AND fiscal_year = p_fiscal_year;
413:
414: x_adj_table := 'JL_CO_FA_ADJUSTMENTS'||TO_CHAR(x_index);
415:
416:
417: ---------------------------------------------------------
418: -- Get Oracle username --

Line 481: FROM jl_co_fa_adjustments

477: ---------------------------------------------------------
478:
479: SELECT count(*)
480: INTO x_count
481: FROM jl_co_fa_adjustments
482: WHERE book_type_code = p_book
483: AND posting_flag <> 'C'
484: AND period_counter_created >= x_start_period_counter
485: AND period_counter_created <= x_end_period_counter;

Line 501: FROM jl_co_fa_adjustments

497: SELECT count(*),
498: NVL(SUM(adjustment_amount), 0)
499: INTO x_adjustments_rows,
500: x_adjustments_amount
501: FROM jl_co_fa_adjustments
502: WHERE book_type_code = p_book
503: AND period_counter_adjusted >= x_start_period_counter
504: AND period_counter_adjusted <= x_end_period_counter;
505:

Line 563: IF NOT (storage_factor('JL_CO_FA_ADJUSTMENTS',

559: ---------------------------------------------------------
560: -- create tables and insert the rows to be archived --
561: ---------------------------------------------------------
562:
563: IF NOT (storage_factor('JL_CO_FA_ADJUSTMENTS',
564: x_adjustments_rows,
565: x_storage_factor)) THEN
566:
567: RAISE UNABLE_TO_DO_SQL;

Line 575: ' as select * from jl_co_fa_adjustments'||

571: x_string := 'create table '||x_oracle_username||'.'||ltrim(rtrim(x_adj_table))||
572: ' STORAGE( INITIAL '||TO_CHAR(ceil(x_storage_factor))||'K '||
573: 'NEXT '||TO_CHAR(ceil(x_storage_factor/2))||'K '||
574: 'MINEXTENTS 1 MAXEXTENTS 20 PCTINCREASE 100) '||
575: ' as select * from jl_co_fa_adjustments'||
576: ' where book_type_code ='||''''||p_book||''''||
577: ' and period_counter_adjusted >= '||to_char(x_start_period_counter)||
578: ' and period_counter_adjusted <= '||to_char(x_end_period_counter);
579:

Line 640: -- Delete the rows from jl_co_fa_adjustments and --

636:
637: ELSE
638:
639: ---------------------------------------------------------
640: -- Delete the rows from jl_co_fa_adjustments and --
641:
642: -- change the status in jl_co_fa_purge to 'PURGED' --
643: ---------------------------------------------------------
644: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 645: fnd_file.put_line( 1, 'Deleting JL_CO_FA_ADJUSTMENTS');

641:
642: -- change the status in jl_co_fa_purge to 'PURGED' --
643: ---------------------------------------------------------
644: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
645: fnd_file.put_line( 1, 'Deleting JL_CO_FA_ADJUSTMENTS');
646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ADJUSTMENTS');
647: END IF;
648:
649: DELETE FROM jl_co_fa_adjustments

Line 646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ADJUSTMENTS');

642: -- change the status in jl_co_fa_purge to 'PURGED' --
643: ---------------------------------------------------------
644: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
645: fnd_file.put_line( 1, 'Deleting JL_CO_FA_ADJUSTMENTS');
646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ADJUSTMENTS');
647: END IF;
648:
649: DELETE FROM jl_co_fa_adjustments
650: WHERE book_type_code = p_book

Line 649: DELETE FROM jl_co_fa_adjustments

645: fnd_file.put_line( 1, 'Deleting JL_CO_FA_ADJUSTMENTS');
646: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleting JL_CO_FA_ADJUSTMENTS');
647: END IF;
648:
649: DELETE FROM jl_co_fa_adjustments
650: WHERE book_type_code = p_book
651: AND period_counter_adjusted >= x_start_period_counter
652: AND period_counter_adjusted <= x_end_period_counter;
653:

Line 655: fnd_file.put_line( 1, 'Deleted JL_CO_FA_ADJUSTMENTS');

651: AND period_counter_adjusted >= x_start_period_counter
652: AND period_counter_adjusted <= x_end_period_counter;
653:
654: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
655: fnd_file.put_line( 1, 'Deleted JL_CO_FA_ADJUSTMENTS');
656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_ADJUSTMENTS');
657: END IF;
658:
659:

Line 656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_ADJUSTMENTS');

652: AND period_counter_adjusted <= x_end_period_counter;
653:
654: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
655: fnd_file.put_line( 1, 'Deleted JL_CO_FA_ADJUSTMENTS');
656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Deleted JL_CO_FA_ADJUSTMENTS');
657: END IF;
658:
659:
660: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 691: x_string := 'insert into jl_co_fa_adjustments select * from '||x_oracle_username||'.'||ltrim(rtrim(x_adj_table));

687: ---------------------------------------------------------
688: -- Process for the option 'RESTORE' --
689: ---------------------------------------------------------
690:
691: x_string := 'insert into jl_co_fa_adjustments select * from '||x_oracle_username||'.'||ltrim(rtrim(x_adj_table));
692: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
693: fnd_file.put_line( 1, 'SQl statement to be processed :'||x_string);
694: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'SQl statement to be processed :'||x_string);
695: END IF;

Line 1546: -- Delete the rows from jl_co_fa_adjustments, --

1542:
1543: ELSE
1544:
1545: ---------------------------------------------------------
1546: -- Delete the rows from jl_co_fa_adjustments, --
1547: -- jl_co_fa_appraisals and jl_co_fa_appraisal_books --
1548: -- and change the status in jl_co_fa_purge to 'PURGED' --
1549: ---------------------------------------------------------
1550: