DBA Data[Home] [Help]

APPS.WSH_PR_PICKING_ROWS SQL Statements

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

Line: 69

	-- Column variables for DBMS_SQL package for mapping to selected values from cursors

	-- Unreleased lines					-- Backordered lines
        u_line_id                         BINARY_INTEGER;	b_line_id                         BINARY_INTEGER;
Line: 159

  PROCEDURE Insert_RL_Row(p_source IN VARCHAR2);
Line: 963

	  call_parameters.delete;
Line: 964

	  release_table.delete;
Line: 1024

                release_table.delete(current_line - 1);
Line: 1069

                release_table.delete(current_line - 1);
Line: 1078

              release_table.delete(current_line - 1);
Line: 1182

        Insert_RL_Row('u');
Line: 1197

        Insert_RL_Row('b');
Line: 1236

	  Insert_RL_Row('b');
Line: 1244

	  Insert_RL_Row('u');
Line: 1255

	  Insert_RL_Row('u');
Line: 1265

	  Insert_RL_Row('b');
Line: 1287

	  Insert_RL_Row('u');
Line: 1293

	    Insert_RL_Row('b');
Line: 1297

	  Insert_RL_Row('b');
Line: 1303

	    Insert_RL_Row('u');
Line: 1485

  PROCEDURE Insert_RL_Row(
		   p_source		IN	VARCHAR2
  ) IS

	cs		BINARY_INTEGER;
Line: 1660

  END Insert_RL_Row;
Line: 1779

	WSH_UTIL.Write_Log('Updated ' || to_char(v_ignore) || ' lines in model');
Line: 1854

	  call_parameters.delete;
Line: 1855

	  sync_table.delete;
Line: 1868

	    -- Inserts the next line detail into sync_table

	    IF DBMS_SQL.Fetch_Rows(s_cursor) > 0 THEN
	      Map_Col_Value('s');
Line: 1872

	      Insert_RL_Row('s');
Line: 1885

	    sync_table.delete(current_sync_line - 1);
Line: 1988

	  call_parameters.delete;
Line: 1989

	  release_table.delete;
Line: 2006

	      Insert_RL_Row('n');
Line: 2023

	    release_table.delete(current_line - 1);