1 PACKAGE Eng_Change_Route_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGURTES.pls 115.6 2003/10/14 23:09:46 mkimizuk ship $ */
3
4 --
5 -- Constant Variables :
6 --
7
8
9 /********************************************************************
10 * Debug APIs : Open_Debug_Session, Close_Debug_Session,
11 * Write_Debug
12 * Parameters IN :
13 * Parameters OUT:
14 * Purpose : These PROCEDUREs are for test and debug
15 *********************************************************************/
16 -- Open_Debug_Session
17 PROCEDURE Open_Debug_Session
18 ( p_output_dir IN VARCHAR2 := NULL
19 , p_file_name IN VARCHAR2 := NULL
20 );
21
22 -- Close Debug_Session
23 PROCEDURE Close_Debug_Session ;
24
25 -- Write Debug Message
26 PROCEDURE Write_Debug
27 ( p_debug_message IN VARCHAR2 ) ;
28
29
30 /********************************************************************
31 * API Type : Refresh Route API
32 * Scope : Oracle (for Oracle Applications development use only)
33 * Purpose : This api will create another instance of Route specified
34 * as param and set original Route as History
35 *********************************************************************/
36 PROCEDURE REFRESH_ROUTE(
37 X_NEW_ROUTE_ID OUT NOCOPY NUMBER,
38 P_ROUTE_ID IN NUMBER,
39 P_USER_ID IN NUMBER := NULL ,
40 P_API_CALLER IN VARCHAR2 := NULL
41 ) ;
42
43 /********************************************************************
44 * API Type : Private APIs
45 * Purpose : Those APIs are private
46 *********************************************************************/
47 PROCEDURE COPY_ROUTE (
48 X_TO_ROUTE_ID IN OUT NOCOPY NUMBER ,
49 P_FROM_ROUTE_ID IN NUMBER ,
50 P_USER_ID IN NUMBER := NULL ,
51 P_API_CALLER IN VARCHAR2 := NULL
52 ) ;
53
54
55
56 /********************************************************************
57 * API Type : Private Table Hander APIs
58 * Purpose : Those APIs are private
59 * Table Hander for TL Entity Object: ENG_CHANGE_ROUTES_VL
60 * PROCEDURE INSERT_ROW;
61 * PROCEDURE LOCK_ROW;
62 * PROCEDURE UPDATE_ROW;
63 * PROCEDURE DELETE_ROW;
64 *********************************************************************/
65 PROCEDURE INSERT_ROW (
66 X_ROWID IN OUT NOCOPY VARCHAR2,
67 X_ROUTE_ID IN NUMBER,
68 X_ROUTE_NAME IN VARCHAR2,
69 X_ROUTE_DESCRIPTION IN VARCHAR2,
70 X_TEMPLATE_FLAG IN VARCHAR2,
71 X_OWNER_ID IN NUMBER,
72 X_FIXED_FLAG IN VARCHAR2,
73 X_OBJECT_NAME IN VARCHAR2,
74 X_OBJECT_ID1 IN NUMBER,
75 X_OBJECT_ID2 IN NUMBER,
76 X_OBJECT_ID3 IN NUMBER,
77 X_OBJECT_ID4 IN NUMBER,
78 X_OBJECT_ID5 IN NUMBER,
79 X_APPLIED_TEMPLATE_ID IN NUMBER,
80 X_WF_ITEM_TYPE IN VARCHAR2,
81 X_WF_ITEM_KEY IN VARCHAR2,
82 X_WF_PROCESS_NAME IN VARCHAR2,
83 X_STATUS_CODE IN VARCHAR2,
84 X_ROUTE_START_DATE IN DATE,
85 X_ROUTE_END_DATE IN DATE,
86 X_CHANGE_REVISION IN VARCHAR2,
87 X_CREATION_DATE IN DATE,
88 X_CREATED_BY IN NUMBER,
89 X_LAST_UPDATE_DATE IN DATE,
90 X_LAST_UPDATED_BY IN NUMBER,
91 X_LAST_UPDATE_LOGIN IN NUMBER,
92 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
93 X_ATTRIBUTE1 IN VARCHAR2,
94 X_ATTRIBUTE2 IN VARCHAR2,
95 X_ATTRIBUTE3 IN VARCHAR2,
96 X_ATTRIBUTE4 IN VARCHAR2,
97 X_ATTRIBUTE5 IN VARCHAR2,
98 X_ATTRIBUTE6 IN VARCHAR2,
99 X_ATTRIBUTE7 IN VARCHAR2,
100 X_ATTRIBUTE8 IN VARCHAR2,
101 X_ATTRIBUTE9 IN VARCHAR2,
102 X_ATTRIBUTE10 IN VARCHAR2,
103 X_ATTRIBUTE11 IN VARCHAR2,
104 X_ATTRIBUTE12 IN VARCHAR2,
105 X_ATTRIBUTE13 IN VARCHAR2,
106 X_ATTRIBUTE14 IN VARCHAR2,
107 X_ATTRIBUTE15 IN VARCHAR2,
108 X_REQUEST_ID IN NUMBER,
109 X_PROGRAM_ID IN NUMBER,
110 X_PROGRAM_APPLICATION_ID IN NUMBER,
111 X_PROGRAM_UPDATE_DATE IN DATE,
112 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
113 X_CLASSIFICATION_CODE IN VARCHAR2,
114 X_ROUTE_TYPE_CODE IN VARCHAR2
115 );
116
117 PROCEDURE LOCK_ROW (
118 X_ROUTE_ID IN NUMBER,
119 X_ROUTE_NAME IN VARCHAR2,
120 X_ROUTE_DESCRIPTION IN VARCHAR2,
121 X_TEMPLATE_FLAG IN VARCHAR2,
122 X_OWNER_ID IN NUMBER,
123 X_FIXED_FLAG IN VARCHAR2,
124 X_OBJECT_NAME IN VARCHAR2,
125 X_OBJECT_ID1 IN NUMBER,
126 X_OBJECT_ID2 IN NUMBER,
127 X_OBJECT_ID3 IN NUMBER,
128 X_OBJECT_ID4 IN NUMBER,
129 X_OBJECT_ID5 IN NUMBER,
130 X_APPLIED_TEMPLATE_ID IN NUMBER,
131 X_WF_ITEM_TYPE IN VARCHAR2,
132 X_WF_ITEM_KEY IN VARCHAR2,
133 X_WF_PROCESS_NAME IN VARCHAR2,
134 X_STATUS_CODE IN VARCHAR2,
135 X_ROUTE_START_DATE IN DATE,
136 X_ROUTE_END_DATE IN DATE,
137 X_CHANGE_REVISION IN VARCHAR2,
138 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
139 X_ATTRIBUTE1 IN VARCHAR2,
140 X_ATTRIBUTE2 IN VARCHAR2,
141 X_ATTRIBUTE3 IN VARCHAR2,
142 X_ATTRIBUTE4 IN VARCHAR2,
143 X_ATTRIBUTE5 IN VARCHAR2,
144 X_ATTRIBUTE6 IN VARCHAR2,
145 X_ATTRIBUTE7 IN VARCHAR2,
146 X_ATTRIBUTE8 IN VARCHAR2,
147 X_ATTRIBUTE9 IN VARCHAR2,
148 X_ATTRIBUTE10 IN VARCHAR2,
149 X_ATTRIBUTE11 IN VARCHAR2,
150 X_ATTRIBUTE12 IN VARCHAR2,
151 X_ATTRIBUTE13 IN VARCHAR2,
152 X_ATTRIBUTE14 IN VARCHAR2,
153 X_ATTRIBUTE15 IN VARCHAR2,
154 X_REQUEST_ID IN NUMBER,
155 X_PROGRAM_ID IN NUMBER,
156 X_PROGRAM_APPLICATION_ID IN NUMBER,
157 X_PROGRAM_UPDATE_DATE IN DATE,
158 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
159 X_CLASSIFICATION_CODE IN VARCHAR2,
160 X_ROUTE_TYPE_CODE IN VARCHAR2
161 ) ;
162
163
164 PROCEDURE UPDATE_ROW (
165 X_ROUTE_ID IN NUMBER,
166 X_ROUTE_NAME IN VARCHAR2,
167 X_ROUTE_DESCRIPTION IN VARCHAR2,
168 X_TEMPLATE_FLAG IN VARCHAR2,
169 X_OWNER_ID IN NUMBER,
170 X_FIXED_FLAG IN VARCHAR2,
171 X_OBJECT_NAME IN VARCHAR2,
172 X_OBJECT_ID1 IN NUMBER,
173 X_OBJECT_ID2 IN NUMBER,
174 X_OBJECT_ID3 IN NUMBER,
175 X_OBJECT_ID4 IN NUMBER,
176 X_OBJECT_ID5 IN NUMBER,
177 X_APPLIED_TEMPLATE_ID IN NUMBER,
178 X_WF_ITEM_TYPE IN VARCHAR2,
179 X_WF_ITEM_KEY IN VARCHAR2,
180 X_WF_PROCESS_NAME IN VARCHAR2,
181 X_STATUS_CODE IN VARCHAR2,
182 X_ROUTE_START_DATE IN DATE,
183 X_ROUTE_END_DATE IN DATE,
184 X_CHANGE_REVISION IN VARCHAR2,
185 X_LAST_UPDATE_DATE IN DATE,
186 X_LAST_UPDATED_BY IN NUMBER,
187 X_LAST_UPDATE_LOGIN IN NUMBER,
188 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
189 X_ATTRIBUTE1 IN VARCHAR2,
190 X_ATTRIBUTE2 IN VARCHAR2,
191 X_ATTRIBUTE3 IN VARCHAR2,
192 X_ATTRIBUTE4 IN VARCHAR2,
193 X_ATTRIBUTE5 IN VARCHAR2,
194 X_ATTRIBUTE6 IN VARCHAR2,
195 X_ATTRIBUTE7 IN VARCHAR2,
196 X_ATTRIBUTE8 IN VARCHAR2,
197 X_ATTRIBUTE9 IN VARCHAR2,
198 X_ATTRIBUTE10 IN VARCHAR2,
199 X_ATTRIBUTE11 IN VARCHAR2,
200 X_ATTRIBUTE12 IN VARCHAR2,
201 X_ATTRIBUTE13 IN VARCHAR2,
202 X_ATTRIBUTE14 IN VARCHAR2,
203 X_ATTRIBUTE15 IN VARCHAR2,
204 X_REQUEST_ID IN NUMBER,
205 X_PROGRAM_ID IN NUMBER,
206 X_PROGRAM_APPLICATION_ID IN NUMBER,
207 X_PROGRAM_UPDATE_DATE IN DATE,
208 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
209 X_CLASSIFICATION_CODE IN VARCHAR2,
210 X_ROUTE_TYPE_CODE IN VARCHAR2
211 ) ;
212
213 PROCEDURE DELETE_ROW (
214 X_ROUTE_ID IN NUMBER
215 );
216
217 PROCEDURE ADD_LANGUAGE;
218
219 PROCEDURE CLOSE_LOB(lob_loc IN OUT NOCOPY CLOB) ;
220
221 PROCEDURE CREATE_INSTANCE_SET_SQL
222 (
223 p_Object_Values IN VARCHAR2,
224 x_User_Group_Flag IN VARCHAR2,
225 x_Complete_query OUT NOCOPY CLOB
226 );
227
228
229
230 /********************************************************************
231 * API Type : Public APIs
232 * Purpose : APIS to create Instance set query
233 *********************************************************************/
234
235
236
237
238
239 END Eng_Change_Route_Util ;