APPS.FEM_BR_DATASET_GROUP_PVT SQL Statements

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

Line: 14

PROCEDURE DeleteDatasetGroup(
  p_obj_def_id in number
);

Line: 18

PROCEDURE DeleteInputDatasets(
  p_obj_def_id in number
);

Line: 51

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
--------------------------------------------------------------------------------
IS

  g_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';

Line: 61

  DeleteDatasetGroup(
    p_obj_def_id     => p_obj_def_id
  );

Line: 65

  DeleteInputDatasets(
    p_obj_def_id     => p_obj_def_id
  );

Line: 75

END DeleteObjectDefinition;

Line: 146

PROCEDURE DeleteDatasetGroup(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN

  delete from fem_ds_input_output_defs
  where dataset_io_obj_def_id = p_obj_def_id;

Line: 156

END DeleteDatasetGroup;

Line: 171

PROCEDURE DeleteInputDatasets(
  p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
BEGIN

  delete from fem_ds_input_lists
  where dataset_io_obj_def_id = p_obj_def_id;

Line: 181

END DeleteInputDatasets;

Line: 209

  insert into fem_ds_input_output_defs(
    dataset_io_obj_def_id
    ,output_dataset_code
    ,calendar_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
  ) select
    p_target_obj_def_id
    ,output_dataset_code
    ,calendar_id
    ,nvl(p_created_by,FND_GLOBAL.user_id)
    ,nvl(p_creation_date,sysdate)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,1
  from fem_ds_input_output_defs
  where dataset_io_obj_def_id = p_source_obj_def_id;

Line: 261

  insert into fem_ds_input_lists(
    dataset_io_obj_def_id
    ,input_list_item_num
    ,input_dataset_code
    ,absolute_cal_period_flag
    ,absolute_cal_period_id
    ,use_default_dim_grp_id_code
    ,relative_dimension_group_id
    ,relative_cal_period_offset
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
  ) select
    p_target_obj_def_id
    ,fem_input_list_item_num_seq.nextval
    ,input_dataset_code
    ,absolute_cal_period_flag
    ,absolute_cal_period_id
    ,use_default_dim_grp_id_code
    ,relative_dimension_group_id
    ,relative_cal_period_offset
    ,nvl(p_created_by,FND_GLOBAL.user_id)
    ,nvl(p_creation_date,sysdate)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,1
  from fem_ds_input_lists
  where dataset_io_obj_def_id = p_source_obj_def_id;