APPS.LNS_APPROVAL_ACTIONS_PKG SQL Statements

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

Line: 4

/* Insert_Row procedure */
PROCEDURE Insert_Row(
	X_ACTION_ID		IN OUT NOCOPY NUMBER
	,P_LAST_UPDATE_DATE		IN DATE	DEFAULT NULL
	,P_LAST_UPDATED_BY		IN NUMBER	DEFAULT NULL
	,P_LAST_UPDATE_LOGIN		IN NUMBER	DEFAULT NULL
	,P_CREATION_DATE		IN DATE	DEFAULT NULL
	,P_CREATED_BY		IN NUMBER	DEFAULT NULL
	,P_OBJECT_VERSION_NUMBER		IN NUMBER
	,P_LOAN_ID		IN NUMBER
	,P_ACTION_TYPE		IN VARCHAR2
	,P_AMOUNT		IN NUMBER	DEFAULT NULL
	,P_REASON_CODE		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE_CATEGORY		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE1		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE2		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE3		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE4		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE5		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE6		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE7		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE8		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE9		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE10		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE11		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE12		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE13		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE14		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE15		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE16		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE17		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE18		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE19		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE20		IN VARCHAR2	DEFAULT NULL
) IS
BEGIN
	INSERT INTO LNS_APPROVAL_ACTIONS
	(
		ACTION_ID
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,CREATION_DATE
		,CREATED_BY
		,OBJECT_VERSION_NUMBER
		,LOAN_ID
		,ACTION_TYPE
		,AMOUNT
		,REASON_CODE
		,ATTRIBUTE_CATEGORY
		,ATTRIBUTE1
		,ATTRIBUTE2
		,ATTRIBUTE3
		,ATTRIBUTE4
		,ATTRIBUTE5
		,ATTRIBUTE6
		,ATTRIBUTE7
		,ATTRIBUTE8
		,ATTRIBUTE9
		,ATTRIBUTE10
		,ATTRIBUTE11
		,ATTRIBUTE12
		,ATTRIBUTE13
		,ATTRIBUTE14
		,ATTRIBUTE15
		,ATTRIBUTE16
		,ATTRIBUTE17
		,ATTRIBUTE18
		,ATTRIBUTE19
		,ATTRIBUTE20
	) VALUES (
		DECODE(X_ACTION_ID, FND_API.G_MISS_NUM, LNS_APPROVAL_ACTIONS_S.NEXTVAL, NULL, LNS_APPROVAL_ACTIONS_S.NEXTVAL, X_ACTION_ID)
		,LNS_UTILITY_PUB.LAST_UPDATE_DATE
		,LNS_UTILITY_PUB.LAST_UPDATED_BY
		,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
		,LNS_UTILITY_PUB.CREATION_DATE
		,LNS_UTILITY_PUB.CREATED_BY
		,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
		,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
		,DECODE(P_ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, P_ACTION_TYPE)
		,DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT)
		,DECODE(P_REASON_CODE, FND_API.G_MISS_CHAR, NULL, P_REASON_CODE)
		,DECODE(P_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE_CATEGORY)
		,DECODE(P_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE1)
		,DECODE(P_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE2)
		,DECODE(P_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE3)
		,DECODE(P_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE4)
		,DECODE(P_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE5)
		,DECODE(P_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE6)
		,DECODE(P_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE7)
		,DECODE(P_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE8)
		,DECODE(P_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE9)
		,DECODE(P_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE10)
		,DECODE(P_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE11)
		,DECODE(P_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE12)
		,DECODE(P_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE13)
		,DECODE(P_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE14)
		,DECODE(P_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE15)
		,DECODE(P_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE16)
		,DECODE(P_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE17)
		,DECODE(P_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE18)
		,DECODE(P_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE19)
		,DECODE(P_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE20)
	) RETURNING
		 ACTION_ID
	 INTO
		 X_ACTION_ID;

Line: 111

END Insert_Row;

Line: 113

