APPS.FEM_BR_DATA_LDR_PVT SQL Statements

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

Line: 25

PROCEDURE DeleteObjectDefinition (p_obj_def_id IN NUMBER) IS

  l_api_name    CONSTANT  VARCHAR2(30) := 'DeleteObjectDefinition';

Line: 44

    SELECT object_id INTO l_obj_id FROM fem_object_definition_vl
    WHERE object_definition_id =  p_obj_def_id;

Line: 47

    SELECT COUNT(*) INTO l_ver_count FROM fem_object_definition_vl
    WHERE object_id =  l_obj_id;

Line: 50

    DELETE FROM fem_data_loader_params
    WHERE loader_obj_def_id = p_obj_def_id;

Line: 53

    DELETE FROM fem_object_definition_vl
    WHERE object_definition_id = p_obj_def_id;

Line: 59

      DELETE FROM fem_object_catalog_vl WHERE object_id = l_obj_id;

Line: 61

      DELETE FROM fem_data_loader_rules WHERE loader_obj_id = l_obj_id;

Line: 84

END DeleteObjectDefinition;

Line: 129

  INSERT INTO fem_data_loader_rules
  (
    loader_obj_id,
    loader_type,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    last_update_login,
    object_version_number
  )
  SELECT
    p_target_obj_id,
    loader_type,
    p_created_by,
    p_creation_date,
    p_created_by,
    p_creation_date,
    fnd_global.login_id,
    0
  FROM fem_data_loader_rules WHERE loader_obj_id = p_source_obj_id;

Line: 205

    SELECT
    load_param_set_id,
    loader_obj_def_id,
    table_name,
    source_system_code,
    dataset_code,
    ledger_id,
    cal_period_grp_id,
    load_option,
    created_by,
    creation_date,
    FND_GLOBAL.user_id,
    FND_GLOBAL.login_id,
    sysdate,
    object_version_number

  FROM fem_data_loader_params WHERE loader_obj_def_id = p_source_obj_def_id;

Line: 234

     INSERT INTO fem_data_loader_params (
       load_param_set_id,
       loader_obj_def_id,
       table_name,
       source_system_code,
       dataset_code,
       ledger_id,
       cal_period_grp_id,
       load_option,
       created_by,
       creation_date,
       last_updated_by,
       last_update_login,
       last_update_date,
       object_version_number
     )
     VALUES (
       fem_load_param_set_id_seq.nextval,
       p_target_obj_def_id,
       params_cur_rec.table_name,
       params_cur_rec.source_system_code,
       params_cur_rec.dataset_code,
       params_cur_rec.ledger_id,
       params_cur_rec.cal_period_grp_id,
       params_cur_rec.load_option,
       p_created_by,
       p_creation_date,
       fnd_global.user_id,
       fnd_global.login_id,
       sysdate,
       0
     );

Line: 324

  SELECT COUNT(*) INTO l_param_count FROM fem_data_loader_params
  WHERE loader_obj_def_id = p_object_definition_id;

Line: 388

  SELECT loader_type INTO l_loader_type FROM fem_data_loader_rules WHERE
  loader_obj_id = p_object_id;