APPS.IEU_UWQM_WS_ASSCT_PROPS_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_ws_association_prop_id in number,
p_parent_ws_id in number,
p_child_ws_id in number,
p_dist_st_based_on_parent_flag in varchar2,
p_ws_id in number,
p_tasks_rules_function IN varchar2
) is


  cursor C is select ROWID from IEU_UWQM_WS_ASSCT_PROPS
    where ws_association_prop_id = p_ws_association_prop_id;

Line: 24

  insert into IEU_UWQM_WS_ASSCT_PROPS(
  ws_association_prop_id,
  parent_ws_id,
  child_ws_id,
  dist_st_based_on_parent_flag,
  ws_id,
  tasks_rules_function,
  OBJECT_VERSION_NUMBER,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN
  )
  VALUES(
  p_ws_association_prop_id,
  p_parent_ws_id,
  p_child_ws_id,
  p_dist_st_based_on_parent_flag,
  p_ws_id,
  p_tasks_rules_function,
  1,
  fnd_global.user_id,
  sysdate,
  fnd_global.user_id,
  sysdate,
  fnd_global.login_id
  );

Line: 61

END INSERT_ROW;

Line: 73

cursor c is select
  object_version_number,
  parent_ws_id,
  child_ws_id,
  dist_st_based_on_parent_flag,
  ws_id,
  tasks_rules_function
  from ieu_uwqm_ws_assct_props
  where ws_association_prop_id = p_ws_association_prop_id
  for update of ws_association_prop_id nowait;

Line: 90

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

Line: 110

procedure update_row(
p_ws_association_prop_id in number,
p_parent_ws_id in number,
p_child_ws_id in number,
p_dist_st_based_on_parent_flag in varchar2,
p_ws_id in number,
p_tasks_rules_function IN varchar2
) is
begin
   update ieu_uwqm_ws_assct_props set
   object_version_number = object_version_number+1,
   parent_ws_id = p_parent_ws_id,
   child_ws_id = p_child_ws_id,
   dist_st_based_on_parent_flag = p_dist_st_based_on_parent_flag,
   ws_id = p_ws_id,
   tasks_rules_function = p_tasks_rules_function,
   last_update_date = sysdate,
   last_updated_by = fnd_global.user_id,
   last_update_login = fnd_global.login_id
   where ws_association_prop_id = p_ws_association_prop_id;

Line: 139

END UPDATE_ROW;

Line: 142

procedure delete_row(
p_ws_association_prop_id in number
) is
begin
  delete from ieu_uwqm_ws_assct_props
  where ws_association_prop_id = p_ws_association_prop_id;

Line: 153

END DELETE_ROW;

Line: 175

     update_row(
     p_ws_association_prop_id => p_ws_association_prop_id,
     p_parent_ws_id => p_parent_ws_id,
     p_child_ws_id => p_child_ws_id,
     p_dist_st_based_on_parent_flag => p_dist_st_based_on_parent_flag,
     p_ws_id => p_ws_id,
     p_tasks_rules_function => p_tasks_rules_function
     );

Line: 189

     insert_row(
      x_rowid => l_rowid,
      p_ws_association_prop_id => p_ws_association_prop_id,
      p_parent_ws_id => p_parent_ws_id,
      p_child_ws_id => p_child_ws_id,
      p_dist_st_based_on_parent_flag => p_dist_st_based_on_parent_flag,
      p_ws_id => p_ws_id,
      p_tasks_rules_function => p_tasks_rules_function
      );