APPS.FEM_DATAX_LOADER_PKG SQL Statements

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

Line: 83

g_select_stmt            VARCHAR2(32767);

Line: 215

  p_eng_sql => g_select_stmt,
  p_eng_prg => 'FEM_DATAX_LOADER_PKG.Process_Rows',
  p_condition => g_condition,
  p_failed_req_id => null,
  p_arg1 => g_data_table,
  p_arg2 => g_object_id,
  p_arg3 => g_ledger_id,
  p_arg4 => g_dataset_cd,
  p_arg5 => g_cal_per_id,
  p_arg6 => g_source_cd,
  p_arg7 => g_exec_mode,
  p_arg8 => g_req_id,
  p_arg9 => g_cctr_org_sql,
  p_arg10 => g_fin_elem_sql,
  p_arg11 => g_product_sql,
  p_arg12 => g_nat_acct_sql,
  p_arg13 => g_channel_sql,
  p_arg14 => g_line_item_sql,
  p_arg15 => g_project_sql,
  p_arg16 => g_customer_sql,
  p_arg17 => g_entity_sql,
  p_arg18 => g_geography_sql,
  p_arg19 => g_task_sql,
  p_arg20 => g_interco_sql,
  p_arg21 => g_user_dim1_sql,
  p_arg22 => g_user_dim2_sql,
  p_arg23 => g_user_dim3_sql,
  p_arg24 => g_user_dim4_sql,
  p_arg25 => g_user_dim5_sql,
  p_arg26 => g_user_dim6_sql,
  p_arg27 => g_user_dim7_sql,
  p_arg28 => g_user_dim8_sql,
  p_arg29 => g_user_dim9_sql,
  p_arg30 => g_user_dim10_sql);

Line: 277

SELECT NVL(SUM(rows_processed),0),
       NVL(SUM(rows_loaded),0),
       NVL(SUM(rows_rejected),0)
INTO   g_rows_processed,
       g_rows_loaded,
       g_rows_rejected
FROM   fem_mp_process_ctl_t
WHERE  req_id = g_req_id;

Line: 310

   FEM_Multi_Proc_Pkg.Delete_Data_Slices(
      p_req_id => g_req_id);

Line: 592

   SELECT column_name
   FROM fem_tab_column_prop
   WHERE table_name = g_data_table
   AND column_property_code = 'PROCESSING_KEY'
   AND column_name not in ('CREATED_BY_OBJECT_ID')
   ORDER BY column_name;

Line: 600

   SELECT index_name
   FROM all_indexes
   WHERE owner = c_fem_schema
   AND table_name = g_data_t_table
   AND uniqueness = 'UNIQUE';

Line: 607

   SELECT column_name
   FROM all_ind_columns
   WHERE index_owner = c_fem_schema
   AND index_name = v_uniq_idx
   ORDER BY column_position;

Line: 656

   SELECT C.object_id
   INTO   g_object_id
   FROM   fem_object_catalog_vl C,
          fem_object_definition_vl D
   WHERE  D.object_definition_id = g_obj_def_id
   AND    C.object_id = D.object_id
   AND    C.folder_id IN
      (SELECT folder_id
       FROM fem_user_folders
       WHERE user_id =  c_user_id);

Line: 713

SELECT COUNT(*)
INTO v_count
FROM fem_table_class_assignmt
WHERE table_name = g_data_table
AND table_classification_code = 'GENERIC_DATA_TABLE';

