1 PACKAGE EAM_WO_NETWORK_DEFAULT_PVT AS
2 /* $Header: EAMVWNDS.pls 120.0 2005/05/25 15:43:30 appldev noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVWNDS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_WO_NETWORK_DEFAULT_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 11-SEP-2003 Basanth Roy Initial Creation
21 ***************************************************************************/
22
23
24
25
26 l_created_by NUMBER := FND_GLOBAL.user_id;
27 l_last_updated_by NUMBER := FND_GLOBAL.user_id;
28
29
30 PROCEDURE Add_WO_To_Network
31 (
32 p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34 p_commit IN VARCHAR2 := FND_API.G_FALSE,
35 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36
37 p_child_object_id IN NUMBER,
38 p_child_object_type_id IN NUMBER,
39 p_parent_object_id IN NUMBER,
40 p_parent_object_type_id IN NUMBER,
41 p_adjust_parent IN VARCHAR2 := FND_API.G_FALSE,
42 p_relationship_type IN NUMBER := 1,
43
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
48 );
49
50 PROCEDURE Adjust_Parent
51 (
52 p_parent_object_id IN NUMBER,
53 p_parent_object_type_id IN NUMBER
54 );
55 /*Bug3521886: Pass requested start date and due date*/
56 PROCEDURE Resize_WO
57 (
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_object_id IN NUMBER,
63 p_object_type_id IN NUMBER,
64 p_start_date IN DATE,
65 p_completion_date IN DATE,
66 p_required_start_date IN DATE := NULL,
67 p_required_due_date IN DATE := NULL,
68 p_org_id IN VARCHAR2,
69 p_firm IN NUMBER,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75
76
77 PROCEDURE Delete_Dependency
78 (
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83
84 p_prior_object_id IN NUMBER,
85 p_prior_object_type_id IN NUMBER,
86 p_next_object_id IN NUMBER,
87 p_next_object_type_id IN NUMBER,
88
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2 ,
92 x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
93 );
94
95
96 PROCEDURE Add_Dependency
97 (
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100 p_commit IN VARCHAR2 := FND_API.G_FALSE,
101 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102
103 p_prior_object_id IN NUMBER,
104 p_prior_object_type_id IN NUMBER,
105 p_next_object_id IN NUMBER,
106 p_next_object_type_id IN NUMBER,
107
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2 ,
111 x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
112 );
113
114
115 PROCEDURE Delink_Child_From_Parent
116 (
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119 p_commit IN VARCHAR2 := FND_API.G_FALSE,
120 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121
122 p_child_object_id IN NUMBER,
123 p_child_object_type_id IN NUMBER,
124 p_parent_object_id IN NUMBER,
125 p_parent_object_type_id IN NUMBER,
126 p_relationship_type IN NUMBER,
127
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2 ,
131 x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
132 );
133
134
135 -- This procedure will check whether the operation dates fall within the
136 -- WO dates and whether the resource dates fall within the operation dates
137 -- This procedure can be used while moving or resizing work orders
138 PROCEDURE Check_WO_Dates
139 (
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144
145 p_wip_entity_id IN NUMBER,
146
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2
150 );
151
152 PROCEDURE Check_Resource_Dates
153 (
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156 p_commit IN VARCHAR2 := FND_API.G_FALSE,
157 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
158
159 p_wip_entity_id IN NUMBER,
160
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166
167 -- This procedure will check that work order / operation / resource duration cannot be negative
168 PROCEDURE Check_Wo_Negative_Dates
169 (
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_commit IN VARCHAR2 := FND_API.G_FALSE,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174
175 p_wip_entity_id IN NUMBER,
176 p_organization_id IN NUMBER,
177
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2
181 );
182
183
184 PROCEDURE Snap_Right
185 (
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190
191 p_work_object_id IN NUMBER,
192 p_work_object_type_id IN NUMBER,
193
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2
197
198 );
199
200 PROCEDURE Snap_Left
201 (
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE,
205 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206
207 p_work_object_id IN NUMBER,
208 p_work_object_type_id IN NUMBER,
209
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2
213
214 );
215
216 PROCEDURE Snap_Right_Window
217 (
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
220 p_commit IN VARCHAR2 := FND_API.G_FALSE,
221 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222
223 p_work_object_id IN NUMBER,
224 p_work_object_type_id IN NUMBER,
225
226 x_right_snap_window OUT NOCOPY NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2
230 --x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
231
232 );
233
234 PROCEDURE Snap_Left_Window
235 (
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
238 p_commit IN VARCHAR2 := FND_API.G_FALSE,
239 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240
241 p_work_object_id IN NUMBER,
242 p_work_object_type_id IN NUMBER,
243
244 x_left_snap_window OUT NOCOPY NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2
248 --x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
249
250 );
251
252 PROCEDURE Find_Right_Snap_Window
253 (
254 p_api_version IN NUMBER,
255 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
256 p_commit IN VARCHAR2 := FND_API.G_FALSE,
257 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
258
259 p_starting_object_id IN NUMBER,
260 p_starting_obj_type_id IN NUMBER,
261
262 p_parent_object_id IN NUMBER,
263 p_parent_object_type_id IN NUMBER,
264 p_cur_right_snap_window IN NUMBER, -- IN Days
265
266 x_right_snap_window OUT NOCOPY NUMBER, -- In Days
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2
270 );
271
272 PROCEDURE Find_Left_Snap_Window
273 (
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276 p_commit IN VARCHAR2 := FND_API.G_FALSE,
277 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278
279 p_starting_object_id IN NUMBER,
280 p_starting_obj_type_id IN NUMBER,
281
282 p_parent_object_id IN NUMBER,
283 p_parent_object_type_id IN NUMBER,
284 p_cur_left_snap_window IN NUMBER, -- IN Days
285
286 x_left_snap_window OUT NOCOPY NUMBER, -- In Days
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2
290 );
291
292 --This procedure is called from procedure 'Delink_Child_From_Parent'
293 --This sets the workorder dates to be the maximum of its operations and child workorders dates
294 PROCEDURE Shrink_Parent
295 (
296 p_parent_object_id IN NUMBER,
297 p_parent_object_type_id IN NUMBER
298 );
299
300 END EAM_WO_NETWORK_DEFAULT_PVT;