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 115.3 2003/04/15 20:35:48 cvijayan noship $ */
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 96: UPDATE HZ_HIERARCHY_NODES SET

92: ) IS
93:
94: BEGIN
95:
96: UPDATE HZ_HIERARCHY_NODES SET
97: HIERARCHY_TYPE = DECODE( X_HIERARCHY_TYPE, NULL, HIERARCHY_TYPE, FND_API.G_MISS_NUM, HIERARCHY_TYPE, X_HIERARCHY_TYPE ),
98: PARENT_ID = DECODE( X_PARENT_ID, NULL, PARENT_ID, FND_API.G_MISS_NUM, PARENT_ID, X_PARENT_ID ),
99: PARENT_TABLE_NAME = DECODE( X_PARENT_TABLE_NAME, NULL, PARENT_TABLE_NAME, FND_API.G_MISS_CHAR, PARENT_TABLE_NAME, X_PARENT_TABLE_NAME ),
100: 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 157: FROM HZ_HIERARCHY_NODES

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

Line 177: END HZ_HIERARCHY_NODES_PKG;

173: RAISE FND_API.G_EXC_ERROR;
174:
175: END Select_Row;
176:
177: END HZ_HIERARCHY_NODES_PKG;