APPS.IEU_WP_UI_COMP_DATATYPES_PKG SQL Statements

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

Line: 4

procedure insert_row(
x_rowid in out nocopy Varchar2,
p_ui_comp_datatype_map_id in number,
p_ui_comp_id in number,
p_object_version_number in number,
p_created_by in number,
p_creation_date in date,
p_last_updated_by in number,
p_last_update_date in date,
p_last_update_login in number,
p_data_type in varchar2
) is
  cursor C is select ROWID from IEU_WP_UI_COMP_DATATYPES
    where UI_COMP_DATATYPE_MAP_ID = P_UI_COMP_DATATYPE_MAP_ID;

Line: 20

  insert into IEU_WP_UI_COMP_DATATYPES (
  UI_COMP_DATATYPE_MAP_ID,
  UI_COMP_ID ,
  OBJECT_VERSION_NUMBER,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN,
  DATA_TYPE
 )
  VALUES(
  p_ui_comp_datatype_map_id,
  p_ui_comp_id,
  p_object_version_number,
  p_created_by,
  p_creation_date,
  p_last_updated_by,
  p_last_update_date,
  p_last_update_login,
  p_data_type
  );

Line: 51

END INSERT_ROW;

Line: 60

cursor c is select
  object_version_number,
  data_type
  from ieu_wp_ui_comp_datatypes
  where ui_comp_datatype_map_id = p_ui_comp_datatype_map_id
  for update of ui_comp_datatype_map_id nowait;

Line: 73

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 89

procedure update_row(
p_ui_comp_datatype_map_id in number,
p_ui_comp_id in number,
p_last_updated_by in number,
p_last_update_date in date,
p_last_update_login in number,
p_data_type in varchar2
) is
begin
   update IEU_WP_UI_COMP_DATATYPES set
   object_version_number = object_version_number+1,
   data_type = p_data_type,
   ui_comp_id = p_ui_comp_id,
   last_update_date = p_last_update_date,
   last_updated_by = p_last_updated_by,
   last_update_login = p_last_update_login
   where ui_comp_datatype_map_id = p_ui_comp_datatype_map_id;

Line: 115

END UPDATE_ROW;

Line: 118

procedure delete_row(
p_ui_comp_datatype_map_id in number
) is
begin
  delete from IEU_WP_UI_COMP_DATATYPES
  where ui_comp_datatype_map_id = p_ui_comp_datatype_map_id;

Line: 129

END DELETE_ROW;

Line: 149

     update_row(
     p_ui_comp_datatype_map_id => p_ui_comp_datatype_map_id,
     p_ui_comp_id => p_ui_comp_id,
     --p_last_updated_by => l_user_id,
     p_last_updated_by => fnd_load_util.owner_id(p_owner),
     p_last_update_date => sysdate,
     p_last_update_login => 0,
     p_data_type => p_data_type
     );

Line: 164

     insert_row(
      x_rowid => l_rowid,
      p_ui_comp_datatype_map_id => p_ui_comp_datatype_map_id,
      p_ui_comp_id => p_ui_comp_id,
      p_object_version_number => 1,
      --p_created_by => l_user_id,
      p_created_by => fnd_load_util.owner_id(p_owner),
      p_creation_date => sysdate,
      --p_last_updated_by => l_user_id,
      p_last_updated_by => fnd_load_util.owner_id(p_owner),
      p_last_update_date => sysdate,
      p_last_update_login => 0,
      p_data_type => p_data_type
      );