APPS.FEM_DATA_TEMPLATE_UTIL_PKG SQL Statements

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

Line: 30

  l_select_list_fem     VARCHAR2(10000);

Line: 52

          SELECT lob_code,
                 file_data
            FROM xdo_lobs
           WHERE application_short_name = 'FEM'
             AND lob_type               = 'DATA_TEMPLATE'
             AND lob_code               = 'FEM_GL_WRTBK_ERROR_SOURCE_BASE';

Line: 60

SELECT ftcb.column_name,
       SUBSTR(ftcb.column_name, 1, INSTR(ftcb.column_name, '_ID')) || 'NAME' dimension_name,
       ftcb.display_name,
       DECODE(ftcb.column_name, 'CHANNEL_ID', 'fem_channels_tl',
                                'COMPANY_COST_CENTER_ORG_ID', 'fem_cctr_orgs_tl',
                                'CUSTOMER_ID', 'fem_customers_tl',
                                'FINANCIAL_ELEM_ID', 'fem_fin_elems_tl',
                                'INTERCOMPANY_ID', 'fem_cctr_orgs_tl',
                                'LINE_ITEM_ID', 'fem_ln_items_tl',
                                'NATURAL_ACCOUNT_ID', 'fem_nat_accts_tl',
                                'PRODUCT_ID', 'fem_products_tl',
                                'PROJECT_ID', 'fem_projects_tl',
                                'TASK_ID', 'fem_tasks_tl',
                                'USER_DIM10_ID', 'fem_user_dim10_tl',
                                'USER_DIM1_ID', 'fem_user_dim1_tl',
                                'USER_DIM2_ID', 'fem_user_dim2_tl',
                                'USER_DIM3_ID', 'fem_user_dim3_tl',
                                'USER_DIM4_ID', 'fem_user_dim4_tl',
                                'USER_DIM5_ID', 'fem_user_dim5_tl',
                                'USER_DIM6_ID', 'fem_user_dim6_tl',
                                'USER_DIM7_ID', 'fem_user_dim7_tl',
                                'USER_DIM8_ID', 'fem_user_dim8_tl',
                                'USER_DIM9_ID', 'fem_user_dim9_tl' ) table_name,
       DECODE(ftcb.column_name, 'CHANNEL_ID', 'fcht',
                                'COMPANY_COST_CENTER_ORG_ID', 'fcot',
                                'CUSTOMER_ID', 'fcut',
                                'FINANCIAL_ELEM_ID', 'ffet',
                                'INTERCOMPANY_ID', 'fcit',
                                'LINE_ITEM_ID', 'flit',
                                'NATURAL_ACCOUNT_ID', 'fnat',
                                'PRODUCT_ID', 'fpt',
                                'PROJECT_ID', 'fpjt',
                                'TASK_ID', 'ftt',
                                'USER_DIM10_ID', 'fu10t',
                                'USER_DIM1_ID', 'fu1t',
                                'USER_DIM2_ID', 'fu2t',
                                'USER_DIM3_ID', 'fu3t',
                                'USER_DIM4_ID', 'fu4t',
                                'USER_DIM5_ID', 'fu5t',
                                'USER_DIM6_ID', 'fu6t',
                                'USER_DIM7_ID', 'fu7t',
                                'USER_DIM8_ID', 'fu8t',
                                'USER_DIM9_ID', 'fu9t' ) table_alias,
       DECODE(ftcb.column_name, 'COMPANY_COST_CENTER_ORG_ID', 1,
              'LINE_ITEM_ID', 2,
              'USER_DIM10_ID', 4,
              'INTERCOMPANY_ID', 5, 3) column_order
  FROM fem_tab_columns_tl ftcb,
       fem_tab_column_prop ftcp
 WHERE ftcb.table_name           = 'FEM_BALANCES'
   AND ftcb.table_name           = ftcp.table_name
   AND ftcb.language             = userenv('LANG')
   AND ftcb.column_name          = ftcp.column_name
   AND ftcp.column_property_code = 'PROCESSING_KEY'
   AND ftcb.column_name IN ('CHANNEL_ID',
                            'COMPANY_COST_CENTER_ORG_ID',
                            'CUSTOMER_ID',
                            'FINANCIAL_ELEM_ID',
                            'INTERCOMPANY_ID',
                            'LINE_ITEM_ID',
                            'NATURAL_ACCOUNT_ID',
                            'PRODUCT_ID',
                            'PROJECT_ID',
                            'TASK_ID',
                            'USER_DIM10_ID',
                            'USER_DIM1_ID',
                            'USER_DIM2_ID',
                            'USER_DIM3_ID',
                            'USER_DIM4_ID',
                            'USER_DIM5_ID',
                            'USER_DIM6_ID',
                            'USER_DIM7_ID',
                            'USER_DIM8_ID',
                            'USER_DIM9_ID')
 ORDER BY 6, 1;

Line: 146

       l_select_list_fem :=  l_select_list_fem || v_active_dims.table_alias || '.' || 'COMPANY_COST_CENTER_ORG_NAME ' || v_active_dims.dimension_name ||','||g_nl;

Line: 148

       l_select_list_fem :=  l_select_list_fem || v_active_dims.table_alias || '.' || v_active_dims.dimension_name ||','||g_nl;

Line: 182

       FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'l_select_list_fem : '||l_select_list_fem);

Line: 242

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

Line: 243

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

Line: 244

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

Line: 246

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

Line: 249

                   FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'replace_dt_proc', 'Select List literal replacement.');

Line: 341

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