Line: 851

           'SELECT 1 FROM dual'||
           ' WHERE '''||v_idx_col||''' IN ('||v_proc_cols||')'
         INTO v_proc_key_ok;

Line: 895

   SELECT ledger_display_code,ledger_name
   INTO   v_ledger_dc,v_ledger_name
   FROM   fem_ledgers_vl
   WHERE  ledger_id = g_ledger_id;

Line: 904

SELECT count(*)
INTO   v_count
FROM   fem_ledgers_b B,
       fem_ledgers_attr A,
       fem_dim_attributes_b T,
       fem_dimensions_b D,
       fem_dim_attr_versions_b V
WHERE  B.ledger_id = g_ledger_id
AND    B.enabled_flag = 'Y'
AND    A.ledger_id = B.ledger_id
AND    T.attribute_id = A.attribute_id
AND    T.attribute_varchar_label = 'CAL_PERIOD_HIER_OBJ_DEF_ID'
AND    V.version_id = A.version_id
AND    V.default_version_flag = 'Y'
AND    D.dimension_id = T.dimension_id
AND    D.dimension_varchar_label = 'LEDGER';

Line: 956

   SELECT dataset_display_code,dataset_name
   INTO   v_dataset_dc,v_dataset_name
   FROM   fem_datasets_vl
   WHERE  dataset_code = g_dataset_cd;

Line: 965

SELECT count(*)
INTO   v_count
FROM   fem_datasets_b B,
       fem_datasets_attr A,
       fem_dim_attributes_b T,
       fem_dimensions_b D,
       fem_dim_attr_versions_b V
WHERE  B.dataset_code = g_dataset_cd
AND    B.enabled_flag = 'Y'
AND    A.dataset_code = B.dataset_code
AND    T.attribute_id = A.attribute_id
AND    T.attribute_varchar_label = 'DATASET_BALANCE_TYPE_CODE'
AND    V.version_id = A.version_id
AND    V.default_version_flag = 'Y'
AND    D.dimension_id = T.dimension_id
AND    D.dimension_varchar_label = 'DATASET';

Line: 996

   SELECT source_system_display_code,source_system_name
   INTO v_source_dc,v_source_name
   FROM fem_source_systems_vl
   WHERE source_system_code = g_source_cd;

Line: 1014

   SELECT cal_period_name
   INTO   v_cal_per_name
   FROM   fem_cal_periods_vl
   WHERE  cal_period_id = g_cal_per_id;

Line: 1025

   SELECT G.dimension_group_display_code,
          D.date_assign_value,
          N.number_assign_value
   INTO   v_dim_grp_cd,
          v_cal_per_end_date,
          v_cal_per_num
   FROM   fem_cal_periods_b C,
          fem_cal_periods_attr N,
          fem_cal_periods_attr D,
          fem_dimension_grps_b G,
          fem_dim_attr_versions_b NV,
          fem_dim_attr_versions_b DV
   WHERE  C.cal_period_id = g_cal_per_id
   AND    C.dimension_group_id = G.dimension_group_id
   AND    N.attribute_id =
             (SELECT attribute_id FROM fem_dim_attributes_b
              WHERE attribute_varchar_label = 'GL_PERIOD_NUM')
   AND    N.version_id = NV.version_id
   AND    N.cal_period_id = g_cal_per_id
   AND    NV.default_version_flag = 'Y'
   AND    D.attribute_id =
             (SELECT attribute_id FROM fem_dim_attributes_b
              WHERE attribute_varchar_label = 'CAL_PERIOD_END_DATE')
   AND    D.version_id = DV.version_id
   AND    D.cal_period_id = g_cal_per_id
   AND    DV.default_version_flag = 'Y';

Line: 1075

  'SELECT COUNT(*)'||
  ' FROM '||g_data_t_table||
  ' WHERE calp_dim_grp_display_code = :b_dim_grp_cd'||
  ' AND cal_period_end_date = :b_cal_per_end_date'||
  ' AND cal_period_number = :b_cal_per_num'||
  ' AND ledger_display_code = :b_ledger_dc'||
  ' AND dataset_display_code = :b_dataset_dc'||
  ' AND source_system_display_code = :b_source_dc'||
  ' AND rownum = 1'
INTO v_count
USING v_dim_grp_cd,
      TO_DATE(TO_CHAR(v_cal_per_end_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS'),
      v_cal_per_num,
      v_ledger_dc,
      v_dataset_dc,
      v_source_dc;

Line: 1359

  p_last_update_login => null,
  p_program_id => c_conc_prg_id,
  p_program_login_id => c_login_id,
  p_program_application_id => c_prg_app_id,
  p_exec_mode_code => g_exec_mode,
  p_dimension_id => null,
  p_table_name => g_data_table,
  p_hierarchy_name => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 1394

  p_last_update_login => null,
  p_exec_mode_code => g_exec_mode,
  x_exec_state => v_exec_state,
  x_prev_request_id => v_prev_req_id,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 1452

  p_last_update_login => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 1479

  p_statement_type => 'INSERT',
  p_num_of_output_rows => 0,
  p_user_id => c_user_id,
  p_last_update_login => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 1637

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_cctr_org_b_tab,v_cctr_org_col,v_cctr_org_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'COMPANY_COST_CENTER_ORG_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1646

    'SELECT '||v_cctr_org_col||
    ' FROM '||v_cctr_org_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_cctr_org_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1658

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_fin_elem_b_tab,v_fin_elem_col,v_fin_elem_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'FINANCIAL_ELEM_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1667

    'SELECT '||v_fin_elem_col||
    ' FROM '||v_fin_elem_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_fin_elem_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1679

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_product_b_tab,v_product_col,v_product_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'PRODUCT_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1688

    'SELECT '||v_product_col||
    ' FROM '||v_product_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_product_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1700

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_nat_acct_b_tab,v_nat_acct_col,v_nat_acct_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'NATURAL_ACCOUNT_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1709

    'SELECT '||v_nat_acct_col||
    ' FROM '||v_nat_acct_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_nat_acct_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1721

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_channel_b_tab,v_channel_col,v_channel_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'CHANNEL_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1730

    'SELECT '||v_channel_col||
    ' FROM '||v_channel_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_channel_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1742

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_line_item_b_tab,v_line_item_col,v_line_item_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'LINE_ITEM_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1751

    'SELECT '||v_line_item_col||
    ' FROM '||v_line_item_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_line_item_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1763

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_project_b_tab,v_project_col,v_project_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'PROJECT_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1772

    'SELECT '||v_project_col||
    ' FROM '||v_project_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_project_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1784

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_customer_b_tab,v_customer_col,v_customer_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'CUSTOMER_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1793

    'SELECT '||v_customer_col||
    ' FROM '||v_customer_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_customer_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1805

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_entity_b_tab,v_entity_col,v_entity_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'ENTITY_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1814

    'SELECT '||v_entity_col||
    ' FROM '||v_entity_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_entity_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1826

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_geography_b_tab,v_geography_col,v_geography_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'GEOGRAPHY_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1835

    'SELECT '||v_geography_col||
    ' FROM '||v_geography_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_geography_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1847

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_task_b_tab,v_task_col,v_task_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'TASK_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1856

    'SELECT '||v_task_col||
    ' FROM '||v_task_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_task_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1868

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_interco_b_tab,v_interco_col,v_interco_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'INTERCOMPANY_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1877

    'SELECT '||v_interco_col||
    ' FROM '||v_interco_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_interco_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1889

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim1_b_tab,v_user_dim1_col,v_user_dim1_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM1_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1898

    'SELECT '||v_user_dim1_col||
    ' FROM '||v_user_dim1_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim1_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1910

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim2_b_tab,v_user_dim2_col,v_user_dim2_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM2_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1919

    'SELECT '||v_user_dim2_col||
    ' FROM '||v_user_dim2_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim2_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1931

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim3_b_tab,v_user_dim3_col,v_user_dim3_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM3_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1940

    'SELECT '||v_user_dim3_col||
    ' FROM '||v_user_dim3_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim3_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1952

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim4_b_tab,v_user_dim4_col,v_user_dim4_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM4_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1961

    'SELECT '||v_user_dim4_col||
    ' FROM '||v_user_dim4_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim4_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1973

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim5_b_tab,v_user_dim5_col,v_user_dim5_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM5_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 1982

    'SELECT '||v_user_dim5_col||
    ' FROM '||v_user_dim5_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim5_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 1994

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim6_b_tab,v_user_dim6_col,v_user_dim6_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM6_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 2003

    'SELECT '||v_user_dim6_col||
    ' FROM '||v_user_dim6_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim6_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 2015

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim7_b_tab,v_user_dim7_col,v_user_dim7_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM7_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 2024

    'SELECT '||v_user_dim7_col||
    ' FROM '||v_user_dim7_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim7_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 2036

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim8_b_tab,v_user_dim8_col,v_user_dim8_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM8_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 2045

    'SELECT '||v_user_dim8_col||
    ' FROM '||v_user_dim8_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim8_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 2057

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim9_b_tab,v_user_dim9_col,v_user_dim9_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM9_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 2066

    'SELECT '||v_user_dim9_col||
    ' FROM '||v_user_dim9_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim9_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 2078

   SELECT member_b_table_name,member_col,member_display_code_col
   INTO   v_user_dim10_b_tab,v_user_dim10_col,v_user_dim10_dc_col
   FROM   fem_tab_columns_b C,
          fem_xdim_dimensions X
   WHERE  C.table_name = g_data_table
   AND    C.column_name = 'USER_DIM10_ID'
   AND    C.dimension_id = X.dimension_id;

Line: 2087

    'SELECT '||v_user_dim10_col||
    ' FROM '||v_user_dim10_b_tab||' B,'||
    '      fem_global_vs_combo_defs G'||
    ' WHERE G.global_vs_combo_id = '||g_gvc_id||
    ' AND   G.value_set_id = B.value_set_id'||
    ' AND   B.'||v_user_dim10_dc_col||' = :b_dc_val'||
    ' AND   B.enabled_flag = ''Y''';

