DBA Data[Home] [Help]

APPS.JL_CO_FA_TA_REVAL_PKG dependencies on JL_CO_FA_ADJUSTMENTS

Line 427: FROM jl_co_fa_adjustments

423: END IF;
424:
425: SELECT count(*)
426: INTO x_count1
427: FROM jl_co_fa_adjustments
428: WHERE book_type_code = p_book
429: AND reference = rec_appraisal.appraisal_id
430: AND rownum < 2; */
431:

Line 1533: -- Use this procedure to insert row into JL_CO_FA_ADJUSTMENTS. --

1529: -- PROCEDURE --
1530: -- insert_row --
1531: -- --
1532: -- DESCRIPTION --
1533: -- Use this procedure to insert row into JL_CO_FA_ADJUSTMENTS. --
1534: -- --
1535: -- PURPOSE: --
1536: -- Oracle Applications Rel 11.0 --
1537: -- --

Line 1583: fnd_file.put_line( 1, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');

1579: AND period_close_date IS NULL;
1580:
1581:
1582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: fnd_file.put_line( 1, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');
1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');
1585: END IF;
1586:
1587:

Line 1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');

1580:
1581:
1582: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1583: fnd_file.put_line( 1, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');
1584: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserting Row into JL_CO_FA_ADJUSTMENTS');
1585: END IF;
1586:
1587:
1588: IF (p_adjustment_amount <> 0) THEN

Line 1589: INSERT INTO jl_co_fa_adjustments(

1585: END IF;
1586:
1587:
1588: IF (p_adjustment_amount <> 0) THEN
1589: INSERT INTO jl_co_fa_adjustments(
1590: source_type_code,
1591: je_category_name,
1592: adjustment_type,
1593: debit_credit_flag,

Line 1636: fnd_file.put_line( 1, 'Inseted Row into JL_CO_FA_ADJUSTMENTS');

1632: x_sysdate);
1633: END IF;
1634:
1635: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1636: fnd_file.put_line( 1, 'Inseted Row into JL_CO_FA_ADJUSTMENTS');
1637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserted Row into JL_CO_FA_ADJUSTMENTS');
1638: END IF;
1639:
1640: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserted Row into JL_CO_FA_ADJUSTMENTS');

1633: END IF;
1634:
1635: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1636: fnd_file.put_line( 1, 'Inseted Row into JL_CO_FA_ADJUSTMENTS');
1637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserted Row into JL_CO_FA_ADJUSTMENTS');
1638: END IF;
1639:
1640: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1641: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');