APPS.RG_DSS_HIERARCHIES_PKG dependencies on RG_DSS_HIERARCHIES

Line 1: PACKAGE BODY RG_DSS_HIERARCHIES_PKG as

1: PACKAGE BODY RG_DSS_HIERARCHIES_PKG as
2: /* $Header: rgidhrcb.pls 120.2 2002/11/14 02:58:24 djogg ship $ */
3:
4:
5:

Line 11: SELECT rg_dss_hierarchies_s.nextval

7:
8: FUNCTION get_new_id RETURN NUMBER IS
9: next_hierarchy_id NUMBER;
10: BEGIN
11: SELECT rg_dss_hierarchies_s.nextval
12: INTO next_hierarchy_id
13: FROM dual;
14:
15: RETURN (next_hierarchy_id);

Line 27: FROM rg_dss_hierarchies

23: INTO dummy
24: FROM dual
25: WHERE NOT EXISTS
26: (SELECT 1
27: FROM rg_dss_hierarchies
28: WHERE hierarchy_id = X_Hierarchy_Id
29: AND RG_DSS_DIMENSIONS_PKG.used_in_frozen_system(dimension_id) = 1);
30: RETURN(FALSE);
31: EXCEPTION

Line 42: FROM rg_dss_hierarchies

38: dummy NUMBER;
39: BEGIN
40: SELECT 1
41: INTO dummy
42: FROM rg_dss_hierarchies
43: WHERE name = X_Name
44: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
45:
46: -- name already exists for a different hierarchy: ERROR

Line 158: FROM rg_dss_hierarchies

154: num_detail_rows NUMBER;
155:
156: CURSOR C IS
157: SELECT rowid
158: FROM rg_dss_hierarchies
159: WHERE hierarchy_id = X_Hierarchy_Id;
160: BEGIN
161:
162: check_unique_name(X_Rowid, X_Name);

Line 180: INSERT INTO rg_dss_hierarchies(

176: FND_MESSAGE.set_name('RG','RG_DSS_HIR_ROOT_NODE');
177: APP_EXCEPTION.raise_exception;
178: END IF;
179:
180: INSERT INTO rg_dss_hierarchies(
181: hierarchy_id,
182: name,
183: id_flex_code,
184: id_flex_num,

Line 278: FROM rg_dss_hierarchies

274: X_Attribute15 VARCHAR2
275: ) IS
276: CURSOR C IS
277: SELECT *
278: FROM rg_dss_hierarchies
279: WHERE rowid = X_Rowid
280: FOR UPDATE of hierarchy_id NOWAIT;
281: Recinfo C%ROWTYPE;
282: BEGIN

Line 417: UPDATE rg_dss_hierarchies

413: FND_MESSAGE.set_name('RG','RG_DSS_HIR_ROOT_NODE');
414: APP_EXCEPTION.raise_exception;
415: END IF;
416:
417: UPDATE rg_dss_hierarchies
418: SET
419: hierarchy_id = X_Hierarchy_Id,
420: name = X_Name,
421: id_flex_code = X_Id_Flex_Code,

Line 462: DELETE FROM rg_dss_hierarchies

458: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
459: APP_EXCEPTION.raise_exception;
460: END IF;
461:
462: DELETE FROM rg_dss_hierarchies
463: WHERE rowid = X_Rowid;
464:
465: IF (SQL%NOTFOUND) THEN
466: RAISE NO_DATA_FOUND;

Line 472: END RG_DSS_HIERARCHIES_PKG;

468:
469: END Delete_Row;
470:
471:
472: END RG_DSS_HIERARCHIES_PKG;