APPS.FUN_GL_ASF_EVENTS_PKG SQL Statements

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

Line: 49

       DELETE fun_balance_accounts
       WHERE  (dr_bsv = l_bsv OR cr_bsv = l_bsv)
       AND    template_id IN (SELECT template_id
                              FROM   fun_balance_options
                              WHERE  ledger_id = l_ledger_id);

Line: 59

                          ' No. of rows deleted from fun_balance_accounts is ' ||
                          SQL%ROWCOUNT);

Line: 135

       DELETE fun_balance_accounts
       WHERE  (dr_bsv = l_bsv OR cr_bsv = l_bsv)
       AND    template_id IN (SELECT template_id
                              FROM   fun_balance_options
                              WHERE  le_id = l_le_id);

Line: 145

                          ' No. of rows deleted from fun_balance_accounts is ' ||
                          SQL%ROWCOUNT);

Line: 150

       UPDATE  fun_inter_accounts
       SET     end_date = SYSDATE,
               last_update_date = SYSDATE,
               last_update_login = FND_GLOBAL.LOGIN_ID,
               last_updated_by   = FND_GLOBAL.USER_ID
       WHERE   (trans_bsv = l_bsv AND from_le_id = l_le_id)
       OR      (tp_bsv    = l_bsv AND to_le_id   = l_le_id);

Line: 240

       UPDATE fun_balance_options
       SET    status_flag = 'N',
              last_update_date = SYSDATE,
              last_update_login = FND_GLOBAL.LOGIN_ID,
              last_updated_by   = FND_GLOBAL.USER_ID
       WHERE  le_id       = l_le_id
       AND    ledger_id   = l_ledger_id;

Line: 256

       UPDATE  fun_inter_accounts
       SET     end_date = SYSDATE,
               last_update_date = SYSDATE,
               last_update_login = FND_GLOBAL.LOGIN_ID,
               last_updated_by   = FND_GLOBAL.USER_ID
       WHERE   from_le_id = l_le_id
       AND     ledger_id  = l_ledger_id;

Line: 307

 FUNCTION secondary_ledger_delete(p_subscription_guid IN RAW
                          ,p_event            IN OUT NOCOPY wf_event_t
                          ) RETURN VARCHAR2
IS

l_routine          VARCHAR2(80) := 'secondary_ledger_delete';

Line: 317

   SAVEPOINT fun_secondary_ledger_delete;

Line: 327

                      'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
                      'Begin Secondary Ledger Id ' || l_sec_ledger_id );

Line: 342

       DELETE FROM fun_balance_accounts
       WHERE  template_id in (SELECT template_id
                              FROM   fun_balance_options
                              WHERE  ledger_id = l_sec_ledger_id);

Line: 350

                          'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
                          ' No. of rows deleted in fun_balance_accounts is ' ||
                          SQL%ROWCOUNT);

Line: 355

       DELETE FROM fun_balance_options
       WHERE  ledger_id   = l_sec_ledger_id;

Line: 361

                          'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
                          ' No. of rows deleted in fun_balance_options is ' ||
                          SQL%ROWCOUNT);

Line: 366

       DELETE FROM  fun_inter_accounts
       WHERE  ledger_id  = l_sec_ledger_id;

Line: 372

                          'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
                          ' No. of rows deleted in fun_inter_accounts is ' ||
                          SQL%ROWCOUNT);

Line: 383

                      'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
                      'completed');

Line: 391

        ROLLBACK TO fun_secondary_ledger_delete;

Line: 395

                      'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
                      'Error encountered ' || SQLERRM);

Line: 406

END secondary_ledger_delete;

Line: 413

 FUNCTION reporting_ledger_delete(p_subscription_guid IN RAW
                          ,p_event            IN OUT NOCOPY wf_event_t
                          ) RETURN VARCHAR2
IS

l_routine          VARCHAR2(80) := 'reporting_ledger_delete';

Line: 423

   SAVEPOINT fun_reporting_ledger_delete;

Line: 433

                      'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
                      'Begin Reporting Ledger Id ' || l_rep_ledger_id );

Line: 448

       DELETE FROM fun_balance_accounts
       WHERE  template_id in (SELECT template_id
                              FROM   fun_balance_options
                              WHERE  ledger_id = l_rep_ledger_id);

Line: 456

                          'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
                          ' No. of rows deleted in fun_balance_accounts is ' ||
                          SQL%ROWCOUNT);

Line: 461

       DELETE FROM fun_balance_options
       WHERE  ledger_id   = l_rep_ledger_id;

Line: 467

                          'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
                          ' No. of rows deleted in fun_balance_options is ' ||
                          SQL%ROWCOUNT);

Line: 472

       DELETE FROM  fun_inter_accounts
       WHERE  ledger_id  = l_rep_ledger_id;

Line: 478

                          'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
                          ' No. of rows deleted in fun_inter_accounts is ' ||
                          SQL%ROWCOUNT);

Line: 489

                      'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
                      'completed');

Line: 497

        ROLLBACK TO fun_reporting_ledger_delete;

Line: 501

                      'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
                      'Error encountered ' || SQLERRM);

Line: 512

END reporting_ledger_delete;