APPS.WIP_JSI_UTILS SQL Statements

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

Line: 53

    select group_id,header_id
    into x_group_id, x_header_id
    from wip_job_schedule_interface
    where rowid = current_rowid;

Line: 70

  update wip_job_schedule_interface
  set
    process_phase = current_process_phase,
    process_status = x_final_process_status,
    last_update_date = sysdate
  where current of matching_request ;

Line: 181

    'select 1 from wip_job_schedule_interface WJSI ' ||
    'where rowid = :x_row_id and ' ||
    replace(p_where_clause, '    ', ' ') ;

Line: 257

    'update wip_job_schedule_interface WJSI ' ||
    'set ' || p_column || ' = ' ||
      replace(p_default_value_expression, '    ', ' ') || ' ' ||
    'where rowid = :x_row_id and ' ||
    p_column || ' is null and ' ||
    replace(p_condition, '    ', ' ') ;