APPS.XTR_RM_MD_CURVE_RATES_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_RATE_CODE VARCHAR2,
		     X_CURVE_CODE 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_RM_MD_CURVE_RATES
		WHERE RATE_CODE = X_RATE_CODE AND CURVE_CODE = X_CURVE_CODE;

Line: 17

	CURSOR CHECK_UNIQUE IS SELECT RATE_CODE, CURVE_CODE FROM XTR_RM_MD_CURVE_RATES
		WHERE RATE_CODE = X_RATE_CODE AND CURVE_CODE = X_CURVE_CODE;

Line: 28

	INSERT INTO XTR_RM_MD_CURVE_RATES
		(
		RATE_CODE,
		CURVE_CODE,
		CREATED_BY,
		CREATION_DATE,
		LAST_UPDATED_BY,
		LAST_UPDATE_DATE,
		LAST_UPDATE_LOGIN)
	VALUES (X_RATE_CODE,
		X_CURVE_CODE,
		X_CREATED_BY,
		X_CREATION_DATE,
		X_LAST_UPDATED_BY,
		X_LAST_UPDATE_DATE,
		X_LAST_UPDATE_LOGIN);

Line: 52

END INSERT_ROW;

Line: 55

PROCEDURE DELETE_ROW (X_ROWID VARCHAR2) IS
BEGIN
	-- Perform delete
	DELETE FROM XTR_RM_MD_CURVE_RATES
		WHERE ROWID = X_ROWID;

Line: 63

END DELETE_ROW;

Line: 66

PROCEDURE UPDATE_ROW (
		     X_ROWID VARCHAR2,
		     X_RATE_CODE VARCHAR2,
		     X_CURVE_CODE VARCHAR2,
		     X_LAST_UPDATED_BY NUMBER,
		     X_LAST_UPDATE_DATE DATE,
		     X_LAST_UPDATE_LOGIN NUMBER) IS
BEGIN
	UPDATE XTR_RM_MD_CURVE_RATES
	SET	RATE_CODE	=	X_RATE_CODE,
		CURVE_CODE	=	X_CURVE_CODE,
		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: 85

END UPDATE_ROW;

Line: 93

		SELECT *
		FROM XTR_RM_MD_CURVE_RATES
		WHERE ROWID = X_ROWID
		FOR UPDATE OF RATE_CODE, CURVE_CODE NOWAIT;

Line: 105

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