APPS.IEX_DEL_PAY_XREF_PKG SQL Statements

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

Line: 4

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

Line: 7

PROCEDURE Insert_Row(x_rowid	IN OUT NOCOPY VARCHAR2
	,p_DEL_PAY_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_DELINQUENCY_ID		NUMBER	DEFAULT NULL
	,p_PAYMENT_ID		NUMBER	DEFAULT NULL
) IS
	CURSOR C IS SELECT ROWID FROM IEX_DEL_PAY_XREF
		WHERE DEL_PAY_ID = p_DEL_PAY_ID;

Line: 23

	INSERT INTO IEX_DEL_PAY_XREF
	(
		DEL_PAY_ID
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,CREATION_DATE
		,CREATED_BY
		,OBJECT_VERSION_NUMBER
		,PROGRAM_ID
		,DELINQUENCY_ID
		,PAYMENT_ID
	) VALUES (
		p_DEL_PAY_ID
		,p_LAST_UPDATE_DATE
		,p_LAST_UPDATED_BY
		,p_LAST_UPDATE_LOGIN
		,p_CREATION_DATE
		,p_CREATED_BY
		,p_OBJECT_VERSION_NUMBER
		,p_PROGRAM_ID
		,p_DELINQUENCY_ID
		,p_PAYMENT_ID
	);

Line: 55

END Insert_Row;

Line: 57

/* Update_Row procedure */
PROCEDURE Update_Row(x_rowid	VARCHAR2
	,p_DEL_PAY_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_DELINQUENCY_ID		NUMBER	DEFAULT NULL
	,p_PAYMENT_ID		NUMBER	DEFAULT NULL
) IS
BEGIN
	UPDATE IEX_DEL_PAY_XREF SET
		DEL_PAY_ID = p_DEL_PAY_ID
		,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
		,LAST_UPDATED_BY = p_LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
		,CREATION_DATE = p_CREATION_DATE
		,CREATED_BY = p_CREATED_BY
		,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
		,PROGRAM_ID = p_PROGRAM_ID
		,DELINQUENCY_ID = p_DELINQUENCY_ID
		,PAYMENT_ID = p_PAYMENT_ID
	 WHERE rowid = x_rowid;

Line: 87

END Update_Row;

Line: 89

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

Line: 98

END Delete_Row;

Line: 103

	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_DELINQUENCY_ID		NUMBER	DEFAULT NULL
	,p_PAYMENT_ID		NUMBER	DEFAULT NULL
) IS
	CURSOR C IS SELECT * FROM IEX_DEL_PAY_XREF
		WHERE rowid = x_rowid
		FOR UPDATE of DEL_PAY_ID NOWAIT;

Line: 122

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

Line: 129

		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.PROGRAM_ID = p_PROGRAM_ID)
			OR ( (Recinfo.PROGRAM_ID IS NULL)
				AND (p_PROGRAM_ID IS NULL)))
		AND ( (Recinfo.DELINQUENCY_ID = p_DELINQUENCY_ID)
			OR ( (Recinfo.DELINQUENCY_ID IS NULL)
				AND (p_DELINQUENCY_ID IS NULL)))
		AND ( (Recinfo.PAYMENT_ID = p_PAYMENT_ID)
			OR ( (Recinfo.PAYMENT_ID IS NULL)
				AND (p_PAYMENT_ID IS NULL)))
	   ) THEN
		return;