APPS.PAY_DBITL_UPDATE_ERRORS_PKG SQL Statements

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

Line: 12

  insert_row
  (p_user_name       => p_user_name
  ,p_user_entity_id  => p_user_entity_id
  ,p_translated_name => p_translated_name
  ,p_message_text    => p_message_text
  ,p_rowid           => l_rowid
  );

Line: 19

end insert_row;

Line: 21

procedure insert_row
(p_user_name       in varchar2
,p_user_entity_id  in number
,p_translated_name in varchar2
,p_message_text    in varchar2
,p_rowid              out nocopy varchar2
) is
begin
  insert into pay_dbitl_update_errors
  (user_name
  ,user_entity_id
  ,translated_name
  ,message_text
  )
  values
  (p_user_name
  ,p_user_entity_id
  ,p_translated_name
  ,p_message_text
  )
  returning rowid into p_rowid;

Line: 42

end insert_row;

Line: 46

procedure delete_rows
(p_user_name       in varchar2
,p_user_entity_id  in number
,p_translated_name in varchar2
) is
begin
  delete pay_dbitl_update_errors
  where  user_name = p_user_name
  and    user_entity_id = p_user_entity_id
  and    translated_name = p_translated_name
  ;

Line: 57

end delete_rows;

Line: 60

procedure delete_rows
(p_rowids in dbms_sql.varchar2s
) is
begin
  if p_rowids.count = 0 then
    return;

Line: 69

    delete pay_dbitl_update_errors
    where  rowid = p_rowids(i);

Line: 71

end delete_rows;

Line: 74

procedure delete_row
(p_rowid in varchar2
) is
begin
  delete pay_dbitl_update_errors
  where rowid = p_rowid
  ;

Line: 81

end delete_row;

Line: 89

  select rowid
  ,      message_text bulk collect
  into   p_rowids
  ,      p_messages
  from   pay_dbitl_update_errors
  ;