Line: 2101

g_select_stmt :=
   'SELECT rowid,'||
         ' cctr_org_display_code,'||
         ' currency_code,'||
         ' financial_elem_display_code,'||
         ' product_display_code,'||
         ' natural_account_display_code,'||
         ' channel_display_code,'||
         ' line_item_display_code,'||
         ' project_display_code,'||
         ' customer_display_code,'||
         ' entity_display_code,'||
         ' geography_display_code,'||
         ' task_display_code,'||
         ' intercompany_display_code,'||
         ' user_dim1_display_code,'||
         ' user_dim2_display_code,'||
         ' user_dim3_display_code,'||
         ' user_dim4_display_code,'||
         ' user_dim5_display_code,'||
         ' user_dim6_display_code,'||
         ' user_dim7_display_code,'||
         ' user_dim8_display_code,'||
         ' user_dim9_display_code,'||
         ' user_dim10_display_code,'||
         ' numeric_measure,'||
         ' alphanumeric_measure,'||
         ' date_measure,'||
         ' status'||
   ' FROM '||g_data_t_table||
   ' WHERE '||g_condition||
   ' AND   {{data_slice}} ';

Line: 2289

x_select_stmt VARCHAR2(32767);

Line: 2290

x_insert_stmt VARCHAR2(32767);

