APPS.FEM_LOADER_ENG_UTIL_PKG SQL Statements

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

Line: 91

  SELECT count(*)
  INTO v_count
  FROM fem_xdim_dimensions
  WHERE dimension_id = p_dimension_id
  AND loader_object_def_id IS NOT NULL;

Line: 210

  SELECT count(*)
  INTO v_count
  FROM fem_xdim_dimensions
  WHERE dimension_id = p_dimension_id
  AND composite_dimension_flag = 'N'
  AND hierarchy_table_name IS NOT NULL
  AND read_only_flag = 'N';

Line: 336

  SELECT COUNT(*)
  INTO v_count
  FROM fem_pl_requests r,
       fem_pl_object_executions o
  WHERE r.cal_period_id       = p_cal_period_id
    AND r.ledger_id           = p_ledger_id
    AND r.output_dataset_code = p_dataset_code
    AND r.exec_mode_code      = G_SNAPSHOT
    AND r.exec_status_code    = 'SUCCESS'
    AND o.request_id          = r.request_id
    AND o.object_id           = C_XGL_OBJECT_ID;

Line: 468

    SELECT o.object_id
    INTO v_object_id
    FROM fem_object_catalog_b o, fem_data_loader_objects d
    WHERE o.object_type_code = G_FACT_DATA_LOADER
    AND d.object_id = o.object_id
    AND d.table_name = p_table_name;

Line: 488

  SELECT COUNT(*)
  INTO v_count
  FROM fem_pl_requests r,
       fem_pl_object_executions o,
       fem_pl_tables t
  WHERE r.cal_period_id       = p_cal_period_id
    AND r.ledger_id           = p_ledger_id
    AND r.output_dataset_code = p_dataset_code
    AND r.source_system_code  = p_source_system_code
    AND r.table_name          = p_table_name
    AND o.request_id          = r.request_id
    AND t.request_id          = o.request_id
    AND t.object_id           = o.object_id
    AND (t.num_of_output_rows > 0
      OR o.errors_reported    > 0)
    AND o.object_id           = v_object_id;