1 PACKAGE Ibc_Directory_Nodes_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctdnds.pls 120.1 2005/07/12 01:48:37 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Directory_Nodes table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- vicho 11/04/2002 Remove G_MISS defaulting on UPDATE_ROW
11 -- Edward Nunez New columns NODE_STATUS and DIRECTORY_PATH,
12 -- overloaded methods for BC4J compliance.
13 -- Edward Nunez New columns AVAILABLE_DATE, EXPIRATION_DATE
14 -- and HIDDEN_FLAG
15 -- Kiran 09/02/2003 Added new procedure(INSERT_ROW_CP) to call from Java CP
16 -- Sharma 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
17 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
18
19 PROCEDURE INSERT_ROW (
20 x_ROWID OUT NOCOPY VARCHAR2,
21 px_DIRECTORY_NODE_ID IN OUT NOCOPY NUMBER,
22 p_DIRECTORY_NODE_CODE IN VARCHAR2,
23 p_NODE_STATUS IN VARCHAR2,
24 p_DIRECTORY_PATH IN VARCHAR2,
25 p_AVAILABLE_DATE IN DATE,
26 p_EXPIRATION_DATE IN DATE,
27 p_HIDDEN_FLAG IN VARCHAR2,
28 p_NODE_TYPE IN VARCHAR2,
29 p_OBJECT_VERSION_NUMBER IN NUMBER,
30 p_DIRECTORY_NODE_NAME IN VARCHAR2,
31 p_DESCRIPTION IN VARCHAR2,
32 p_CREATION_DATE IN DATE DEFAULT NULL,
33 p_CREATED_BY IN NUMBER DEFAULT NULL,
34 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
35 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
36 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
37 );
38
39 PROCEDURE INSERT_ROW (
40 x_ROWID OUT NOCOPY VARCHAR2,
41 x_DIRECTORY_NODE_ID IN OUT NOCOPY NUMBER,
42 x_DIRECTORY_NODE_CODE IN VARCHAR2,
43 x_NODE_STATUS IN VARCHAR2,
44 x_DIRECTORY_PATH IN VARCHAR2,
45 x_AVAILABLE_DATE IN DATE,
46 x_EXPIRATION_DATE IN DATE,
47 x_HIDDEN_FLAG IN VARCHAR2,
48 x_NODE_TYPE IN VARCHAR2,
49 x_OBJECT_VERSION_NUMBER IN NUMBER,
50 x_DIRECTORY_NODE_NAME IN VARCHAR2,
51 x_DESCRIPTION IN VARCHAR2,
52 x_CREATION_DATE IN DATE DEFAULT NULL,
53 x_CREATED_BY IN NUMBER DEFAULT NULL,
54 x_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
55 x_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
56 x_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
57 );
58
59 PROCEDURE INSERT_ROW_CP (
60 x_ROWID OUT NOCOPY VARCHAR2,
61 x_DIRECTORY_NODE_ID IN OUT NOCOPY NUMBER,
62 x_DIRECTORY_NODE_CODE IN VARCHAR2,
63 x_NODE_STATUS IN VARCHAR2,
64 x_DIRECTORY_PATH IN VARCHAR2,
65 x_AVAILABLE_DATE IN DATE,
66 x_EXPIRATION_DATE IN DATE,
67 x_HIDDEN_FLAG IN VARCHAR2,
68 x_NODE_TYPE IN VARCHAR2,
69 x_OBJECT_VERSION_NUMBER IN NUMBER,
70 x_DIRECTORY_NODE_NAME IN VARCHAR2,
71 x_DESCRIPTION IN VARCHAR2,
72 x_CREATION_DATE IN DATE DEFAULT NULL,
73 x_CREATED_BY IN NUMBER DEFAULT NULL,
74 x_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
75 x_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
76 x_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
77 );
78
79 PROCEDURE LOCK_ROW (
80 p_DIRECTORY_NODE_ID IN NUMBER,
81 p_DIRECTORY_NODE_CODE IN VARCHAR2,
82 p_NODE_TYPE IN VARCHAR2,
83 p_NODE_STATUS IN VARCHAR2,
84 p_DIRECTORY_PATH IN VARCHAR2,
85 p_AVAILABLE_DATE IN DATE,
86 p_EXPIRATION_DATE IN DATE,
87 p_HIDDEN_FLAG IN VARCHAR2,
88 p_OBJECT_VERSION_NUMBER IN NUMBER,
89 p_DIRECTORY_NODE_NAME IN VARCHAR2,
90 p_DESCRIPTION IN VARCHAR2
91 );
92
93 PROCEDURE LOCK_ROW (
94 x_DIRECTORY_NODE_ID IN NUMBER,
95 x_DIRECTORY_NODE_CODE IN VARCHAR2,
96 x_NODE_TYPE IN VARCHAR2,
97 x_NODE_STATUS IN VARCHAR2,
98 x_DIRECTORY_PATH IN VARCHAR2,
99 x_AVAILABLE_DATE IN DATE,
100 x_EXPIRATION_DATE IN DATE,
101 x_HIDDEN_FLAG IN VARCHAR2,
102 x_OBJECT_VERSION_NUMBER IN NUMBER,
103 x_DIRECTORY_NODE_NAME IN VARCHAR2,
104 x_DESCRIPTION IN VARCHAR2
105 );
106
107 PROCEDURE UPDATE_ROW (
108 p_DIRECTORY_NODE_ID IN NUMBER,
109 p_DIRECTORY_NODE_CODE IN VARCHAR2,
110 p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
111 p_DIRECTORY_NODE_NAME IN VARCHAR2 DEFAULT NULL,
112 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
113 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
114 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
115 p_NODE_STATUS IN VARCHAR2 DEFAULT NULL,
116 p_DIRECTORY_PATH IN VARCHAR2 DEFAULT NULL,
117 p_AVAILABLE_DATE IN DATE DEFAULT NULL,
118 p_EXPIRATION_DATE IN DATE DEFAULT NULL,
119 p_HIDDEN_FLAG IN VARCHAR2 DEFAULT NULL,
120 p_NODE_TYPE IN VARCHAR2 DEFAULT NULL,
121 p_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
122 );
123
124 PROCEDURE UPDATE_ROW (
125 x_DIRECTORY_NODE_ID IN NUMBER,
126 x_DIRECTORY_NODE_CODE IN VARCHAR2,
127 x_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
128 x_DIRECTORY_NODE_NAME IN VARCHAR2 DEFAULT NULL,
129 x_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
130 x_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
131 x_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
132 x_NODE_STATUS IN VARCHAR2 DEFAULT NULL,
133 x_DIRECTORY_PATH IN VARCHAR2 DEFAULT NULL,
134 x_AVAILABLE_DATE IN DATE DEFAULT NULL,
135 x_EXPIRATION_DATE IN DATE DEFAULT NULL,
136 x_HIDDEN_FLAG IN VARCHAR2 DEFAULT NULL,
137 x_NODE_TYPE IN VARCHAR2 DEFAULT NULL,
138 x_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
139 );
140
141 PROCEDURE DELETE_ROW (
142 p_DIRECTORY_NODE_ID IN NUMBER
143 );
144
145 PROCEDURE DELETE_ROW (
146 x_DIRECTORY_NODE_ID IN NUMBER
147 );
148
149 PROCEDURE ADD_LANGUAGE;
150
151 PROCEDURE TRANSLATE_ROW (
152 p_UPLOAD_MODE IN VARCHAR2,
153 p_DIRECTORY_NODE_ID IN NUMBER,
154 p_DIRECTORY_NODE_NAME IN VARCHAR2,
155 p_DESCRIPTION IN VARCHAR2,
156 p_OWNER IN VARCHAR2,
157 p_LAST_UPDATE_DATE IN VARCHAR2);
158
159 PROCEDURE LOAD_ROW (
160 p_UPLOAD_MODE IN VARCHAR2,
161 p_DIRECTORY_NODE_ID IN NUMBER,
162 p_NODE_TYPE IN VARCHAR2,
163 p_NODE_STATUS IN VARCHAR2,
164 p_DIRECTORY_PATH IN VARCHAR2,
165 p_AVAILABLE_DATE IN DATE,
166 p_EXPIRATION_DATE IN DATE,
167 p_HIDDEN_FLAG IN VARCHAR2,
168 p_DIRECTORY_NODE_CODE IN VARCHAR2,
169 p_DIRECTORY_NODE_NAME IN VARCHAR2,
170 p_DESCRIPTION IN VARCHAR2,
171 p_OWNER IN VARCHAR2,
172 p_LAST_UPDATE_DATE IN VARCHAR2);
173
174 PROCEDURE LOAD_SEED_ROW (
175 p_UPLOAD_MODE IN VARCHAR2,
176 p_DIRECTORY_NODE_ID IN NUMBER,
177 p_NODE_TYPE IN VARCHAR2,
178 p_NODE_STATUS IN VARCHAR2,
179 p_DIRECTORY_PATH IN VARCHAR2,
180 p_AVAILABLE_DATE IN DATE,
181 p_EXPIRATION_DATE IN DATE,
182 p_HIDDEN_FLAG IN VARCHAR2,
183 p_DIRECTORY_NODE_CODE IN VARCHAR2,
184 p_DIRECTORY_NODE_NAME IN VARCHAR2,
185 p_DESCRIPTION IN VARCHAR2,
186 p_OWNER IN VARCHAR2,
187 p_LAST_UPDATE_DATE IN VARCHAR2);
188
189
190 END Ibc_Directory_Nodes_Pkg;