APPS.XTR_RM_MD_CURVES_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_CURVE_CODE VARCHAR2,
		X_DESCRIPTION VARCHAR2,
		X_TYPE VARCHAR2,
		X_CCY VARCHAR2,
		X_CONTRA_CCY VARCHAR2,
		X_DATA_SIDE VARCHAR2,
		X_DEFAULT_INTERPOLATION VARCHAR2,
		X_AUTHORIZED_YN 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

	X_CURVE_CODE_TMP VARCHAR(20);

Line: 39

		SELECT CURVE_CODE
		FROM XTR_RM_MD_CURVES
		WHERE CURVE_CODE = X_CURVE_CODE;

Line: 44

		SELECT ROWID FROM XTR_RM_MD_CURVES
		WHERE CURVE_CODE = X_CURVE_CODE;

Line: 52

		INSERT INTO XTR_RM_MD_CURVES (
			CURVE_CODE,
			DESCRIPTION,
			TYPE,
			CCY,
			CONTRA_CCY,
			DATA_SIDE,
			DEFAULT_INTERPOLATION,
			AUTHORIZED_YN,
			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_CURVE_CODE,
			X_DESCRIPTION,
			X_TYPE,
			X_CCY,
			X_CONTRA_CCY,
			X_DATA_SIDE,
			X_DEFAULT_INTERPOLATION,
			X_AUTHORIZED_YN,
			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: 127

END INSERT_ROW;

Line: 129

PROCEDURE DELETE_ROW (X_ROWID VARCHAR2) IS

BEGIN
		-- DELETE THE ROW, SINCE NOT USED ANYWHERE ELSE
		DELETE FROM XTR_RM_MD_CURVES
		WHERE ROWID = X_ROWID;

Line: 138

END DELETE_ROW;

Line: 141

PROCEDURE UPDATE_ROW(
		X_ROWID VARCHAR2,
		X_CURVE_CODE VARCHAR2,
		X_DESCRIPTION VARCHAR2,
		X_TYPE VARCHAR2,
		X_CCY VARCHAR2,
		X_CONTRA_CCY VARCHAR2,
		X_DATA_SIDE VARCHAR2,
		X_DEFAULT_INTERPOLATION VARCHAR2,
		X_AUTHORIZED_YN 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_RM_MD_CURVES
	SET
		CURVE_CODE 	= 	X_CURVE_CODE,
		DESCRIPTION	=	X_DESCRIPTION,
		TYPE		=  	X_TYPE,
		CCY		=	X_CCY,
		CONTRA_CCY	=	X_CONTRA_CCY,
		DATA_SIDE	=	X_DATA_SIDE,
		DEFAULT_INTERPOLATION	=	X_DEFAULT_INTERPOLATION,
		AUTHORIZED_YN	=	X_AUTHORIZED_YN,
		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 ROWID = X_ROWID;

Line: 205

END UPDATE_ROW;

Line: 235

		SELECT *
		FROM XTR_RM_MD_CURVES
		WHERE ROWID = X_ROWID
		FOR UPDATE OF CURVE_CODE NOWAIT;

Line: 246

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