APPS.EGO_ITEM_ORG_BULKLOAD_PVT SQL Statements

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

Line: 48

  G_UPDATE             CONSTANT VARCHAR2(10) := 'UPDATE';

Line: 109

     SELECT VALUE
      FROM V$PARAMETER
      WHERE NAME = 'utl_file_dir';

Line: 199

   l_dyn_sql := l_dyn_sql || 'INSERT INTO MTL_INTERFACE_ERRORS ';

Line: 203

   l_dyn_sql := l_dyn_sql || ', LAST_UPDATE_DATE	 ';

Line: 204

   l_dyn_sql := l_dyn_sql || ', LAST_UPDATED_BY	 ';

Line: 207

   l_dyn_sql := l_dyn_sql || ', LAST_UPDATE_LOGIN	 ';

Line: 214

   l_dyn_sql := l_dyn_sql || ', PROGRAM_UPDATE_DATE	 ';

Line: 220

   l_dyn_sql := l_dyn_sql || 'SELECT ';

Line: 257

   Write_Debug('MIERR: Inserted Pre-processed error messages in MTL_INTERFACE_ERRORS');

Line: 261

   UPDATE MTL_SYSTEM_ITEMS_INTERFACE
    SET   PROCESS_FLAG = G_INTF_STATUS_ERROR
   WHERE  PROCESS_FLAG IN
	  (
	     G_PRIMARY_UOM_ERR_STS
	   )
     AND  SET_PROCESS_ID = p_set_process_id;

Line: 269

   Write_Debug('MSII: Updated all the line statuses to Error for Pre-processing validation errors');

Line: 378

   ,  p_del_rec_flag   =>  2   -- do not delete processed records
   ,  p_prog_appid     =>  G_PROG_APPID
   ,  p_prog_id        =>  G_PROG_ID
   ,  p_request_id     =>  G_REQUEST_ID
   ,  p_user_id        =>  G_USER_ID
   ,  p_login_id       =>  G_LOGIN_ID
   ,  p_xset_id        =>  p_Set_Process_ID  -- run for all the IOI  records
   ,  p_commit_flag    =>  l_item_ioi_commit -- NOTE: 1 = Commit 2 = Donot Commit
   ,  p_run_mode       =>  3 --NOTE: 1 = CREATE; 2 = UPDATE; 3 = SYNC