APPS.IEX_DEL_STATUSES_PKG SQL Statements

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

Line: 3

/* Insert_Row procedure */
PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

Line: 6

PROCEDURE Insert_Row(x_rowid	IN OUT NOCOPY VARCHAR2
	,p_DEL_STATUS_ID		NUMBER
	,p_OBJECT_VERSION_NUMBER	NUMBER
	,p_SCORE_VALUE_LOW		NUMBER
	,p_SCORE_VALUE_HIGH		NUMBER
	,p_DEL_STATUS			VARCHAR2
	,p_SCORE_ID			NUMBER
	,p_REQUEST_ID			NUMBER	DEFAULT NULL
	,p_PROGRAM_APPLICATION_ID	NUMBER	DEFAULT NULL
	,p_PROGRAM_ID			NUMBER	DEFAULT NULL
	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
	,p_CREATED_BY			NUMBER
	,p_CREATION_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
) IS
	CURSOR C IS SELECT ROWID FROM IEX_DEL_STATUSES
		WHERE DEL_STATUS_ID = p_DEL_STATUS_ID;

Line: 27

	INSERT INTO IEX_DEL_STATUSES
	(
		DEL_STATUS_ID
		,OBJECT_VERSION_NUMBER
		,SCORE_VALUE_LOW
		,SCORE_VALUE_HIGH
		,DEL_STATUS
		,SCORE_ID
		,REQUEST_ID
		,PROGRAM_APPLICATION_ID
		,PROGRAM_ID
		,PROGRAM_UPDATE_DATE
		,CREATED_BY
		,CREATION_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATE_LOGIN
	) VALUES (
		p_DEL_STATUS_ID
		,p_OBJECT_VERSION_NUMBER
		,p_SCORE_VALUE_LOW
		,p_SCORE_VALUE_HIGH
		,p_DEL_STATUS
		,p_SCORE_ID
		,p_REQUEST_ID
		,p_PROGRAM_APPLICATION_ID
		,p_PROGRAM_ID
		,p_PROGRAM_UPDATE_DATE
		,p_CREATED_BY
		,p_CREATION_DATE
		,p_LAST_UPDATED_BY
		,p_LAST_UPDATE_DATE
		,p_LAST_UPDATE_LOGIN
	);

Line: 69

END Insert_Row;

Line: 73

/* Insert_Row procedure */
PROCEDURE Insert_Row_With_Defaults
	(x_rowid		IN OUT NOCOPY VARCHAR2
	,p_SCORE_VALUE_LOW		NUMBER
	,p_SCORE_VALUE_HIGH		NUMBER
	,p_DEL_STATUS			VARCHAR2
	,p_SCORE_ID			NUMBER
	,Commit_flag			VARCHAR2
) IS
	CURSOR C(p_del_status_id number)
	IS SELECT ROWID FROM IEX_DEL_STATUSES
		WHERE DEL_STATUS_ID = p_DEL_STATUS_ID;

Line: 91

	Select IEX_DEL_STATUSES_S.nextval
	into l_del_status_id
	From dual ;

Line: 95

	INSERT INTO IEX_DEL_STATUSES
	(
		 DEL_STATUS_ID
		,OBJECT_VERSION_NUMBER
		,SCORE_VALUE_LOW
		,SCORE_VALUE_HIGH
		,DEL_STATUS
		,SCORE_ID
		,REQUEST_ID
		,PROGRAM_APPLICATION_ID
		,PROGRAM_ID
		,PROGRAM_UPDATE_DATE
		,CREATED_BY
		,CREATION_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATE_LOGIN
	) VALUES (
		l_del_status_id
		,1
		,p_SCORE_VALUE_LOW
		,p_SCORE_VALUE_HIGH
		,p_DEL_STATUS
		,p_SCORE_ID
		,NULL
		,NULL
		,NULL
		,NULL
		,-1
		,SYSDATE
		,-1
		,SYSDATE
		,-1
	);

Line: 145

END Insert_Row_With_Defaults;

Line: 148

/* Update_Row procedure */
PROCEDURE Update_Row(x_rowid	VARCHAR2
	,p_DEL_STATUS_ID		NUMBER
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_SCORE_VALUE_LOW		NUMBER
	,p_SCORE_VALUE_HIGH		NUMBER
	,p_DEL_STATUS		VARCHAR2
	,p_SCORE_ID		NUMBER
	,p_REQUEST_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
	,p_CREATED_BY		NUMBER
	,p_CREATION_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
) IS
BEGIN
	UPDATE IEX_DEL_STATUSES SET
		DEL_STATUS_ID = p_DEL_STATUS_ID
		,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
		,SCORE_VALUE_LOW = p_SCORE_VALUE_LOW
		,SCORE_VALUE_HIGH = p_SCORE_VALUE_HIGH
		,DEL_STATUS = p_DEL_STATUS
		,SCORE_ID = p_SCORE_ID
		,REQUEST_ID = p_REQUEST_ID
		,PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID
		,PROGRAM_ID = p_PROGRAM_ID
		,PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE
		,CREATED_BY = p_CREATED_BY
		,CREATION_DATE = p_CREATION_DATE
		,LAST_UPDATED_BY = p_LAST_UPDATED_BY
		,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
		,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
	 WHERE rowid = x_rowid;

Line: 188

END Update_Row;

Line: 190

/* Delete_Row procedure */
PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
BEGIN
	DELETE FROM IEX_DEL_STATUSES
		WHERE rowid = x_rowid;

Line: 197

	    -- No action required since this is range delete
	    null;

Line: 200

END Delete_Row;

Line: 203

/* Delete_Row procedure */
PROCEDURE Delete_del_config(p_scoreId NUMBER)
IS
BEGIN
	DELETE FROM IEX_DEL_STATUSES
		WHERE score_id = p_scoreId;

Line: 211

	    -- No action required since this is range delete
	    null;

Line: 214

END Delete_del_config ;

Line: 230

	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
	,p_CREATED_BY		NUMBER
	,p_CREATION_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
) IS
	CURSOR C IS SELECT * FROM IEX_DEL_STATUSES
		WHERE rowid = x_rowid
		FOR UPDATE of DEL_STATUS_ID NOWAIT;

Line: 246

		FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 277

		AND ( (Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
			OR ( (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
				AND (p_PROGRAM_UPDATE_DATE IS NULL)))
		AND ( (Recinfo.CREATED_BY = p_CREATED_BY)
			OR ( (Recinfo.CREATED_BY IS NULL)
				AND (p_CREATED_BY IS NULL)))
		AND ( (Recinfo.CREATION_DATE = p_CREATION_DATE)
			OR ( (Recinfo.CREATION_DATE IS NULL)
				AND (p_CREATION_DATE IS NULL)))
		AND ( (Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
			OR ( (Recinfo.LAST_UPDATED_BY IS NULL)
				AND (p_LAST_UPDATED_BY IS NULL)))
		AND ( (Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
			OR ( (Recinfo.LAST_UPDATE_DATE IS NULL)
				AND (p_LAST_UPDATE_DATE IS NULL)))
		AND ( (Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
			OR ( (Recinfo.LAST_UPDATE_LOGIN IS NULL)
				AND (p_LAST_UPDATE_LOGIN IS NULL)))
	   ) THEN
		return;