Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_task

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_task_variable.pls

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;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de