/* Update_Row procedure */
PROCEDURE Update_Row(
	X_ACTION_ID		IN OUT NOCOPY NUMBER
	,P_LAST_UPDATE_DATE		IN DATE	DEFAULT NULL
	,P_LAST_UPDATED_BY		IN NUMBER	DEFAULT NULL
	,P_LAST_UPDATE_LOGIN		IN NUMBER	DEFAULT NULL
	,P_OBJECT_VERSION_NUMBER		IN NUMBER	DEFAULT NULL
	,P_LOAN_ID		IN NUMBER	DEFAULT NULL
	,P_ACTION_TYPE		IN VARCHAR2	DEFAULT NULL
	,P_AMOUNT		IN NUMBER	DEFAULT NULL
	,P_REASON_CODE		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE_CATEGORY		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE1		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE2		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE3		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE4		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE5		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE6		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE7		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE8		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE9		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE10		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE11		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE12		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE13		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE14		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE15		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE16		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE17		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE18		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE19		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE20		IN VARCHAR2	DEFAULT NULL
) IS
BEGIN
	UPDATE LNS_APPROVAL_ACTIONS SET
		ACTION_ID = DECODE(X_ACTION_ID, NULL, ACTION_ID, FND_API.G_MISS_NUM, NULL, X_ACTION_ID)
		,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
		,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
		,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
		,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
		,ACTION_TYPE = DECODE(P_ACTION_TYPE, NULL, ACTION_TYPE, FND_API.G_MISS_CHAR, NULL, P_ACTION_TYPE)
		,AMOUNT = DECODE(P_AMOUNT, NULL, AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT)
		,REASON_CODE = DECODE(P_REASON_CODE, NULL, REASON_CODE, FND_API.G_MISS_CHAR, NULL, P_REASON_CODE)
		,ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE_CATEGORY)
		,ATTRIBUTE1 = DECODE(P_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE1)
		,ATTRIBUTE2 = DECODE(P_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE2)
		,ATTRIBUTE3 = DECODE(P_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE3)
		,ATTRIBUTE4 = DECODE(P_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE4)
		,ATTRIBUTE5 = DECODE(P_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE5)
		,ATTRIBUTE6 = DECODE(P_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE6)
		,ATTRIBUTE7 = DECODE(P_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE7)
		,ATTRIBUTE8 = DECODE(P_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE8)
		,ATTRIBUTE9 = DECODE(P_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE9)
		,ATTRIBUTE10 = DECODE(P_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE10)
		,ATTRIBUTE11 = DECODE(P_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE11)
		,ATTRIBUTE12 = DECODE(P_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE12)
		,ATTRIBUTE13 = DECODE(P_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE13)
		,ATTRIBUTE14 = DECODE(P_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE14)
		,ATTRIBUTE15 = DECODE(P_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE15)
		,ATTRIBUTE16 = DECODE(P_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE16)
		,ATTRIBUTE17 = DECODE(P_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE17)
		,ATTRIBUTE18 = DECODE(P_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE18)
		,ATTRIBUTE19 = DECODE(P_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE19)
		,ATTRIBUTE20 = DECODE(P_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, P_ATTRIBUTE20)
	 WHERE ACTION_ID = X_ACTION_ID;

Line: 183

END Update_Row;

Line: 185

/* Delete_Row procedure */
PROCEDURE Delete_Row(P_ACTION_ID IN NUMBER) IS
BEGIN
	DELETE FROM LNS_APPROVAL_ACTIONS
		WHERE ACTION_ID = P_ACTION_ID;

Line: 194

END Delete_Row;

Line: 199

	,P_LAST_UPDATE_DATE		IN DATE	DEFAULT NULL
	,P_LAST_UPDATED_BY		IN NUMBER	DEFAULT NULL
	,P_LAST_UPDATE_LOGIN		IN NUMBER	DEFAULT NULL
	,P_CREATION_DATE		IN DATE	DEFAULT NULL
	,P_CREATED_BY		IN NUMBER	DEFAULT NULL
	,P_OBJECT_VERSION_NUMBER		IN NUMBER	DEFAULT NULL
	,P_LOAN_ID		IN NUMBER	DEFAULT NULL
	,P_ACTION_TYPE		IN VARCHAR2	DEFAULT NULL
	,P_AMOUNT		IN NUMBER	DEFAULT NULL
	,P_REASON_CODE		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE_CATEGORY		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE1		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE2		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE3		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE4		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE5		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE6		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE7		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE8		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE9		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE10		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE11		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE12		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE13		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE14		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE15		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE16		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE17		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE18		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE19		IN VARCHAR2	DEFAULT NULL
	,P_ATTRIBUTE20		IN VARCHAR2	DEFAULT NULL
) IS
	CURSOR C IS SELECT * FROM LNS_APPROVAL_ACTIONS
		WHERE ACTION_ID = P_ACTION_ID
		FOR UPDATE of ACTION_ID NOWAIT;

Line: 240

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

