DBA Data[Home] [Help]

APPS.EAM_INT_UTILS SQL Statements

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

Line: 29

     ' insert into wip_interface_errors ( ' ||
     ' interface_id, error_type, error, ' ||
     ' last_update_date, creation_date, created_by, ' ||
     ' last_update_login, last_updated_by ' ||
     ' ) ' ||
     ' select ' ||
     ' :interface_id_1, :error_type, :error, ' ||
     ' sysdate, sysdate, created_by, ' ||
     ' last_update_login, last_updated_by ' ||
--4247057 begin
     ' from :l_source_table where interface_id = :interface_id_2 ';
Line: 65

    current_errors.delete;
Line: 234

x_statement := 'update :l_table set :l_column = :l_default where rowid = :x_row_id and :l_column is null and :l_condition' ;
Line: 265

 x_statement varchar2(2000) := 'select 1 from :l_table where rowid = :x_row_id and :l_where';