APPS.LNS_DISB_LINES_PKG SQL Statements

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

Line: 4

/* Insert_Row procedure */
PROCEDURE Insert_Row(
	X_DISB_LINE_ID		IN OUT NOCOPY NUMBER
	,P_DISB_HEADER_ID		IN NUMBER
	,P_DISB_LINE_NUMBER		IN NUMBER
	,P_LINE_AMOUNT		IN NUMBER
	,P_LINE_PERCENT		IN NUMBER
	,P_PAYEE_PARTY_ID		IN NUMBER
	,P_BANK_ACCOUNT_ID		IN NUMBER
	,P_PAYMENT_METHOD_CODE		IN VARCHAR2
	,P_STATUS		IN VARCHAR2
	,P_REQUEST_DATE		IN DATE
	,P_DISBURSEMENT_DATE		IN DATE
	,P_OBJECT_VERSION_NUMBER		IN NUMBER
	,P_CREATION_DATE		IN DATE
	,P_CREATED_BY		IN NUMBER
	,P_LAST_UPDATE_DATE		IN DATE
	,P_LAST_UPDATED_BY		IN NUMBER
	,P_LAST_UPDATE_LOGIN		IN NUMBER
	,P_INVOICE_INTERFACE_ID		IN NUMBER
	,P_INVOICE_ID		IN NUMBER
) IS
BEGIN
	INSERT INTO LNS_DISB_LINES
	(
		DISB_LINE_ID
		,DISB_HEADER_ID
		,DISB_LINE_NUMBER
		,LINE_AMOUNT
		,LINE_PERCENT
		,PAYEE_PARTY_ID
		,BANK_ACCOUNT_ID
		,PAYMENT_METHOD_CODE
		,STATUS
		,REQUEST_DATE
		,DISBURSEMENT_DATE
		,OBJECT_VERSION_NUMBER
		,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN
		,INVOICE_INTERFACE_ID
		,INVOICE_ID
	) VALUES (
		DECODE(X_DISB_LINE_ID, FND_API.G_MISS_NUM, LNS_DISB_LINES_S.NEXTVAL, NULL, LNS_DISB_LINES_S.NEXTVAL, X_DISB_LINE_ID)
		,DECODE(P_DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
		,DECODE(P_DISB_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, P_DISB_LINE_NUMBER)
		,DECODE(P_LINE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_LINE_AMOUNT)
		,DECODE(P_LINE_PERCENT, FND_API.G_MISS_NUM, NULL, P_LINE_PERCENT)
		,DECODE(P_PAYEE_PARTY_ID, FND_API.G_MISS_NUM, NULL, P_PAYEE_PARTY_ID)
		,DECODE(P_BANK_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, P_BANK_ACCOUNT_ID)
		,DECODE(P_PAYMENT_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, P_PAYMENT_METHOD_CODE)
		,DECODE(P_STATUS, FND_API.G_MISS_CHAR, NULL, P_STATUS)
		,DECODE(P_REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_REQUEST_DATE)
		,DECODE(P_DISBURSEMENT_DATE, FND_API.G_MISS_DATE, NULL, P_DISBURSEMENT_DATE)
		,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
		,LNS_UTILITY_PUB.CREATION_DATE
		,LNS_UTILITY_PUB.CREATED_BY
		,LNS_UTILITY_PUB.LAST_UPDATE_DATE
		,LNS_UTILITY_PUB.LAST_UPDATED_BY
		,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
		,DECODE(P_INVOICE_INTERFACE_ID, FND_API.G_MISS_NUM, NULL, P_INVOICE_INTERFACE_ID)
		,DECODE(P_INVOICE_ID, FND_API.G_MISS_NUM, NULL, P_INVOICE_ID)
	) RETURNING
		 DISB_LINE_ID
	 INTO
		 X_DISB_LINE_ID;

Line: 72

END Insert_Row;

Line: 74

/* Update_Row procedure */
PROCEDURE Update_Row(
	P_DISB_LINE_ID		IN NUMBER
	,P_DISB_HEADER_ID		IN NUMBER
	,P_DISB_LINE_NUMBER		IN NUMBER
	,P_LINE_AMOUNT		IN NUMBER
	,P_LINE_PERCENT		IN NUMBER
	,P_PAYEE_PARTY_ID		IN NUMBER
	,P_BANK_ACCOUNT_ID		IN NUMBER
	,P_PAYMENT_METHOD_CODE		IN VARCHAR2
	,P_STATUS		IN VARCHAR2
	,P_REQUEST_DATE		IN DATE
	,P_DISBURSEMENT_DATE		IN DATE
	,P_OBJECT_VERSION_NUMBER		IN NUMBER
	,P_LAST_UPDATE_DATE		IN DATE
	,P_LAST_UPDATED_BY		IN NUMBER
	,P_LAST_UPDATE_LOGIN		IN NUMBER
	,P_INVOICE_INTERFACE_ID		IN NUMBER
	,P_INVOICE_ID		IN NUMBER
) IS
BEGIN
	UPDATE LNS_DISB_LINES SET
		DISB_HEADER_ID = DECODE(P_DISB_HEADER_ID, NULL, DISB_HEADER_ID, FND_API.G_MISS_NUM, NULL, P_DISB_HEADER_ID)
		,DISB_LINE_NUMBER = DECODE(P_DISB_LINE_NUMBER, NULL, DISB_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, P_DISB_LINE_NUMBER)
		,LINE_AMOUNT = DECODE(P_LINE_AMOUNT, NULL, LINE_AMOUNT, FND_API.G_MISS_NUM, NULL, P_LINE_AMOUNT)
		,LINE_PERCENT = DECODE(P_LINE_PERCENT, NULL, LINE_PERCENT, FND_API.G_MISS_NUM, NULL, P_LINE_PERCENT)
		,PAYEE_PARTY_ID = DECODE(P_PAYEE_PARTY_ID, NULL, PAYEE_PARTY_ID, FND_API.G_MISS_NUM, NULL, P_PAYEE_PARTY_ID)
		,BANK_ACCOUNT_ID = DECODE(P_BANK_ACCOUNT_ID, NULL, BANK_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, P_BANK_ACCOUNT_ID)
		,PAYMENT_METHOD_CODE = DECODE(P_PAYMENT_METHOD_CODE, NULL, PAYMENT_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, P_PAYMENT_METHOD_CODE)
		,STATUS = DECODE(P_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, NULL, P_STATUS)
		,REQUEST_DATE = DECODE(P_REQUEST_DATE, NULL, REQUEST_DATE, FND_API.G_MISS_DATE, NULL, P_REQUEST_DATE)
		,DISBURSEMENT_DATE = DECODE(P_DISBURSEMENT_DATE, NULL, DISBURSEMENT_DATE, FND_API.G_MISS_DATE, NULL, P_DISBURSEMENT_DATE)
		,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
		,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
		,INVOICE_INTERFACE_ID = DECODE(P_INVOICE_INTERFACE_ID, NULL, INVOICE_INTERFACE_ID, FND_API.G_MISS_NUM, NULL, P_INVOICE_INTERFACE_ID)
		,INVOICE_ID = DECODE(P_INVOICE_ID, NULL, INVOICE_ID, FND_API.G_MISS_NUM, NULL, P_INVOICE_ID)
	 WHERE DISB_LINE_ID = P_DISB_LINE_ID;

Line: 117

END Update_Row;

Line: 119

/* Delete_Row procedure */
PROCEDURE Delete_Row(P_DISB_LINE_ID IN NUMBER) IS
BEGIN
	DELETE FROM LNS_DISB_LINES
		WHERE DISB_LINE_ID = P_DISB_LINE_ID;

Line: 128

END Delete_Row;

Line: 146

	,P_LAST_UPDATE_DATE		IN DATE
	,P_LAST_UPDATED_BY		IN NUMBER
	,P_LAST_UPDATE_LOGIN		IN NUMBER
	,P_INVOICE_INTERFACE_ID		IN NUMBER
	,P_INVOICE_ID		IN NUMBER
) IS
	CURSOR C IS SELECT * FROM LNS_DISB_LINES
		WHERE DISB_LINE_ID = P_DISB_LINE_ID
		FOR UPDATE of DISB_LINE_ID NOWAIT;

Line: 161

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

Line: 207

		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.INVOICE_INTERFACE_ID = P_INVOICE_INTERFACE_ID)
			OR ( (Recinfo.INVOICE_INTERFACE_ID IS NULL)
				AND (P_INVOICE_INTERFACE_ID IS NULL)))
		AND ( (Recinfo.INVOICE_ID = P_INVOICE_ID)
			OR ( (Recinfo.INVOICE_ID IS NULL)
				AND (P_INVOICE_ID IS NULL)))
	   ) THEN
		return;