APPS.RG_DSS_HIERARCHY_DETAILS_PKG dependencies on RG_DSS_HIERARCHY_DETAILS

Line 1: PACKAGE BODY RG_DSS_HIERARCHY_DETAILS_PKG as

1: PACKAGE BODY RG_DSS_HIERARCHY_DETAILS_PKG as
2: /* $Header: rgidhrdb.pls 120.2 2002/11/14 02:58:38 djogg ship $ */
3:
4:
5:

Line 15: FROM rg_dss_hierarchy_details

11: dummy NUMBER;
12: BEGIN
13: SELECT 1
14: INTO dummy
15: FROM rg_dss_hierarchy_details
16: WHERE sequence = X_Sequence
17: AND hierarchy_id = X_Hierarchy_Id
18: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
19:

Line 40: FROM rg_dss_hierarchy_details

36: dummy NUMBER;
37: BEGIN
38: SELECT 1
39: INTO dummy
40: FROM rg_dss_hierarchy_details
41: WHERE application_column_name = X_Application_Column_Name
42: AND hierarchy_id = X_Hierarchy_Id
43: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
44:

Line 87: FROM rg_dss_hierarchy_details

83: X_Attribute14 VARCHAR2,
84: X_Attribute15 VARCHAR2) IS
85: CURSOR C IS
86: SELECT rowid
87: FROM rg_dss_hierarchy_details
88: WHERE sequence = X_Sequence
89: AND hierarchy_id = X_Hierarchy_Id;
90:
91: num_details NUMBER;

Line 113: INSERT INTO rg_dss_hierarchy_details(

109: END IF;
110:
111: check_unique_sequence(X_Rowid, X_Hierarchy_Id, X_Sequence);
112: check_unique_segment(X_Rowid, X_Hierarchy_Id, X_Application_Column_Name);
113: INSERT INTO rg_dss_hierarchy_details(
114: hierarchy_id,
115: sequence,
116: application_column_name,
117: root_node,

Line 204: FROM rg_dss_hierarchy_details

200: X_Attribute15 VARCHAR2
201: ) IS
202: CURSOR C IS
203: SELECT *
204: FROM rg_dss_hierarchy_details
205: WHERE rowid = X_Rowid
206: FOR UPDATE of sequence NOWAIT;
207: Recinfo C%ROWTYPE;
208: BEGIN

Line 321: UPDATE rg_dss_hierarchy_details

317: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
318: APP_EXCEPTION.raise_exception;
319: END IF;
320:
321: UPDATE rg_dss_hierarchy_details
322: SET
323: hierarchy_id = X_Hierarchy_Id,
324: sequence = X_Sequence,
325: application_column_name = X_Application_Column_Name,

Line 363: DELETE FROM rg_dss_hierarchy_details

359: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_HIERARCHY', TRUE);
360: APP_EXCEPTION.raise_exception;
361: END IF;
362:
363: DELETE FROM rg_dss_hierarchy_details
364: WHERE rowid = X_Rowid;
365:
366: IF (SQL%NOTFOUND) THEN
367: RAISE NO_DATA_FOUND;

Line 373: END RG_DSS_HIERARCHY_DETAILS_PKG;

369:
370: END Delete_Row;
371:
372:
373: END RG_DSS_HIERARCHY_DETAILS_PKG;