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.GCS_DATASUB_DYNAMIC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 233


      ad_ddl.build_statement(' PROCEDURE update_ytd_balances (p_load_id			IN	NUMBER, ' , r); r:=r+1;

Line: 244


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.begin'', ''<>'' ); ', r); r:=r+1;

Line: 248


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Load Id : '' || p_load_id );', r); r:=r+1;

Line: 250


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Source System : '' || p_source_system_code );', r); r:=r+1;

Line: 252


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;

Line: 254


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;

Line: 256


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;

Line: 258


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Currency Type : '' || p_currency_type );', r); r:=r+1;

Line: 260


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
            ''Currency Code : '' || p_currency_code );', r); r:=r+1;

Line: 265


      ad_ddl.build_statement('   UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 270


      ad_ddl.build_statement('			SELECT fb.ytd_debit_balance_e  + NVL(gbit.ptd_debit_balance_e,0)  , ', r); r:=r+1;

Line: 303


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.end'', ''<>''); ', r); r:=r+1;

Line: 307


      ad_ddl.build_statement('   END    update_ytd_balances;', r); r:=r+1;

Line: 310


      ad_ddl.build_statement(' PROCEDURE update_ptd_balances (p_load_id			IN	NUMBER, ' , r); r:=r+1;

Line: 321


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.begin'',
            ''<>'' ); ', r); r:=r+1;

Line: 326


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Load Id : '' || p_load_id );', r); r:=r+1;

Line: 328


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Source System : '' || p_source_system_code );', r); r:=r+1;

Line: 330


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;

Line: 332


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;

Line: 334


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;

Line: 336


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Currency Type : '' || p_currency_type );', r); r:=r+1;

Line: 338


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
                                          ''Currency Code : '' || p_currency_code );', r); r:=r+1;

Line: 343


      ad_ddl.build_statement('   UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 348


      ad_ddl.build_statement('			SELECT gbit.ytd_debit_balance_e  - NVL(fb.ytd_debit_balance_e,0) , ', r); r:=r+1;

Line: 379


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.end'', ''<>''); ', r); r:=r+1;

Line: 383


      ad_ddl.build_statement('   END    update_ptd_balances;', r); r:=r+1;

Line: 385


      ad_ddl.build_statement(' PROCEDURE update_ptd_balance_sheet (	p_load_id                   IN      NUMBER, ' , r); r:=r+1;

Line: 410


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.begin'',
                                          ''<>'' ); ', r); r:=r+1;

Line: 414


      ad_ddl.build_statement('   SELECT      fgvcd.value_set_id ', r); r:=r+1;

Line: 425


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Load Id : '' || p_load_id );', r); r:=r+1;

Line: 427


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Source System : '' || p_source_system_code );', r); r:=r+1;

Line: 429


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;

Line: 431


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;

Line: 433


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;

Line: 435


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Currency Type : '' || p_currency_type );', r); r:=r+1;

Line: 437


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
                                          ''Currency Code : '' || p_currency_code );', r); r:=r+1;

Line: 442


      ad_ddl.build_statement('   UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 447


      ad_ddl.build_statement('                    SELECT gbit.ytd_debit_balance_e  - NVL(fb.ytd_debit_balance_e,0) , ', r); r:=r+1;

Line: 475


      ad_ddl.build_statement('   AND    EXISTS	(SELECT ''X''							', r); r:=r+1;

Line: 495


      ad_ddl.build_statement('     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.end'', ''<>''); ', r); r:=r+1;

Line: 499


      ad_ddl.build_statement('   END    update_ptd_balance_sheet;', r); r:=r+1;

Line: 529


      ad_ddl.build_statement('   UPDATE ', r); r:=r+1;

Line: 536


      ad_ddl.build_statement('   SELECT fea.dim_attribute_numeric_member ', r); r:=r+1;

Line: 546


      ad_ddl.build_statement('   SELECT fgvcd.value_set_id, ', r); r:=r+1;

Line: 584


      ad_ddl.build_statement('          UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 589


      ad_ddl.build_statement('           AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 594


      ad_ddl.build_statement('          UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 599


      ad_ddl.build_statement('          AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 604


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 609


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 614


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 619


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 624


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 629


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 634


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 639


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 644


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 649


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 654


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 659


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 664


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 669


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 674


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 679


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 684


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 689


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 694


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 699


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 704


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 709


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 714


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 719


      ad_ddl.build_statement('           AND   NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 724


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 729


      ad_ddl.build_statement('           AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 734


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 739


      ad_ddl.build_statement('           AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 744


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 749


      ad_ddl.build_statement('           AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 754


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 759


      ad_ddl.build_statement('           AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;

Line: 764


      ad_ddl.build_statement('           UPDATE gcs_bal_interface_t gbit ', r); r:=r+1;

Line: 769


      ad_ddl.build_statement('           AND    NOT EXISTS (SELECT ''X''  ', r); r:=r+1;