1 PACKAGE Eng_Change_Route_Step_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGUSTPS.pls 115.3 2003/09/30 01:12:48 mkimizuk ship $ */
3
4 --
5 -- Constant Variables :
6 --
7 -- Here
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 /********************************************************************
32 * API Type : Private Copy Steps APIs
33 * Purpose : Those APIs are private to Copy Steps
34 *********************************************************************/
35 PROCEDURE COPY_STEPS (
36 P_FROM_ROUTE_ID IN NUMBER ,
37 P_TO_ROUTE_ID IN NUMBER ,
38 P_USER_ID IN NUMBER := NULL ,
39 P_API_CALLER IN VARCHAR2 := NULL
40 ) ;
41
42
43
44 /********************************************************************
45 * API Type : Private Table Hander APIs
46 * Purpose : Those APIs are private
47 * Table Hander for TL Entity Object:
48 * ENG_CHANGE_ROUTE_STEPS_VL
49 * PROCEDURE INSERT_ROW;
50 * PROCEDURE LOCK_ROW;
51 * PROCEDURE UPDATE_ROW;
52 * PROCEDURE DELETE_ROW;
53 *********************************************************************/
54 procedure INSERT_ROW (
55 X_ROWID IN OUT NOCOPY VARCHAR2,
56 X_STEP_ID IN NUMBER,
57 X_ROUTE_ID IN NUMBER,
58 X_STEP_SEQ_NUM IN NUMBER,
59 X_ADHOC_STEP_FLAG IN VARCHAR2,
60 X_WF_ITEM_TYPE IN VARCHAR2,
61 X_WF_ITEM_KEY IN VARCHAR2,
62 X_WF_PROCESS_NAME IN VARCHAR2,
63 X_CONDITION_TYPE_CODE IN VARCHAR2,
64 X_TIMEOUT_OPTION IN VARCHAR2,
65 X_STEP_STATUS_CODE IN VARCHAR2,
66 X_STEP_START_DATE IN DATE,
67 X_STEP_END_DATE IN DATE,
68 X_REQUIRED_RELATIVE_DAYS IN NUMBER,
69 X_REQUIRED_DATE IN DATE,
70 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
71 X_ATTRIBUTE1 IN VARCHAR2,
72 X_ATTRIBUTE2 IN VARCHAR2,
73 X_ATTRIBUTE3 IN VARCHAR2,
74 X_ATTRIBUTE4 IN VARCHAR2,
75 X_ATTRIBUTE5 IN VARCHAR2,
76 X_ATTRIBUTE6 IN VARCHAR2,
77 X_ATTRIBUTE7 IN VARCHAR2,
78 X_ATTRIBUTE8 IN VARCHAR2,
79 X_ATTRIBUTE9 IN VARCHAR2,
80 X_ATTRIBUTE10 IN VARCHAR2,
81 X_ATTRIBUTE11 IN VARCHAR2,
82 X_ATTRIBUTE12 IN VARCHAR2,
83 X_ATTRIBUTE13 IN VARCHAR2,
84 X_ATTRIBUTE14 IN VARCHAR2,
85 X_ATTRIBUTE15 IN VARCHAR2,
86 X_REQUEST_ID IN NUMBER,
87 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
88 X_INSTRUCTION IN VARCHAR2,
89 X_CREATION_DATE IN DATE,
90 X_CREATED_BY IN NUMBER,
91 X_LAST_UPDATE_DATE IN DATE,
92 X_LAST_UPDATED_BY IN NUMBER,
93 X_LAST_UPDATE_LOGIN IN NUMBER,
94 X_PROGRAM_ID IN NUMBER,
95 X_PROGRAM_APPLICATION_ID IN NUMBER,
96 X_PROGRAM_UPDATE_DATE IN DATE,
97 X_ASSIGNMENT_CODE IN VARCHAR2
98 );
99
100
101 procedure LOCK_ROW (
102 X_STEP_ID IN NUMBER,
103 X_ROUTE_ID IN NUMBER,
104 X_STEP_SEQ_NUM IN NUMBER,
105 X_ADHOC_STEP_FLAG IN VARCHAR2,
106 X_WF_ITEM_TYPE IN VARCHAR2,
107 X_WF_ITEM_KEY IN VARCHAR2,
108 X_WF_PROCESS_NAME IN VARCHAR2,
109 X_CONDITION_TYPE_CODE IN VARCHAR2,
110 X_TIMEOUT_OPTION IN VARCHAR2,
111 X_STEP_STATUS_CODE IN VARCHAR2,
112 X_STEP_START_DATE IN DATE,
113 X_STEP_END_DATE IN DATE,
114 X_REQUIRED_RELATIVE_DAYS IN NUMBER,
115 X_REQUIRED_DATE IN DATE,
116 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
117 X_ATTRIBUTE1 IN VARCHAR2,
118 X_ATTRIBUTE2 IN VARCHAR2,
119 X_ATTRIBUTE3 IN VARCHAR2,
120 X_ATTRIBUTE4 IN VARCHAR2,
121 X_ATTRIBUTE5 IN VARCHAR2,
122 X_ATTRIBUTE6 IN VARCHAR2,
123 X_ATTRIBUTE7 IN VARCHAR2,
124 X_ATTRIBUTE8 IN VARCHAR2,
125 X_ATTRIBUTE9 IN VARCHAR2,
126 X_ATTRIBUTE10 IN VARCHAR2,
127 X_ATTRIBUTE11 IN VARCHAR2,
128 X_ATTRIBUTE12 IN VARCHAR2,
129 X_ATTRIBUTE13 IN VARCHAR2,
130 X_ATTRIBUTE14 IN VARCHAR2,
131 X_ATTRIBUTE15 IN VARCHAR2,
132 X_REQUEST_ID IN NUMBER,
133 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
134 X_INSTRUCTION IN VARCHAR2,
135 X_PROGRAM_ID IN NUMBER,
136 X_PROGRAM_APPLICATION_ID IN NUMBER,
137 X_PROGRAM_UPDATE_DATE IN DATE,
138 X_ASSIGNMENT_CODE IN VARCHAR2
139 );
140
141
142 procedure UPDATE_ROW (
143 X_STEP_ID IN NUMBER,
144 X_ROUTE_ID IN NUMBER,
145 X_STEP_SEQ_NUM IN NUMBER,
146 X_ADHOC_STEP_FLAG IN VARCHAR2,
147 X_WF_ITEM_TYPE IN VARCHAR2,
148 X_WF_ITEM_KEY IN VARCHAR2,
149 X_WF_PROCESS_NAME IN VARCHAR2,
150 X_CONDITION_TYPE_CODE IN VARCHAR2,
151 X_TIMEOUT_OPTION IN VARCHAR2,
152 X_STEP_STATUS_CODE IN VARCHAR2,
153 X_STEP_START_DATE IN DATE,
154 X_STEP_END_DATE IN DATE,
155 X_REQUIRED_RELATIVE_DAYS IN NUMBER,
156 X_REQUIRED_DATE IN DATE,
157 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
158 X_ATTRIBUTE1 IN VARCHAR2,
159 X_ATTRIBUTE2 IN VARCHAR2,
160 X_ATTRIBUTE3 IN VARCHAR2,
161 X_ATTRIBUTE4 IN VARCHAR2,
162 X_ATTRIBUTE5 IN VARCHAR2,
163 X_ATTRIBUTE6 IN VARCHAR2,
164 X_ATTRIBUTE7 IN VARCHAR2,
165 X_ATTRIBUTE8 IN VARCHAR2,
166 X_ATTRIBUTE9 IN VARCHAR2,
167 X_ATTRIBUTE10 IN VARCHAR2,
168 X_ATTRIBUTE11 IN VARCHAR2,
169 X_ATTRIBUTE12 IN VARCHAR2,
170 X_ATTRIBUTE13 IN VARCHAR2,
171 X_ATTRIBUTE14 IN VARCHAR2,
172 X_ATTRIBUTE15 IN VARCHAR2,
173 X_REQUEST_ID IN NUMBER,
174 X_ORIGINAL_SYSTEM_REFERENCE IN VARCHAR2,
175 X_INSTRUCTION IN VARCHAR2,
176 X_LAST_UPDATE_DATE IN DATE,
177 X_LAST_UPDATED_BY IN NUMBER,
178 X_LAST_UPDATE_LOGIN IN NUMBER,
179 X_PROGRAM_ID IN NUMBER,
180 X_PROGRAM_APPLICATION_ID IN NUMBER,
181 X_PROGRAM_UPDATE_DATE IN DATE,
182 X_ASSIGNMENT_CODE IN VARCHAR2
183 );
184
185 procedure DELETE_ROW (
186 X_STEP_ID IN NUMBER
187 );
188
189
190 PROCEDURE ADD_LANGUAGE;
191
192
193 /********************************************************************
194 * API Type : Public APIs
195 * Purpose : Those APIs are public
196 *********************************************************************/
197
198
199 END Eng_Change_Route_Step_Util ;