APPS.XTR_RM_MD_SET_CURVES_PKG SQL Statements

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

Line: 4

    PROCEDURE insert_row(p_rowid	    IN OUT NOCOPY VARCHAR2,
			 p_curve_code       IN VARCHAR2,
			 p_data_side        IN VARCHAR2,
			 p_interpolation    IN VARCHAR2,
			 p_set_code 	    IN VARCHAR2,
			 p_created_by 	    IN NUMBER,
			 p_creation_date    IN DATE,
			 p_last_updated_by  IN NUMBER,
			 p_last_update_date IN DATE,
			 p_last_update_login IN NUMBER) IS

    CURSOR C IS select rowid from xtr_rm_md_set_curves
		where set_code = p_set_code and curve_code = p_curve_code;

Line: 20

	INSERT INTO xtr_rm_md_set_curves(curve_code,
				 	 data_side,
				   	 interpolation,
					 set_code,
				  	 created_by,
					 creation_date,
					 last_updated_by,
					 last_update_date,
					 last_update_login)
				 VALUES (p_curve_code,
					 p_data_side,
					 p_interpolation,
					 p_set_code,
					 p_created_by,
					 p_creation_date,
					 p_last_updated_by,
					 p_last_update_date,
				  	 p_last_update_login);

Line: 46

END insert_row;

Line: 49

    PROCEDURE update_row(p_rowid	    IN VARCHAR2,
			 p_curve_code       IN VARCHAR2,
			 p_data_side        IN VARCHAR2,
			 p_interpolation    IN VARCHAR2,
			 p_set_code 	    IN VARCHAR2,
			 p_last_updated_by  IN NUMBER,
			 p_last_update_date IN DATE,
			 p_last_update_login IN NUMBER) IS


    BEGIN

	UPDATE xtr_rm_md_set_curves SET set_code 	 = p_set_code,
					curve_code	 = p_curve_code,
					data_side	 = p_data_side,
					interpolation	 = p_interpolation,
				  	last_updated_by  = p_last_updated_by,
				  	last_update_date = p_last_update_date,
					last_update_login = p_last_update_login
	WHERE rowid = p_rowid;

Line: 74

    END update_row;

Line: 85

	   select * from xtr_rm_md_set_curves
	   where rowid = p_rowid
	   for  update of curve_code NOWAIT;

Line: 97

	   fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 118

    PROCEDURE delete_row(p_rowid IN VARCHAR2) IS

    BEGIN

	DELETE FROM xtr_rm_md_set_curves WHERE rowid = p_rowid;

Line: 128

    END delete_row;