APPS.FEM_BR_DATA_INSPECTOR_PVT SQL Statements

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

Line: 14

PROCEDURE DeleteDataInspector(
  p_obj_def_id in number
);

Line: 18

PROCEDURE DeleteDataInspectorCols(
  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

  DeleteDataInspector(
    p_obj_def_id     => p_obj_def_id
  );

Line: 65

  DeleteDataInspectorCols(
    p_obj_def_id     => p_obj_def_id
  );

Line: 75

END DeleteObjectDefinition;

Line: 146

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

  delete from fem_data_inspectors
  where data_inspector_obj_def_id = p_obj_def_id;

Line: 156

END DeleteDataInspector;

Line: 171

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

  delete from fem_data_inspector_cols
  where data_inspector_obj_def_id = p_obj_def_id;

Line: 181

END DeleteDataInspectorCols;

Line: 209

  insert into fem_data_inspectors(
    data_inspector_obj_def_id
    ,table_name
    ,num_rows
    ,condition_obj_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
  ) select
    p_target_obj_def_id
    ,table_name
    ,num_rows
    ,condition_obj_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_data_inspectors
  where data_inspector_obj_def_id = p_source_obj_def_id;

Line: 263

  insert into fem_data_inspector_cols(
    data_inspector_obj_def_id
    ,table_name
    ,column_name
    ,display_sequence
    ,editable_flag
    ,sort_sequence
    ,sort_direction_flag
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
  ) select
    p_target_obj_def_id
    ,table_name
    ,column_name
    ,display_sequence
    ,editable_flag
    ,sort_sequence
    ,sort_direction_flag
    ,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_data_inspector_cols
  where data_inspector_obj_def_id = p_source_obj_def_id;