APPS.JTFB_TEMP_BIN_PKG SQL Statements

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

Line: 79

procedure insert_row(
     x_rowid     in out NOCOPY varchar2
   , x_bin_code  in     varchar2
   , x_rowno     in     number   default null
   , x_col1      in     varchar2 default null
   , x_col2      in     varchar2 default null
   , x_col3      in     varchar2 default null
   , x_col4      in     varchar2 default null
   , x_col5      in     varchar2 default null
   , x_col6      in     varchar2 default null
   , x_col7      in     varchar2 default null
   , x_col8      in     varchar2 default null
   , x_col9      in     varchar2 default null
   , x_col10     in     varchar2 default null
   , x_col11     in     varchar2 default null
   , x_col12     in     varchar2 default null
   , x_col13     in     varchar2 default null
   , x_col14     in     varchar2 default null
   , x_col15     in     varchar2 default null
   , x_col16     in     varchar2 default null
) is

   l_method_name  varchar2(80) := g_pkg_name || '.insert_row: ';

Line: 105

   insert into jtfb_temp_bin (
        bin_code
      , rowno
      , col1
      , col2
      , col3
      , col4
      , col5
      , col6
      , col7
      , col8
      , col9
      , col10
      , col11
      , col12
      , col13
      , col14
      , col15
      , col16
   ) values (
        x_bin_code
      , x_rowno
      , x_col1
      , x_col2
      , x_col3
      , x_col4
      , x_col5
      , x_col6
      , x_col7
      , x_col8
      , x_col9
      , x_col10
      , x_col11
      , x_col12
      , x_col13
      , x_col14
      , x_col15
      , x_col16
   );

Line: 147

end insert_row;

Line: 181

procedure update_row(
     x_bin_code  in     varchar2
   , x_rowno     in     number
   , x_col1      in     varchar2
   , x_col2      in     varchar2
   , x_col3      in     varchar2
   , x_col4      in     varchar2
   , x_col5      in     varchar2
   , x_col6      in     varchar2
   , x_col7      in     varchar2
   , x_col8      in     varchar2
   , x_col9      in     varchar2
   , x_col10     in     varchar2
   , x_col11     in     varchar2
   , x_col12     in     varchar2
   , x_col13     in     varchar2
   , x_col14     in     varchar2
   , x_col15     in     varchar2
   , x_col16     in     varchar2
) is

   l_method_name  varchar2(80) := g_pkg_name || '.update_row: ';

Line: 209

end update_row;

Line: 212

procedure delete_row(
     x_bin_code  in     varchar2
) is

   l_method_name  varchar2(80) := g_pkg_name || '.delete_row: ';

Line: 223

end delete_row;