APPS.GCS_BUILD_EPB_DATA_TR_PKG SQL Statements

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

Line: 79

     SELECT epb_table_name
       INTO l_data_table
       FROM GCS_SYSTEM_OPTIONS;

Line: 85

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
       INTO l_felm_req, l_felm_tab
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'FINANCIAL_ELEM_ID';

Line: 109

     SELECT enabled_flag
       INTO l_cctr_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'COMPANY_COST_CENTER_ORG_ID';

Line: 119

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
       INTO l_interco_req, l_interco_tab
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'INTERCOMPANY_ID';

Line: 142

     SELECT enabled_flag
       INTO l_prd_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'PRODUCT_ID';

Line: 152

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
       INTO l_na_req, l_na_tab
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'NATURAL_ACCOUNT_ID';

Line: 175

     SELECT enabled_flag
       INTO l_chl_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'CHANNEL_ID';

Line: 185

     SELECT enabled_flag
       INTO l_prj_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'PROJECT_ID';

Line: 195

     SELECT enabled_flag
       INTO l_cst_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'CUSTOMER_ID';

Line: 205

     SELECT enabled_flag
       INTO l_tsk_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'TASK_ID';

Line: 215

     SELECT enabled_flag
       INTO l_ud1_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM1_ID';

Line: 225

     SELECT enabled_flag
       INTO l_ud2_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM2_ID';

Line: 235

     SELECT enabled_flag
       INTO l_ud3_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM3_ID';

Line: 245

     SELECT enabled_flag
       INTO l_ud4_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM4_ID';

Line: 255

     SELECT enabled_flag
       INTO l_ud5_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM5_ID';

Line: 265

     SELECT enabled_flag
       INTO l_ud6_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM6_ID';

Line: 275

     SELECT enabled_flag
       INTO l_ud7_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM7_ID';

Line: 285

     SELECT enabled_flag
       INTO l_ud8_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM8_ID';

Line: 295

     SELECT enabled_flag
       INTO l_ud9_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM9_ID';

Line: 305

     SELECT enabled_flag
       INTO l_ud10_req
       FROM GCS_EPB_DIM_MAPS
      WHERE gcs_column = 'USER_DIM10_ID';

Line: 315

     SELECT enabled_flag, 'FEM_' || substr(epb_column,0, 10)
       INTO l_category_req, l_category_tab
       FROM GCS_EPB_DIM_MAPS
      --Bugfix 4291225: The column name is CREATED_BY_OBJECT_ID
      WHERE gcs_column = 'CREATED_BY_OBJECT_ID';

Line: 456

     SELECT currency_code
       INTO l_top_curr
       FROM gcs_hierarchies_b hier,
            gcs_entity_cons_attrs attr
       WHERE hier.hierarchy_id = p_hierarchy_id
         AND attr.hierarchy_id = hier.hierarchy_id
         AND attr.entity_id = hier.top_entity_id;

Line: 469

     SELECT ln_item_hierarchy_obj_id
       INTO l_ln_item_obj_id
       FROM GCS_SYSTEM_OPTIONS;

Line: 478

      SELECT dataset_code
      INTO   l_dataset_code
      FROM   gcs_dataset_codes
      WHERE  hierarchy_id         = p_hierarchy_id
      AND    balance_type_code    = p_balance_type_code;

Line: 484

      SELECT dataset_code
      INTO   l_target_dataset_code
      FROM   gcs_dataset_codes
      WHERE  hierarchy_id         = p_hierarchy_id
      AND    balance_type_code    = ''ANALYZE_'' || p_balance_type_code;

Line: 516

      SELECT dataset_code
        INTO l_target_dataset_code
        FROM FEM_DATASETS_B
        WHERE DATASET_DISPLAY_CODE = l_dataset_dsp_code;

Line: 528

     SELECT fem_ledger_id
     INTO l_ledger_id
     FROM GCS_HIERARCHIES_B
     WHERE hierarchy_id = p_hierarchy_id;

Line: 534

     SELECT 	date_assign_value
     INTO	l_end_date
     FROM 	fem_cal_periods_attr
     WHERE	cal_period_id	= 	p_cal_period_id
     AND	attribute_id	=	l_end_date_attribute_id
     AND	version_id	=	l_end_date_version_id;

