APPS.XTR_HEDGE_PRO_TESTS_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW(
		X_ROWID IN OUT NOCOPY VARCHAR2,
                X_HEDGE_PRO_TEST_ID NUMBER,
                X_HEDGE_ATTRIBUTE_ID NUMBER,
                X_COMPANY_CODE VARCHAR2,
                X_RESULT_CODE VARCHAR2,
                X_RESULT_DATE DATE,
                X_LAST_TEST_DATE DATE,
                X_PERFORMED_BY NUMBER,
                X_COMMENTS VARCHAR2,
		X_ATTRIBUTE_CATEGORY VARCHAR2,
		X_ATTRIBUTE1 VARCHAR2,
		X_ATTRIBUTE2 VARCHAR2,
		X_ATTRIBUTE3 VARCHAR2,
		X_ATTRIBUTE4 VARCHAR2,
		X_ATTRIBUTE5 VARCHAR2,
		X_ATTRIBUTE6 VARCHAR2,
		X_ATTRIBUTE7 VARCHAR2,
		X_ATTRIBUTE8 VARCHAR2,
		X_ATTRIBUTE9 VARCHAR2,
		X_ATTRIBUTE10 VARCHAR2,
		X_ATTRIBUTE11 VARCHAR2,
		X_ATTRIBUTE12 VARCHAR2,
		X_ATTRIBUTE13 VARCHAR2,
		X_ATTRIBUTE14 VARCHAR2,
		X_ATTRIBUTE15 VARCHAR2,
		X_CREATED_BY NUMBER,
		X_CREATION_DATE DATE,
		X_LAST_UPDATED_BY NUMBER,
		X_LAST_UPDATE_DATE DATE,
		X_LAST_UPDATE_LOGIN NUMBER) IS
    cursor C is select ROWID from XTR_HEDGE_PRO_TESTS
    where HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID;

Line: 39

  INSERT INTO XTR_HEDGE_PRO_TESTS(
        HEDGE_PRO_TEST_ID,
        HEDGE_ATTRIBUTE_ID,
        COMPANY_CODE,
        RESULT_CODE,
        RESULT_DATE,
        LAST_TEST_DATE,
        PERFORMED_BY,
        COMMENTS,
 	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
	ATTRIBUTE15,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN)
  VALUES (X_HEDGE_PRO_TEST_ID,
        X_HEDGE_ATTRIBUTE_ID,
        X_COMPANY_CODE,
        X_RESULT_CODE,
        X_RESULT_DATE,
        X_LAST_TEST_DATE,
        X_PERFORMED_BY,
        X_COMMENTS,
	X_ATTRIBUTE_CATEGORY,
	X_ATTRIBUTE1,
	X_ATTRIBUTE2,
	X_ATTRIBUTE3,
	X_ATTRIBUTE4,
	X_ATTRIBUTE5,
	X_ATTRIBUTE6,
	X_ATTRIBUTE7,
	X_ATTRIBUTE8,
	X_ATTRIBUTE9,
	X_ATTRIBUTE10,
	X_ATTRIBUTE11,
	X_ATTRIBUTE12,
	X_ATTRIBUTE13,
	X_ATTRIBUTE14,
	X_ATTRIBUTE15,
	X_CREATED_BY,
	X_CREATION_DATE,
	X_LAST_UPDATED_BY,
	X_LAST_UPDATE_DATE,
	X_LAST_UPDATE_LOGIN);

Line: 107

END INSERT_ROW;

Line: 109

PROCEDURE DELETE_ROW (X_HEDGE_PRO_TEST_ID NUMBER) IS

BEGIN
	-- DELETE THE ROW, SINCE NOT USED ANYWHERE ELSE
	DELETE FROM XTR_HEDGE_PRO_TESTS
	WHERE HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID;

Line: 118

END DELETE_ROW;

Line: 121