Line: 2291

x_update_stmt VARCHAR2(32767);

Line: 2292

x_delete_stmt VARCHAR2(32767);

Line: 2413

   x_select_stmt := REPLACE(p_eng_sql,'{{data_slice}}',p_slc_pred);

Line: 2415

   x_select_stmt := REPLACE(p_eng_sql,'{{data_slice}}','1=1');

Line: 2420

  p_module => v_block||'.x_select_stmt{821}',
  p_msg_text => x_select_stmt);

Line: 2426

x_insert_stmt :=
   'INSERT INTO '||p_data_table||
          '(created_by_object_id,'||
          ' dataset_code,'||
          ' cal_period_id,'||
          ' source_system_code,'||
          ' ledger_id,'||
          ' company_cost_center_org_id,'||
          ' currency_code,'||
          ' financial_elem_id,'||
          ' product_id,'||
          ' natural_account_id,'||
          ' channel_id,'||
          ' line_item_id,'||
          ' project_id,'||
          ' customer_id,'||
          ' entity_id,'||
          ' geography_id,'||
          ' task_id,'||
          ' intercompany_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,'||
          ' user_dim10_id,'||
          ' created_by_request_id,'||
          ' last_updated_by_request_id,'||
          ' last_updated_by_object_id,'||
          ' numeric_measure,'||
          ' alphanumeric_measure,'||
          ' date_measure)'||
   ' SELECT :b_object_id,'||
          ' :b_dataset_cd,'||
          ' :b_cal_per_id,'||
          ' :b_source_cd,'||
          ' :b_ledger_id,'||
          ' :b_cctr_org_id,'||
          ' :b_currency_cd,'||
          ' :b_fin_elem_dc,'||
          ' :b_product_id,'||
          ' :b_nat_acct_id,'||
          ' :b_channel_id,'||
          ' :b_line_item_id,'||
          ' :b_project_id,'||
          ' :b_customer_id,'||
          ' :b_entity_id,'||
          ' :b_geography_id,'||
          ' :b_task_id,'||
          ' :b_interco_id,'||
          ' :b_user_dim1_id,'||
          ' :b_user_dim2_id,'||
          ' :b_user_dim3_id,'||
          ' :b_user_dim4_id,'||
          ' :b_user_dim5_id,'||
          ' :b_user_dim6_id,'||
          ' :b_user_dim7_id,'||
          ' :b_user_dim8_id,'||
          ' :b_user_dim9_id,'||
          ' :b_user_dim10_id,'||
          ' :b1_req_id,'||
          ' :b2_req_id,'||
          ' :b_object_id,'||
          ' :b_num_measure,'||
          ' :b_alpha_measure,'||
          ' :b_date_measure'||
   ' FROM dual'||
   ' WHERE :b_status = ''LOAD''';

