APPS.RG_DSS_SEG_RANGE_SETS_PKG dependencies on RG_DSS_SEG_RANGE_SETS

Line 1: PACKAGE BODY RG_DSS_SEG_RANGE_SETS_PKG as

1: PACKAGE BODY RG_DSS_SEG_RANGE_SETS_PKG as
2: /* $Header: rgidrgsb.pls 120.2 2002/11/14 02:58:50 djogg ship $ */
3:
4:
5:

Line 13: FROM rg_dss_seg_range_sets

9: dummy NUMBER;
10: BEGIN
11: SELECT 1
12: INTO dummy
13: FROM rg_dss_seg_range_sets
14: WHERE name = X_Name
15: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
16:
17: -- name already exists for a different range set: ERROR

Line 134: FROM rg_dss_seg_range_sets

130: X_Attribute14 VARCHAR2,
131: X_Attribute15 VARCHAR2) IS
132: CURSOR C IS
133: SELECT rowid
134: FROM rg_dss_seg_range_sets
135: WHERE range_set_id = X_Range_Set_Id;
136:
137: CURSOR C2 IS
138: SELECT rg_dss_seg_range_sets_s.nextval

Line 138: SELECT rg_dss_seg_range_sets_s.nextval

134: FROM rg_dss_seg_range_sets
135: WHERE range_set_id = X_Range_Set_Id;
136:
137: CURSOR C2 IS
138: SELECT rg_dss_seg_range_sets_s.nextval
139: FROM dual;
140:
141: BEGIN
142:

Line 151: INSERT INTO rg_dss_seg_range_sets(

147: FETCH C2 INTO X_Range_Set_Id;
148: CLOSE C2;
149: END IF;
150:
151: INSERT INTO rg_dss_seg_range_sets(
152: range_set_id,
153: name,
154: application_column_name,
155: id_flex_code,

Line 249: FROM rg_dss_seg_range_sets

245: X_Attribute15 VARCHAR2
246: ) IS
247: CURSOR C IS
248: SELECT *
249: FROM rg_dss_seg_range_sets
250: WHERE rowid = X_Rowid
251: FOR UPDATE of range_set_id NOWAIT;
252: Recinfo C%ROWTYPE;
253: BEGIN

Line 367: UPDATE rg_dss_seg_range_sets

363: X_Attribute14 VARCHAR2,
364: X_Attribute15 VARCHAR2) IS
365: BEGIN
366:
367: UPDATE rg_dss_seg_range_sets
368: SET
369: range_set_id = X_Range_Set_Id,
370: name = X_Name,
371: application_column_name = X_Application_Column_Name,

Line 405: DELETE FROM rg_dss_seg_range_sets

401:
402: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
403: BEGIN
404:
405: DELETE FROM rg_dss_seg_range_sets
406: WHERE rowid = X_Rowid;
407:
408: IF (SQL%NOTFOUND) THEN
409: RAISE NO_DATA_FOUND;

Line 415: END RG_DSS_SEG_RANGE_SETS_PKG;

411:
412: END Delete_Row;
413:
414:
415: END RG_DSS_SEG_RANGE_SETS_PKG;