PROCEDURE UPDATE_ROW(
		X_ROWID VARCHAR2,
                X_HEDGE_PRO_TEST_ID NUMBER,
                X_HEDGE_ATTRIBUTE_ID NUMBER,
                X_COMPANY_CODE VARCHAR2,
                X_RESULT_CODE VARCHAR2,
                X_RESULT_DATE DATE,
                X_LAST_TEST_DATE DATE,
                X_PERFORMED_BY NUMBER,
                X_COMMENTS VARCHAR2,
		X_ATTRIBUTE_CATEGORY VARCHAR2,
		X_ATTRIBUTE1 VARCHAR2,
		X_ATTRIBUTE2 VARCHAR2,
		X_ATTRIBUTE3 VARCHAR2,
		X_ATTRIBUTE4 VARCHAR2,
		X_ATTRIBUTE5 VARCHAR2,
		X_ATTRIBUTE6 VARCHAR2,
		X_ATTRIBUTE7 VARCHAR2,
		X_ATTRIBUTE8 VARCHAR2,
		X_ATTRIBUTE9 VARCHAR2,
		X_ATTRIBUTE10 VARCHAR2,
		X_ATTRIBUTE11 VARCHAR2,
		X_ATTRIBUTE12 VARCHAR2,
		X_ATTRIBUTE13 VARCHAR2,
		X_ATTRIBUTE14 VARCHAR2,
		X_ATTRIBUTE15 VARCHAR2,
		X_LAST_UPDATED_BY NUMBER,
		X_LAST_UPDATE_DATE DATE,
		X_LAST_UPDATE_LOGIN NUMBER) IS
BEGIN
	UPDATE XTR_HEDGE_PRO_TESTS
	SET
                HEDGE_PRO_TEST_ID       = X_HEDGE_PRO_TEST_ID,
                HEDGE_ATTRIBUTE_ID      = X_HEDGE_ATTRIBUTE_ID,
                COMPANY_CODE		= X_COMPANY_CODE,
                RESULT_CODE		= X_RESULT_CODE,
                RESULT_DATE 		= X_RESULT_DATE,
                LAST_TEST_DATE		= X_LAST_TEST_DATE,
                PERFORMED_BY		= X_PERFORMED_BY,
                COMMENTS		= X_COMMENTS,
		ATTRIBUTE_CATEGORY	= X_ATTRIBUTE_CATEGORY,
		ATTRIBUTE1	=	X_ATTRIBUTE1,
		ATTRIBUTE2	=	X_ATTRIBUTE2,
		ATTRIBUTE3	=	X_ATTRIBUTE3,
		ATTRIBUTE4	=	X_ATTRIBUTE4,
		ATTRIBUTE5	=	X_ATTRIBUTE5,
		ATTRIBUTE6	=	X_ATTRIBUTE6,
		ATTRIBUTE7	=	X_ATTRIBUTE7,
		ATTRIBUTE8	=	X_ATTRIBUTE8,
		ATTRIBUTE9	=	X_ATTRIBUTE9,
		ATTRIBUTE10	=	X_ATTRIBUTE10,
		ATTRIBUTE11	=	X_ATTRIBUTE11,
		ATTRIBUTE12	=	X_ATTRIBUTE12,
		ATTRIBUTE13	=	X_ATTRIBUTE13,
		ATTRIBUTE14	=	X_ATTRIBUTE14,
		ATTRIBUTE15	=	X_ATTRIBUTE15,
		LAST_UPDATED_BY	=	X_LAST_UPDATED_BY,
		LAST_UPDATE_DATE	=	X_LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN	=	X_LAST_UPDATE_LOGIN
	WHERE HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID;

Line: 185

END UPDATE_ROW;

Line: 215

		SELECT *
		FROM XTR_HEDGE_PRO_TESTS
		WHERE HEDGE_PRO_TEST_ID = X_HEDGE_PRO_TEST_ID
		FOR UPDATE OF RESULT_CODE NOWAIT;

Line: 226

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