DBA Data[Home] [Help]

APPS.CSD_GEN_UTILITY_PVT SQL Statements

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

Line: 11

        SELECT USERENV('SESSIONID') INTO l_audsid FROM sys.dual;
Line: 13

           SELECT sid, SUBSTR(osuser,1,8) INTO l_sid ,l_os_user
        FROM   v$session
        WHERE  audsid = l_audsid;
Line: 17

           SELECT l_os_user||'.csd'||TO_CHAR(l_sid)||'.dbg'
        INTO   csd_gen_utility_pvt.g_file
        FROM   dual;
Line: 237

csd_gen_utility_pvt.add('last_update_date   :'||l_rec.last_update_date  );
Line: 239

csd_gen_utility_pvt.add('last_updated_by    :'||l_rec.last_updated_by   );
Line: 241

csd_gen_utility_pvt.add('last_update_login  :'||l_rec.last_update_login );
Line: 322

csd_gen_utility_pvt.add('last_update_date    :'||l_rec.last_update_date          );
Line: 324

csd_gen_utility_pvt.add('last_updated_by     :'||l_rec.last_updated_by           );
Line: 326

csd_gen_utility_pvt.add('last_update_login   :'||l_rec.last_update_login         );
Line: 381

csd_gen_utility_pvt.add('last_updated_by        :'||l_rec.last_updated_by );
Line: 382

csd_gen_utility_pvt.add('last_update_date       :'||l_rec.last_update_date );
Line: 383

csd_gen_utility_pvt.add('last_update_login      :'||l_rec.last_update_login );
Line: 785

  csd_gen_utility_pvt.add('status_update_date             :'||p_account_rec.status_update_date);