Line: 247

		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_UPDATED_BY = P_LAST_UPDATED_BY)
			OR ( (Recinfo.LAST_UPDATED_BY IS NULL)
				AND (P_LAST_UPDATED_BY 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)))
		AND ( (Recinfo.CREATION_DATE = P_CREATION_DATE)
			OR ( (Recinfo.CREATION_DATE IS NULL)
				AND (P_CREATION_DATE IS NULL)))
		AND ( (Recinfo.CREATED_BY = P_CREATED_BY)
			OR ( (Recinfo.CREATED_BY IS NULL)
				AND (P_CREATED_BY IS NULL)))
		AND ( (Recinfo.OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER)
			OR ( (Recinfo.OBJECT_VERSION_NUMBER IS NULL)
				AND (P_OBJECT_VERSION_NUMBER IS NULL)))
		AND ( (Recinfo.LOAN_ID = P_LOAN_ID)
			OR ( (Recinfo.LOAN_ID IS NULL)
				AND (P_LOAN_ID IS NULL)))
		AND ( (Recinfo.ACTION_TYPE = P_ACTION_TYPE)
			OR ( (Recinfo.ACTION_TYPE IS NULL)
				AND (P_ACTION_TYPE IS NULL)))
		AND ( (Recinfo.AMOUNT = P_AMOUNT)
			OR ( (Recinfo.AMOUNT IS NULL)
				AND (P_AMOUNT IS NULL)))
		AND ( (Recinfo.REASON_CODE = P_REASON_CODE)
			OR ( (Recinfo.REASON_CODE IS NULL)
				AND (P_REASON_CODE IS NULL)))
		AND ( (Recinfo.ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY)
			OR ( (Recinfo.ATTRIBUTE_CATEGORY IS NULL)
				AND (P_ATTRIBUTE_CATEGORY IS NULL)))
		AND ( (Recinfo.ATTRIBUTE1 = P_ATTRIBUTE1)
			OR ( (Recinfo.ATTRIBUTE1 IS NULL)
				AND (P_ATTRIBUTE1 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE2 = P_ATTRIBUTE2)
			OR ( (Recinfo.ATTRIBUTE2 IS NULL)
				AND (P_ATTRIBUTE2 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE3 = P_ATTRIBUTE3)
			OR ( (Recinfo.ATTRIBUTE3 IS NULL)
				AND (P_ATTRIBUTE3 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE4 = P_ATTRIBUTE4)
			OR ( (Recinfo.ATTRIBUTE4 IS NULL)
				AND (P_ATTRIBUTE4 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE5 = P_ATTRIBUTE5)
			OR ( (Recinfo.ATTRIBUTE5 IS NULL)
				AND (P_ATTRIBUTE5 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE6 = P_ATTRIBUTE6)
			OR ( (Recinfo.ATTRIBUTE6 IS NULL)
				AND (P_ATTRIBUTE6 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE7 = P_ATTRIBUTE7)
			OR ( (Recinfo.ATTRIBUTE7 IS NULL)
				AND (P_ATTRIBUTE7 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE8 = P_ATTRIBUTE8)
			OR ( (Recinfo.ATTRIBUTE8 IS NULL)
				AND (P_ATTRIBUTE8 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE9 = P_ATTRIBUTE9)
			OR ( (Recinfo.ATTRIBUTE9 IS NULL)
				AND (P_ATTRIBUTE9 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE10 = P_ATTRIBUTE10)
			OR ( (Recinfo.ATTRIBUTE10 IS NULL)
				AND (P_ATTRIBUTE10 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE11 = P_ATTRIBUTE11)
			OR ( (Recinfo.ATTRIBUTE11 IS NULL)
				AND (P_ATTRIBUTE11 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE12 = P_ATTRIBUTE12)
			OR ( (Recinfo.ATTRIBUTE12 IS NULL)
				AND (P_ATTRIBUTE12 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE13 = P_ATTRIBUTE13)
			OR ( (Recinfo.ATTRIBUTE13 IS NULL)
				AND (P_ATTRIBUTE13 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE14 = P_ATTRIBUTE14)
			OR ( (Recinfo.ATTRIBUTE14 IS NULL)
				AND (P_ATTRIBUTE14 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE15 = P_ATTRIBUTE15)
			OR ( (Recinfo.ATTRIBUTE15 IS NULL)
				AND (P_ATTRIBUTE15 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE16 = P_ATTRIBUTE16)
			OR ( (Recinfo.ATTRIBUTE16 IS NULL)
				AND (P_ATTRIBUTE16 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE17 = P_ATTRIBUTE17)
			OR ( (Recinfo.ATTRIBUTE17 IS NULL)
				AND (P_ATTRIBUTE17 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE18 = P_ATTRIBUTE18)
			OR ( (Recinfo.ATTRIBUTE18 IS NULL)
				AND (P_ATTRIBUTE18 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE19 = P_ATTRIBUTE19)
			OR ( (Recinfo.ATTRIBUTE19 IS NULL)
				AND (P_ATTRIBUTE19 IS NULL)))
		AND ( (Recinfo.ATTRIBUTE20 = P_ATTRIBUTE20)
			OR ( (Recinfo.ATTRIBUTE20 IS NULL)
				AND (P_ATTRIBUTE20 IS NULL)))
	   ) THEN
		return;