APPS.XTR_RM_MD_SETS_PKG dependencies on XTR_RM_MD_SETS

Line 1: PACKAGE BODY XTR_RM_MD_SETS_PKG as

1: PACKAGE BODY XTR_RM_MD_SETS_PKG as
2: /* $Header: xtrmdstb.pls 120.3 2005/06/29 10:44:33 badiredd ship $ */
3:
4: PROCEDURE insert_row(p_rowid IN OUT NOCOPY VARCHAR2,
5: p_set_code IN VARCHAR2,

Line 33: CURSOR C IS select rowid from xtr_rm_md_sets

29: p_last_updated_by IN NUMBER,
30: p_last_update_date IN DATE,
31: p_last_update_login IN NUMBER) IS
32:
33: CURSOR C IS select rowid from xtr_rm_md_sets
34: where set_code = p_set_code;
35:
36: BEGIN
37:

Line 38: INSERT INTO xtr_rm_md_sets(set_code,

34: where set_code = p_set_code;
35:
36: BEGIN
37:
38: INSERT INTO xtr_rm_md_sets(set_code,
39: description,
40: authorized_yn,
41: fx_spot_side,
42: bond_price_side,

Line 133: UPDATE xtr_rm_md_sets SET set_code = p_set_code,

129: p_last_update_login IN NUMBER) IS
130:
131: BEGIN
132:
133: UPDATE xtr_rm_md_sets SET set_code = p_set_code,
134: description = p_description,
135: authorized_yn = p_authorized,
136: fx_spot_side = p_fx_spot_side,
137: bond_price_side = p_bond_price_side,

Line 176: select * from xtr_rm_md_sets

172: p_fx_spot_side IN VARCHAR2,
173: p_bond_price_side IN VARCHAR2) IS
174:
175: CURSOR C IS
176: select * from xtr_rm_md_sets
177: where rowid = p_rowid
178: for update of set_code NOWAIT;
179: recinfo C%ROWTYPE;
180:

Line 216: DELETE FROM xtr_rm_md_sets WHERE rowid = p_rowid;

212: PROCEDURE delete_row(p_rowid IN VARCHAR2) IS
213:
214: BEGIN
215:
216: DELETE FROM xtr_rm_md_sets WHERE rowid = p_rowid;
217:
218: IF (SQL%NOTFOUND) THEN
219: Raise NO_DATA_FOUND;
220: END IF;

Line 225: END XTR_RM_MD_SETS_PKG;

221:
222: END delete_row;
223:
224:
225: END XTR_RM_MD_SETS_PKG;
226: