APPS.GCS_DATA_TEMPLATE_UTIL_PKG SQL Statements

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

Line: 97

  l_select_list_gcs     VARCHAR2(10000);

Line: 98

  l_select_list_dstb    VARCHAR2(10000);

Line: 99

  l_select_list_dsload  VARCHAR2(10000);

Line: 100

  l_gl_posted_select_list VARCHAR2(10000);

Line: 147

          SELECT lob_code,
                 file_data
            FROM xdo_lobs
           WHERE application_short_name = 'GCS'
             AND lob_type = 'DATA_TEMPLATE'
             AND lob_code IN ('GCS_DS_LOAD_SOURCE_BASE',
                              'GCS_DS_TB_SOURCE_BASE',
                              'GCS_AD_TB_SOURCE_BASE',
                              'GCS_ENTRY_SOURCE_BASE',
                              'GCS_VS_MAP_SOURCE_BASE',
                              'GCS_INTER_COMP_SOURCE_BASE',
                              'GCS_DS_IMPACTED_BAL_SOURCE_BASE',
                              --Bugfix: 5861665
                              'GCS_CONS_INTER_COMP_SOURCE_BASE')
             AND EXISTS (SELECT 1 FROM gcs_system_options);

Line: 171

   l_select_list_gcs :=  gcs_xml_utility_pkg.g_gcs_dims_select_list;

Line: 172

   l_select_list_dstb :=  gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;

Line: 173

   l_select_list_dsload :=  gcs_xml_utility_pkg.g_fem_dims_select_list_dsload;

Line: 174

   l_gl_posted_select_list := gcs_xml_utility_pkg.g_fem_nonposted_select_stmnt;

Line: 197

   l_orderby_list_gcs := gcs_xml_utility_pkg.g_gcs_dims_select_list;

Line: 200

   l_orderby_list_dstb := gcs_xml_utility_pkg.g_fem_dims_select_list_dstb;

Line: 205

       FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_select_list_gcs : '||l_select_list_gcs);

Line: 206

       FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_select_list_dstb : '||l_select_list_dstb);

Line: 207

       FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_select_list_dsload : '||l_select_list_dsload);

Line: 208

       FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_gl_posted_select_list : '||l_gl_posted_select_list);

Line: 281

               l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);

Line: 282

               l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);

Line: 283

               l_start_tag_length := length('/*startSelectList*/');

Line: 285

               l_clob := replace(l_clob,l_sub_string, l_select_list_gcs);

Line: 287

                   FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'SELECT literal replacement.');

Line: 352

               l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectList*/', 1, 1);

Line: 353

               l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectList*/', 1, 1);

Line: 354

               l_start_tag_length := length('/*startSelectList*/');

Line: 357

                  l_clob := replace(l_clob,l_sub_string, l_select_list_dsload);

Line: 359

                  l_clob := replace(l_clob,l_sub_string, l_select_list_dstb);

Line: 361

                  l_clob := replace(l_clob,l_sub_string, l_select_list_dstb);

Line: 364

                   FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'SELECT (DIMENSION NAME COLUMNS) literal replacement.');

Line: 371

               l_start_tag := DBMS_LOB.instr(l_clob, '/*startSelectIdList*/', 1, 1);

Line: 372

               l_end_tag := DBMS_LOB.instr(l_clob, '/*endSelectIdList*/', 1, 1);

Line: 373

               l_start_tag_length := length('/*startSelectIdList*/');

Line: 377

                  l_clob := replace(l_clob,l_sub_string, l_gl_posted_select_list);

Line: 383

                   FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'SELECT (DIMENSION ID COLUMNS) literal replacement.');

Line: 557

           UPDATE xdo_lobs
              SET file_data = l_blob_out
            WHERE application_short_name = 'GCS'
              AND lob_type = 'DATA_TEMPLATE'
              AND lob_code = SUBSTR(l_base_templatecode, 1, INSTR(l_base_templatecode,'_BASE')-1);