Rem
Rem Copyright (c) 2000 by Oracle Corporation
Rem

create or replace package wb_rt_task_variable is

  function get_value
  (
    p_audit_execution_id in number, 
    p_parameter_name in varchar2,
    p_parameter_kind in number,
    p_parameter_scope in number
  ) return clob;
  
  function get_value
  (
    p_audit_parameter_id in number
  ) return clob;
  
  function get_value_kind
  (
    p_audit_execution_id in number, 
    p_parameter_name in varchar2,
    p_parameter_kind in number,
    p_parameter_scope in number
  ) return number;

  function get_value_kind
  (
    p_audit_parameter_id in number
  ) return number;
  
  function get_initial_value
  (
    p_audit_execution_id in number, 
    p_parameter_name in varchar2,
    p_parameter_kind in number,
    p_parameter_scope in number
  ) return clob;
  
  function get_initial_value
  (
    p_audit_parameter_id in number
  ) return clob;
  
  procedure set_value
  (
    p_audit_execution_id in number, 
    p_parameter_name in varchar2,
    p_parameter_kind in number,
    p_parameter_scope in number,
    p_new_value in clob
  );
  
  procedure set_value
  (
    p_audit_execution_id in number, 
    p_parameter_name in varchar2,
    p_parameter_kind in number,
    p_parameter_scope in number,
    p_new_value in varchar2
  );
  
  procedure set_value
  (
    p_audit_parameter_id in number,
    p_new_value in clob
  );
  
  procedure set_value
  (
    p_audit_parameter_id in number,
    p_new_value in varchar2
  );
  
  procedure set_initial_value
  (
    p_audit_execution_id in number, 
    p_parameter_name in varchar2,
    p_parameter_kind in number,
    p_parameter_scope in number,
    p_new_value in clob,
    p_value_kind in number := null,
    p_override in number := 1
  );
  
  procedure set_initial_value
  (
    p_audit_parameter_id in number,
    p_new_value in clob,
    p_value_kind in number := null,
    p_override in number := 1
  );

end wb_rt_task_variable;
/