APPS.PA_PARALLEL SQL Statements

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

Line: 15

IF ACTION = 'INSERT' THEN

	INSERT INTO PA_PARALLEL_AUTOINSTALL
	(	TABLE_NAME,
		TABLE_MIN_ID,
		TABLE_MAX_ID,
		CREATION_DATE,
		LAST_UPDATE_DATE
	)
	SELECT script_name||'.'||worker_number||'.'||total_workers,
	       min_id,
	       max_id,
	       sysdate,
	       sysdate
	FROM   DUAL
	WHERE  NOT EXISTS
		(SELECT 'row already exists'
		 FROM  PA_PARALLEL_AUTOINSTALL
   		 WHERE TABLE_NAME =
			script_name||'.'||worker_number||'.'||total_workers);

Line: 36

	SELECT 	NVL(TABLE_MIN_ID , 0)
	INTO	min_id
	FROM	PA_PARALLEL_AUTOINSTALL
	WHERE	TABLE_NAME =
			script_name||'.'||worker_number||'.'||total_workers;

Line: 43

ELSIF ACTION = 'UPDATE' THEN

	UPDATE PA_PARALLEL_AUTOINSTALL
	SET
		last_update_date = sysdate,
		TABLE_MIN_ID = least(min_id,max_id)
	WHERE TABLE_NAME =
		script_name||'.'||worker_number||'.'||total_workers;