Line: 2503

x_update_stmt :=
   'UPDATE '||v_data_t_table||
   ' SET status = :b1_status'||
   ' WHERE rowid = :b_rowid';

Line: 2512

x_delete_stmt :=
   'DELETE FROM '||v_data_t_table||
   ' WHERE rowid = :b_rowid'||
   ' AND   :b_status = ''LOAD''';

Line: 2568

   x_select_stmt := REPLACE(x_select_stmt,'{{table_partition}}',v_part_name);

Line: 2574

      x_select_stmt
      USING v_slc_val1,v_slc_val2,v_slc_val3,v_slc_val4;

Line: 2579

      x_select_stmt
      USING v_slc_val1,v_slc_val2,v_slc_val3;

Line: 2584

      x_select_stmt
      USING v_slc_val1,v_slc_val2;

Line: 2589

      x_select_stmt
      USING v_slc_val1;

Line: 2677

            SELECT currency_code
            INTO   v_varchar
            FROM   fem_currencies_vl
            WHERE  currency_code = t_currency_cd(i)
            AND    enabled_flag = 'Y';

Line: 3056

     p_module => v_block||'.Begin bulk insert{834}',
     p_msg_text => v_last_row);

Line: 3060

      EXECUTE IMMEDIATE x_insert_stmt
      USING p_object_id,
            p_dataset_cd,
            p_cal_per_id,
            p_source_cd,
            p_ledger_id,
            t_cctr_org_id(i),
            t_currency_cd(i),
            t_fin_elem_id(i),
            t_product_id(i),
            t_nat_acct_id(i),
            t_channel_id(i),
            t_line_item_id(i),
            t_project_id(i),
            t_customer_id(i),
            t_entity_id(i),
            t_geography_id(i),
            t_task_id(i),
            t_interco_id(i),
            t_user_dim1_id(i),
            t_user_dim2_id(i),
            t_user_dim3_id(i),
            t_user_dim4_id(i),
            t_user_dim5_id(i),
            t_user_dim6_id(i),
            t_user_dim7_id(i),
            t_user_dim8_id(i),
            t_user_dim9_id(i),
            t_user_dim10_id(i),
            p_req_id,
            p_req_id,
            p_object_id,
            t_num_measure(i),
            t_alpha_measure(i),
            t_date_measure(i),
            t_status(i);

Line: 3102

     p_module => v_block||'.Begin bulk update{835}',
     p_msg_text => v_last_row);

