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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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,
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,
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:
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,
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,
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,
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:
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,
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,
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:
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,
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,
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:
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,
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,
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:
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,
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,
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:
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,
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,
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:
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,
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,
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: