APPS.HZ_PARAM_TAB_PKG SQL Statements

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

Line: 12

 **** Insert statement ****
 **************************/
 PROCEDURE insert_row (
  x_item_key      in varchar2,
  x_param_name    in varchar2,
  x_param_value   in varchar2,
  x_param_indicator  in varchar2
 ) is
  l_param_value varchar2(4000) := x_param_value;

Line: 27

     insert into hz_param_tab  (
       item_key      ,
       param_name    ,
       param_char    ,
       param_indicator ) values (
       x_item_key      ,
       x_param_name    ,
       l_param_value   ,
       x_param_indicator    );

Line: 39

 PROCEDURE insert_row (
  x_item_key      in varchar2,
  x_param_name    in varchar2,
  x_param_value   in number,
  x_param_indicator  in varchar2
 ) is
  l_param_value number := x_param_value;

Line: 51

     insert into hz_param_tab  (
       item_key      ,
       param_name    ,
       param_num     ,
       param_indicator ) values (
       x_item_key      ,
       x_param_name    ,
       l_param_value   ,
       x_param_indicator    );

Line: 63

 PROCEDURE insert_row (
  x_item_key      in varchar2,
  x_param_name    in varchar2,
  x_param_value   in date,
  x_param_indicator  in varchar2
 ) is
  l_param_value date := x_param_value;

Line: 75

     insert into hz_param_tab  (
       item_key      ,
       param_name    ,
       param_date    ,
       param_indicator ) values (
       x_item_key      ,
       x_param_name    ,
       l_param_value   ,
       x_param_indicator    );

Line: 89

 procedure delete_row (
  x_item_key      in varchar2
 ) is
 begin
  delete from hz_param_tab
  where item_key = x_item_key;