Line: 3106

      EXECUTE IMMEDIATE x_update_stmt
      USING t_status(i),
            t_rowid(i);

Line: 3115

     p_module => v_block||'.Begin bulk delete{836}',
     p_msg_text => v_last_row);

Line: 3119

      EXECUTE IMMEDIATE x_delete_stmt
      USING t_rowid(i),
            t_status(i);

Line: 3133

     p_module => v_block||'.Begin array delete{837}',
     p_msg_text => v_last_row);

Line: 3136

   t_rowid.DELETE;

Line: 3137

   t_cctr_org_dc.DELETE;

Line: 3138

   t_currency_cd.DELETE;

Line: 3139

   t_fin_elem_dc.DELETE;

Line: 3140

   t_product_dc.DELETE;

Line: 3141

   t_nat_acct_dc.DELETE;

Line: 3142

   t_channel_dc.DELETE;

Line: 3143

   t_line_item_dc.DELETE;

Line: 3144

   t_project_dc.DELETE;

Line: 3145

   t_customer_dc.DELETE;

Line: 3146

   t_entity_dc.DELETE;

Line: 3147

   t_geography_dc.DELETE;

Line: 3148

   t_task_dc.DELETE;

Line: 3149

   t_interco_dc.DELETE;

Line: 3150

   t_user_dim1_dc.DELETE;

Line: 3151

   t_user_dim2_dc.DELETE;

Line: 3152

   t_user_dim3_dc.DELETE;

Line: 3153

   t_user_dim4_dc.DELETE;

Line: 3154

   t_user_dim5_dc.DELETE;

Line: 3155

   t_user_dim6_dc.DELETE;

Line: 3156

   t_user_dim7_dc.DELETE;

Line: 3157

   t_user_dim8_dc.DELETE;

Line: 3158

   t_user_dim9_dc.DELETE;

Line: 3159

   t_user_dim10_dc.DELETE;

Line: 3160

   t_num_measure.DELETE;

Line: 3161

   t_alpha_measure.DELETE;

Line: 3162

   t_date_measure.DELETE;

Line: 3163

   t_status.DELETE;

Line: 3343

FEM_PL_PKG.Update_Obj_Exec_Errors(
  p_api_version => c_api_version,
  p_request_id => g_req_id,
  p_object_id => g_object_id,
  p_errors_reported => g_rows_rejected,
  p_errors_reprocessed => 0,
  p_user_id => c_user_id,
  p_last_update_login => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 3357

  p_module => v_block||'.update_obj_exec_errors.return_status{910}',
  p_msg_text => v_return_status);

Line: 3372

FEM_PL_PKG.Update_Num_of_Output_Rows(
  p_api_version => c_api_version,
  p_request_id => g_req_id,
  p_object_id => g_object_id,
  p_table_name => g_data_table,
  p_statement_type => 'INSERT',
  p_num_of_output_rows => g_rows_loaded,
  p_user_id => c_user_id,
  p_last_update_login => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 3387

  p_module => v_block||'.update_num_of_output_rows.return_status{911}',
  p_msg_text => v_return_status);

Line: 3402

FEM_PL_PKG.Update_Obj_Exec_Status(
  p_api_version => c_api_version,
  p_request_id => g_req_id,
  p_object_id => g_object_id,
  p_exec_status_code => g_exec_status,
  p_user_id => c_user_id,
  p_last_update_login => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 3415

  p_module => v_block||'.update_obj_exec_status.return_status{912}',
  p_msg_text => v_return_status);

Line: 3430

FEM_PL_PKG.Update_Request_Status(
  p_api_version => c_api_version,
  p_request_id => g_req_id,
  p_exec_status_code => g_exec_status,
  p_user_id => c_user_id,
  p_last_update_login => null,
  x_msg_count => v_msg_count,
  x_msg_data => v_msg_data,
  x_return_status => v_return_status);

Line: 3442

  p_module => v_block||'.update_request_status.return_status{913}',
  p_msg_text => v_return_status);