APPS.HZ_HIERARCHY_NODES_PKG dependencies on HZ_HIERARCHY_NODES

Line 1: PACKAGE BODY HZ_HIERARCHY_NODES_PKG AS

1: PACKAGE BODY HZ_HIERARCHY_NODES_PKG AS
2: /*$Header: ARHHINTB.pls 120.5 2011/06/21 06:29:24 rgokavar ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_ROWID OUT NOCOPY ROWID,

Line 25: INSERT INTO HZ_HIERARCHY_NODES (

21: ) IS
22:
23: BEGIN
24:
25: INSERT INTO HZ_HIERARCHY_NODES (
26: HIERARCHY_TYPE,
27: PARENT_ID,
28: PARENT_TABLE_NAME,
29: PARENT_OBJECT_TYPE,

Line 98: UPDATE HZ_HIERARCHY_NODES SET

94: ) IS
95:
96: BEGIN
97:
98: UPDATE HZ_HIERARCHY_NODES SET
99: HIERARCHY_TYPE = DECODE( X_HIERARCHY_TYPE, NULL, HIERARCHY_TYPE, FND_API.G_MISS_NUM, HIERARCHY_TYPE, X_HIERARCHY_TYPE ),
100: PARENT_ID = DECODE( X_PARENT_ID, NULL, PARENT_ID, FND_API.G_MISS_NUM, PARENT_ID, X_PARENT_ID ),
101: PARENT_TABLE_NAME = DECODE( X_PARENT_TABLE_NAME, NULL, PARENT_TABLE_NAME, FND_API.G_MISS_CHAR, PARENT_TABLE_NAME, X_PARENT_TABLE_NAME ),
102: PARENT_OBJECT_TYPE = DECODE( X_PARENT_OBJECT_TYPE, NULL, PARENT_OBJECT_TYPE, FND_API.G_MISS_CHAR, PARENT_OBJECT_TYPE, X_PARENT_OBJECT_TYPE ),

Line 159: FROM HZ_HIERARCHY_NODES

155: X_TOP_PARENT_FLAG,
156: X_LEAF_CHILD_FLAG,
157: X_STATUS,
158: X_RELATIONSHIP_ID
159: FROM HZ_HIERARCHY_NODES
160: WHERE HIERARCHY_TYPE = X_HIERARCHY_TYPE
161: AND PARENT_ID = X_PARENT_ID
162: AND PARENT_TABLE_NAME = X_PARENT_TABLE_NAME
163: AND PARENT_OBJECT_TYPE = X_PARENT_OBJECT_TYPE

Line 179: END HZ_HIERARCHY_NODES_PKG;

175: RAISE FND_API.G_EXC_ERROR;
176:
177: END Select_Row;
178:
179: END HZ_HIERARCHY_NODES_PKG;