1 PACKAGE ENG_Eco_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGUECOS.pls 120.3.12010000.3 2009/06/15 15:02:40 vggarg ship $ */
3
4
5 --========================================================================
6 -- PROCEDURE : Org_Hierarchy_List PUBLIC
7 -- PARAMETERS: p_org_hierarch_name IN VARCHAR2(30) Organization Hierarchy
8 -- Name
9 -- p_org_hier_lvl_id IN NUMBER Hierarchy Level Id
10 -- x_org_cod_list List of Organizations
11 --
12 -- COMMENT : API accepts the name of an hierarchy, hierarchy level id and
13 -- returns the list of organizations it contains.
14 -- p_org_hierarchy_name contains user input organization hierarchy
15 -- name
16 -- p_org_hier_level_id contains user input hierarchy level
17 -- organization id in the hierarchy
18 -- x_org_code_list contains list of organizations for a given org
19 -- hierarchy level
20 --=========================================================================
21 PROCEDURE Org_Hierarchy_List
22 ( p_org_hierarch_name IN VARCHAR2,
23 p_org_hier_lvl_id IN NUMBER,
24 x_org_cod_list OUT NOCOPY ego_number_tbl_type);
25
26
27
28
29 /********************************************************************
30 * API Type : Local APIs
31 * Purpose : Those APIs are private
32 *********************************************************************/
33 /** R12C Changes
34 * ENG Change order Proc implementation
35 * */
36
37
38 PROCEDURE Execute_ProcCP
39 (
40 p_api_version IN NUMBER := 1.0 --
41 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
42 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
43 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
44 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
45 ,p_output_dir IN VARCHAR2 := '/appslog/bis_top/utl/plm115dv/log'
46 ,p_debug_filename IN VARCHAR2 := 'engact.implement.log'
47 ,x_return_status OUT NOCOPY VARCHAR2 --
48 ,x_msg_count OUT NOCOPY NUMBER --
52 ,p_rev_item_seq_id IN NUMBER := NULL
49 ,x_msg_data OUT NOCOPY VARCHAR2 --
50 ,p_change_id IN NUMBER --
51 ,p_change_notice IN VARCHAR2 --
53 ,p_org_id IN NUMBER --
54 ,p_all_org_flag IN VARCHAR2
55 ,p_hierarchy_name IN VARCHAR2
56 ,x_request_id OUT NOCOPY NUMBER --
57 );
58
59 -- Code changes for enhancement 6084027 start
60 PROCEDURE Execute_ProcCP
61 (
62 p_api_version IN NUMBER --
63 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
64 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
65 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
66 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
67 ,p_output_dir IN VARCHAR2
68 ,p_debug_filename IN VARCHAR2
69 ,x_return_status OUT NOCOPY VARCHAR2 --
70 ,x_msg_count OUT NOCOPY NUMBER --
71 ,x_msg_data OUT NOCOPY VARCHAR2 --
72 ,p_change_id IN NUMBER --
73 ,p_change_notice IN VARCHAR2 --
74 ,p_rev_item_seq_id IN NUMBER := NULL
75 ,p_org_id IN NUMBER --
76 ,x_request_id OUT NOCOPY NUMBER --
77 );
78 -- Code changes for enhancement 6084027 end
79
80 /**
81 * ENG Change ECO Action
82 * @author HaiXin Tie
83 */
84
85 /** R12C Changes
86 * ENG Change order Rule invocation implementation.
87 * For R12C we have changed this so that for PLM/ERP Change order
88 * Implementation first rule CP will get fire if there exist any attribute changes
89 * Corresponding to it then Rule validation/assignment will happen.
90 * after successfull execution of rule Proc CP will get fire.
91 * ENG Change ECO Action.Just executable has been changed all other things are same.
92 * @author HaiXin Tie
93 */
94
95 PROCEDURE Implement_ECO
96 (
97 p_api_version IN NUMBER --
98 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
99 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
100 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
101 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
102 ,p_output_dir IN VARCHAR2 := '/appslog/bis_top/utl/plm115dv/log'
103 ,p_debug_filename IN VARCHAR2 := 'engact.implement.log'
104 ,x_return_status OUT NOCOPY VARCHAR2 --
105 ,x_msg_count OUT NOCOPY NUMBER --
106 ,x_msg_data OUT NOCOPY VARCHAR2 --
107 ,p_change_id IN NUMBER --
108 ,p_change_notice IN VARCHAR2 --
109 ,p_rev_item_seq_id IN NUMBER := NULL
110 ,p_org_id IN NUMBER --
111 ,x_request_id OUT NOCOPY NUMBER --
112 );
113
114
115
116 /**
117 * ENG Change ECO Action
118 * @author HaiXin Tie
119 */
120 PROCEDURE Propagate_ECO
121 (
122 p_api_version IN NUMBER --
123 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
124 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
125 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
126 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
127 ,p_output_dir IN VARCHAR2 := '/appslog/bis_top/utl/plm115dv/log'
128 ,p_debug_filename IN VARCHAR2 := 'engact.propagate.log'
129 ,x_return_status OUT NOCOPY VARCHAR2 --
130 ,x_msg_count OUT NOCOPY NUMBER --
131 ,x_msg_data OUT NOCOPY VARCHAR2 --
132 ,p_change_id IN NUMBER --
133 ,p_change_notice IN VARCHAR2 --
134 ,p_hierarchy_name IN VARCHAR2 --
135 ,p_org_name IN VARCHAR2 --
136 ,x_request_id OUT NOCOPY NUMBER --
137 ,p_local_organization_id IN NUMBER := NULL -- Added for R12
138 ,p_calling_API IN VARCHAR2 := NULL --R12
139
140 );
141
142
143 /**
144 * ENG Change ECO Action
145 * @author HaiXin Tie
146 */
147 PROCEDURE Reschedule_ECO
148 (
149 p_api_version IN NUMBER --
150 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
151 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
152 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
153 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
154 ,p_output_dir IN VARCHAR2 := '/appslog/bis_top/utl/plm115dv/log'
155 ,p_debug_filename IN VARCHAR2 := 'engact.reschedule.log'
156 ,x_return_status OUT NOCOPY VARCHAR2 --
157 ,x_msg_count OUT NOCOPY NUMBER --
161 ,p_requestor_id IN NUMBER --
158 ,x_msg_data OUT NOCOPY VARCHAR2 --
159 ,p_change_id IN NUMBER --
160 ,p_effectivity_date IN DATE --
162 ,p_comment IN VARCHAR2 --
163 );
164
165
166 /**
167 * ENG Change ECO Action
168 * @author HaiXin Tie
169 */
170 PROCEDURE Change_Effectivity_Date
171 (
172 p_api_version IN NUMBER --
173 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
174 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
175 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
176 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
177 ,p_output_dir IN VARCHAR2 := '/appslog/bis_top/utl/plm115dv/log'
178 ,p_debug_filename IN VARCHAR2 := 'engact.chgEffDate.log'
179 ,x_return_status OUT NOCOPY VARCHAR2 --
180 ,x_msg_count OUT NOCOPY NUMBER --
181 ,x_msg_data OUT NOCOPY VARCHAR2 --
182 ,p_change_id IN NUMBER --
183 ,p_effectivity_date IN DATE --
184 ,p_comment IN VARCHAR2 --
185 );
186
187 /**
188 * ENG Change Submit action
189 * @author biao
190 */
191 PROCEDURE submit_ECO
192 (
193 p_api_version IN NUMBER --
194 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
195 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
196 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
197 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
198 ,p_output_dir IN VARCHAR2 := '/appslog/bis_top/utl/plm115dv/log'
199 ,p_debug_filename IN VARCHAR2 := 'engact.submitECO.log'
200 ,x_return_status OUT NOCOPY VARCHAR2 --
201 ,x_msg_count OUT NOCOPY NUMBER --
202 ,x_msg_data OUT NOCOPY VARCHAR2 --
203 ,p_change_id IN NUMBER --
204 );
205
206
207 -- Attributes global constants
208
209 G_ATTRIBUTE7 CONSTANT NUMBER := 1;
210 G_ATTRIBUTE8 CONSTANT NUMBER := 2;
211 G_ATTRIBUTE9 CONSTANT NUMBER := 3;
212 G_ATTRIBUTE10 CONSTANT NUMBER := 4;
213 G_ATTRIBUTE11 CONSTANT NUMBER := 5;
214 G_ATTRIBUTE12 CONSTANT NUMBER := 6;
215 G_ATTRIBUTE13 CONSTANT NUMBER := 7;
216 G_ATTRIBUTE14 CONSTANT NUMBER := 8;
217 G_ATTRIBUTE15 CONSTANT NUMBER := 9;
218 G_REQUEST CONSTANT NUMBER := 10;
219 G_PROGRAM_APPLICATION CONSTANT NUMBER := 11;
220 G_PROGRAM CONSTANT NUMBER := 12;
221 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 13;
222 G_APPROVAL_STATUS_TYPE CONSTANT NUMBER := 14;
223 G_APPROVAL_DATE CONSTANT NUMBER := 15;
224 G_APPROVAL_LIST CONSTANT NUMBER := 16;
225 G_CHANGE_ORDER_TYPE CONSTANT NUMBER := 17;
226 G_RESPONSIBLE_ORG CONSTANT NUMBER := 18;
227 G_APPROVAL_REQUEST_DATE CONSTANT NUMBER := 19;
228 G_CHANGE_NOTICE CONSTANT NUMBER := 20;
229 G_ORGANIZATION CONSTANT NUMBER := 21;
230 G_LAST_UPDATE_DATE CONSTANT NUMBER := 22;
231 G_LAST_UPDATED_BY CONSTANT NUMBER := 23;
232 G_CREATION_DATE CONSTANT NUMBER := 24;
233 G_CREATED_BY CONSTANT NUMBER := 25;
234 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 26;
235 G_DESCRIPTION CONSTANT NUMBER := 27;
236 G_STATUS_TYPE CONSTANT NUMBER := 28;
237 G_INITIATION_DATE CONSTANT NUMBER := 29;
238 G_IMPLEMENTATION_DATE CONSTANT NUMBER := 30;
239 G_CANCELLATION_DATE CONSTANT NUMBER := 31;
240 G_CANCELLATION_COMMENTS CONSTANT NUMBER := 32;
241 G_PRIORITY CONSTANT NUMBER := 33;
242 G_REASON CONSTANT NUMBER := 34;
243 G_ESTIMATED_ENG_COST CONSTANT NUMBER := 35;
244 G_ESTIMATED_MFG_COST CONSTANT NUMBER := 36;
245 G_REQUESTOR CONSTANT NUMBER := 37;
246 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 38;
247 G_ATTRIBUTE1 CONSTANT NUMBER := 39;
248 G_ATTRIBUTE2 CONSTANT NUMBER := 40;
249 G_ATTRIBUTE3 CONSTANT NUMBER := 41;
250 G_ATTRIBUTE4 CONSTANT NUMBER := 42;
251 G_ATTRIBUTE5 CONSTANT NUMBER := 43;
252 G_ATTRIBUTE6 CONSTANT NUMBER := 44;
253 G_MAX_ATTR_ID CONSTANT NUMBER := 45;
254
255 -- Procedure Perform_Writes
256
257 PROCEDURE Perform_Writes
258 ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
259 , p_Unexp_ECO_rec IN ENG_ECO_PUB.ECO_Unexposed_Rec_Type
260 , p_old_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
261 , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
262 := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
263 , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
264 , x_return_status OUT NOCOPY VARCHAR
265 );
266
267
268 -- Procedure Query_Row
269
270 PROCEDURE Query_Row
271 ( p_change_notice IN VARCHAR2
272 , p_organization_id IN NUMBER
273 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
274 , x_ECO_Unexp_Rec OUT NOCOPY ENG_ECO_PUB.ECO_Unexposed_Rec_Type
275 , x_return_status OUT NOCOPY VARCHAR2
276 , x_err_text OUT NOCOPY VARCHAR2);
277
278
279
280 -- Procedure Perform_Approval_Status_Change
281 -- to centraize business logic for Approval Status change
282 PROCEDURE Perform_Approval_Status_Change
283 ( p_change_id IN NUMBER
284 , p_user_id IN NUMBER := NULL
285 , p_approval_status_type IN NUMBER
286 , p_caller_type IN VARCHAR2 := 'OI'
287 , x_return_status OUT NOCOPY VARCHAR2
288 , x_err_text OUT NOCOPY VARCHAR2
289 );
290
291 -- Procedure lock_Row
292 --
293
294 /*PROCEDURE Lock_Row
295 ( x_return_status OUT NOCOPY VARCHAR2
296 , x_err_text OUT NOCOPY VARCHAR2
297 , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
298 , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
299 );
300 */
301
302
303 PROCEDURE Change_Subjects
304 ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
305 , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
306 , x_change_subject_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Subject_Unexp_Rec_Type
307 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type --bug 3572721
308 , x_return_status IN OUT NOCOPY VARCHAR2
309 );
310
311
312 PROCEDURE delete_ECO
313 (
314 p_api_version IN NUMBER --
315 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
316 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
317 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318 ,x_return_status OUT NOCOPY VARCHAR2 --
319 ,x_msg_count OUT NOCOPY NUMBER --
320 ,x_msg_data OUT NOCOPY VARCHAR2 --
321 ,p_change_id IN NUMBER -- header's change_id
322 ,p_api_caller IN VARCHAR2 := 'UI'
323 );
324
325 PROCEDURE is_Reschedule_ECO_Allowed
326 (
327 p_change_id IN NUMBER --
328 ,x_is_change_sch_date_allowed OUT NOCOPY VARCHAR2
329 );
330
331 END ENG_Eco_Util;