APPS.XTR_RM_MD_SET_CURVES_PKG dependencies on XTR_RM_MD_SET_CURVES

Line 1: PACKAGE BODY XTR_RM_MD_SET_CURVES_PKG as

1: PACKAGE BODY XTR_RM_MD_SET_CURVES_PKG as
2: /* $Header: xtrmdscb.pls 120.1 2005/06/29 10:47:52 csutaria ship $ */
3:
4: PROCEDURE insert_row(p_rowid IN OUT NOCOPY VARCHAR2,
5: p_curve_code IN VARCHAR2,

Line 15: CURSOR C IS select rowid from xtr_rm_md_set_curves

11: p_last_updated_by IN NUMBER,
12: p_last_update_date IN DATE,
13: p_last_update_login IN NUMBER) IS
14:
15: CURSOR C IS select rowid from xtr_rm_md_set_curves
16: where set_code = p_set_code and curve_code = p_curve_code;
17:
18: BEGIN
19:

Line 20: INSERT INTO xtr_rm_md_set_curves(curve_code,

16: where set_code = p_set_code and curve_code = p_curve_code;
17:
18: BEGIN
19:
20: INSERT INTO xtr_rm_md_set_curves(curve_code,
21: data_side,
22: interpolation,
23: set_code,
24: created_by,

Line 61: UPDATE xtr_rm_md_set_curves SET set_code = p_set_code,

57:
58:
59: BEGIN
60:
61: UPDATE xtr_rm_md_set_curves SET set_code = p_set_code,
62: curve_code = p_curve_code,
63: data_side = p_data_side,
64: interpolation = p_interpolation,
65: last_updated_by = p_last_updated_by,

Line 85: select * from xtr_rm_md_set_curves

81: p_interpolation IN VARCHAR2,
82: p_set_code IN VARCHAR2) IS
83:
84: CURSOR C IS
85: select * from xtr_rm_md_set_curves
86: where rowid = p_rowid
87: for update of curve_code NOWAIT;
88: recinfo C%ROWTYPE;
89:

Line 122: DELETE FROM xtr_rm_md_set_curves WHERE rowid = p_rowid;

118: PROCEDURE delete_row(p_rowid IN VARCHAR2) IS
119:
120: BEGIN
121:
122: DELETE FROM xtr_rm_md_set_curves WHERE rowid = p_rowid;
123:
124: IF (SQL%NOTFOUND) THEN
125: Raise NO_DATA_FOUND;
126: END IF;

Line 130: END XTR_RM_MD_SET_CURVES_PKG;

126: END IF;
127:
128: END delete_row;
129:
130: END XTR_RM_MD_SET_CURVES_PKG;
131: