APPS.IEX_PAY_OKL_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_PAY_OKL_XREF_ID		NUMBER	DEFAULT NULL
	,p_OKL_PAYMENT_ID		NUMBER	DEFAULT NULL
	,p_CNSLD_INVOICE_ID		NUMBER	DEFAULT NULL
	,p_CONTRACT_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATE_DATE		DATE
	,p_SECURITY_GROUP_ID		NUMBER	DEFAULT NULL
	,p_PAYMENT_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_REQUEST_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
) IS
	CURSOR C IS SELECT ROWID FROM IEX_PAY_OKL_XREF
		WHERE PAY_OKL_XREF_ID = p_PAY_OKL_XREF_ID;

Line: 29

	INSERT INTO IEX_PAY_OKL_XREF
	(
		PAY_OKL_XREF_ID
		,OKL_PAYMENT_ID
		,CNSLD_INVOICE_ID
		,CONTRACT_ID
		,LAST_UPDATE_DATE
		,SECURITY_GROUP_ID
		,PAYMENT_ID
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,CREATION_DATE
		,CREATED_BY
		,PROGRAM_ID
		,OBJECT_VERSION_NUMBER
		,REQUEST_ID
		,PROGRAM_APPLICATION_ID
		,PROGRAM_UPDATE_DATE
	) VALUES (
		p_PAY_OKL_XREF_ID
		,p_OKL_PAYMENT_ID
		,p_CNSLD_INVOICE_ID
		,p_CONTRACT_ID
		,p_LAST_UPDATE_DATE
		,p_SECURITY_GROUP_ID
		,p_PAYMENT_ID
		,p_LAST_UPDATED_BY
		,p_LAST_UPDATE_LOGIN
		,p_CREATION_DATE
		,p_CREATED_BY
		,p_PROGRAM_ID
		,p_OBJECT_VERSION_NUMBER
		,p_REQUEST_ID
		,p_PROGRAM_APPLICATION_ID
		,p_PROGRAM_UPDATE_DATE
	);

Line: 73

END Insert_Row;

Line: 75

/* Update_Row procedure */
PROCEDURE Update_Row(x_rowid	VARCHAR2
	,p_PAY_OKL_XREF_ID		NUMBER	DEFAULT NULL
	,p_OKL_PAYMENT_ID		NUMBER	DEFAULT NULL
	,p_CNSLD_INVOICE_ID		NUMBER	DEFAULT NULL
	,p_CONTRACT_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATE_DATE		DATE
	,p_SECURITY_GROUP_ID		NUMBER	DEFAULT NULL
	,p_PAYMENT_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_REQUEST_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
) IS
BEGIN
	UPDATE IEX_PAY_OKL_XREF SET
		PAY_OKL_XREF_ID = p_PAY_OKL_XREF_ID
		,OKL_PAYMENT_ID = p_OKL_PAYMENT_ID
		,CNSLD_INVOICE_ID = p_CNSLD_INVOICE_ID
		,CONTRACT_ID = p_CONTRACT_ID
		,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
		,SECURITY_GROUP_ID = p_SECURITY_GROUP_ID
		,PAYMENT_ID = p_PAYMENT_ID
		,LAST_UPDATED_BY = p_LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
		,CREATION_DATE = p_CREATION_DATE
		,CREATED_BY = p_CREATED_BY
		,PROGRAM_ID = p_PROGRAM_ID
		,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
		,REQUEST_ID = p_REQUEST_ID
		,PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID
		,PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE
	 WHERE rowid = x_rowid;

Line: 117

END Update_Row;

Line: 119

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

Line: 128

END Delete_Row;

Line: 136

	,p_LAST_UPDATE_DATE		DATE
	,p_SECURITY_GROUP_ID		NUMBER	DEFAULT NULL
	,p_PAYMENT_ID		NUMBER	DEFAULT NULL
	,p_LAST_UPDATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER	DEFAULT NULL
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_PROGRAM_ID		NUMBER	DEFAULT NULL
	,p_OBJECT_VERSION_NUMBER		NUMBER
	,p_REQUEST_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_APPLICATION_ID		NUMBER	DEFAULT NULL
	,p_PROGRAM_UPDATE_DATE		DATE	DEFAULT NULL
) IS
	CURSOR C IS SELECT * FROM IEX_PAY_OKL_XREF
		WHERE rowid = x_rowid
		FOR UPDATE of PAY_OKL_XREF_ID NOWAIT;

Line: 158

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

Line: 174

		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.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID)
			OR ( (Recinfo.SECURITY_GROUP_ID IS NULL)
				AND (p_SECURITY_GROUP_ID IS NULL)))
		AND ( (Recinfo.PAYMENT_ID = p_PAYMENT_ID)
			OR ( (Recinfo.PAYMENT_ID IS NULL)
				AND (p_PAYMENT_ID 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.PROGRAM_ID = p_PROGRAM_ID)
			OR ( (Recinfo.PROGRAM_ID IS NULL)
				AND (p_PROGRAM_ID 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.REQUEST_ID = p_REQUEST_ID)
			OR ( (Recinfo.REQUEST_ID IS NULL)
				AND (p_REQUEST_ID IS NULL)))
		AND ( (Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
			OR ( (Recinfo.PROGRAM_APPLICATION_ID IS NULL)
				AND (p_PROGRAM_APPLICATION_ID IS NULL)))
		AND ( (Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
			OR ( (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
				AND (p_PROGRAM_UPDATE_DATE IS NULL)))
	   ) THEN
		return;