Line: 552

     SELECT associated_object_id
       INTO l_object_id
       FROM GCS_CATEGORIES_B
       WHERE category_code = ''AGGREGATION'';

Line: 567

     SELECT object_definition_id
      INTO l_object_def_id
      FROM fem_object_definition_b
     WHERE object_id = l_object_id;

Line: 574

     DELETE FROM ' || l_data_table  ||  '
     WHERE dataset_code = l_target_dataset_code
       AND cal_period_id = p_cal_period_id;

Line: 587

INSERT INTO ' || l_data_table;

Line: 670

         LAST_UPDATED_BY_REQUEST_ID,
         LAST_UPDATED_BY_OBJECT_ID,
         NUMERIC_MEASURE)
       SELECT
         l_target_dataset_code,
         p_cal_period_id,
         g_src_sys_code,
         LEDGER_ID,
         CURRENCY_CODE,
         LINE_ITEM_ID,
         ENTITY_ID,
';

Line: 757

         max(LAST_UPDATED_BY_REQUEST_ID),
         max(LAST_UPDATED_BY_OBJECT_ID),
         sum(xtd_balance_e)
     FROM FEM_BALANCES FB ';

Line: 883

     FND_FILE.PUT_LINE(FND_FILE.LOG, '' Rows inserted into data table = '' || l_row_count);

Line: 924

        UPDATE	' || l_data_table || ' data_table
        SET	data_table.numeric_measure		=	numeric_measure * -1
	WHERE 	data_table.dataset_code			=	l_target_dataset_code
	AND	data_table.cal_period_id		=	p_cal_period_id
	AND	EXISTS		(			SELECT 	''X''
							FROM  	fem_ln_items_attr 		flia,
								fem_ext_acct_types_attr		feata
							WHERE	data_table.line_item_id		=	flia.line_item_id
							AND	flia.attribute_id		=	l_ext_acct_type_attr_id
							AND	flia.version_id			=	l_ext_acct_type_version_id
							AND	feata.attribute_id		=	l_basic_acct_type_attr_id
							AND	feata.version_id		=	l_basic_acct_type_version_id
							AND	feata.ext_account_type_code	=	flia.dim_attribute_varchar_member
							AND	feata.dim_attribute_varchar_member IN (''LIABILITY'', ''EQUITY'', ''REVENUE''));

Line: 1082

    SELECT value
    INTO   l_business_process_access
    FROM   zpb_ac_param_values
    WHERE  analysis_cycle_id = p_analysis_cycle_id
    AND    param_id = (SELECT tag
                       FROM   fnd_lookup_values_vl
                       WHERE  LOOKUP_TYPE = ''ZPB_PARAMS''
                       AND    lookup_code = ''OVERRIDE_EXTERNAL_USER_CHECK'');

Line: 1093

      SELECT user_id
      INTO   l_bp_user_id
      FROM   zpb_bp_external_users
      WHERE  analysis_cycle_id = p_analysis_cycle_id;

Line: 1117

      SELECT zac.name, zbav.name
      INTO   l_business_process_name, l_business_area_name
      FROM   zpb_business_areas_vl zbav, zpb_analysis_cycles zac
      WHERE  zbav.business_area_id = zac.business_area_id
      AND    zac.analysis_cycle_id = p_analysis_cycle_id;

Line: 1124

      SELECT start_fcpa.date_assign_value
      INTO   l_horizon_start
      FROM   fem_cal_periods_attr start_fcpa
      WHERE  start_fcpa.cal_period_id = p_cal_period_id
      AND    start_fcpa.attribute_id = l_start_date_attribute_id
      AND    start_fcpa.version_id = l_start_date_version_id;

Line: 1132

      SELECT end_fcpa.date_assign_value
      INTO   l_horizon_end
      FROM   fem_cal_periods_attr end_fcpa
      WHERE  end_fcpa.cal_period_id = p_cal_period_id
      AND    end_fcpa.attribute_id = l_end_date_attribute_id
      AND    end_fcpa.version_id = l_end_date_version_id;