1 PACKAGE HZ_HIERARCHY_NODES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHHINTS.pls 115.2 2003/02/01 03:18:34 srangara noship $ */
3
4 PROCEDURE Insert_Row (
5 X_ROWID OUT NOCOPY ROWID,
6 X_HIERARCHY_TYPE IN VARCHAR2,
7 X_PARENT_ID IN NUMBER,
8 X_PARENT_TABLE_NAME IN VARCHAR2,
9 X_PARENT_OBJECT_TYPE IN VARCHAR2,
10 X_CHILD_ID IN NUMBER,
11 X_CHILD_TABLE_NAME IN VARCHAR2,
12 X_CHILD_OBJECT_TYPE IN VARCHAR2,
13 X_LEVEL_NUMBER IN NUMBER,
14 X_TOP_PARENT_FLAG IN VARCHAR2,
15 X_LEAF_CHILD_FLAG IN VARCHAR2,
16 X_EFFECTIVE_START_DATE IN DATE,
17 X_EFFECTIVE_END_DATE IN DATE,
18 X_STATUS IN VARCHAR2,
19 X_RELATIONSHIP_ID IN NUMBER,
20 X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
21 );
22
23 PROCEDURE Update_Row (
24 X_Rowid IN OUT NOCOPY VARCHAR2,
25 X_HIERARCHY_TYPE IN VARCHAR2,
26 X_PARENT_ID IN NUMBER,
27 X_PARENT_TABLE_NAME IN VARCHAR2,
28 X_PARENT_OBJECT_TYPE IN VARCHAR2,
29 X_CHILD_ID IN NUMBER,
30 X_CHILD_TABLE_NAME IN VARCHAR2,
31 X_CHILD_OBJECT_TYPE IN VARCHAR2,
32 X_LEVEL_NUMBER IN NUMBER,
33 X_TOP_PARENT_FLAG IN VARCHAR2,
34 X_LEAF_CHILD_FLAG IN VARCHAR2,
35 X_EFFECTIVE_START_DATE IN DATE,
36 X_EFFECTIVE_END_DATE IN DATE,
37 X_STATUS IN VARCHAR2,
38 X_RELATIONSHIP_ID IN NUMBER,
39 X_ACTUAL_CONTENT_SOURCE IN VARCHAR2
40 );
41
42 PROCEDURE Select_Row (
43 X_HIERARCHY_TYPE IN VARCHAR2,
44 X_PARENT_ID IN NUMBER,
45 X_PARENT_TABLE_NAME IN VARCHAR2,
46 X_PARENT_OBJECT_TYPE IN VARCHAR2,
47 X_CHILD_ID IN NUMBER,
48 X_CHILD_TABLE_NAME IN VARCHAR2,
49 X_CHILD_OBJECT_TYPE IN VARCHAR2,
50 X_EFFECTIVE_START_DATE IN DATE,
51 X_EFFECTIVE_END_DATE IN DATE,
52 X_LEVEL_NUMBER OUT NOCOPY NUMBER,
53 X_TOP_PARENT_FLAG OUT NOCOPY VARCHAR2,
54 X_LEAF_CHILD_FLAG OUT NOCOPY VARCHAR2,
55 X_STATUS OUT NOCOPY VARCHAR2,
56 X_RELATIONSHIP_ID OUT NOCOPY NUMBER
57 );
58
59 END HZ_HIERARCHY_NODES_PKG;