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