10:
11:
12: PROCEDURE Update_Firm_Planned_Flag
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
11:
12: PROCEDURE Update_Firm_Planned_Flag
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
12: PROCEDURE Update_Firm_Planned_Flag
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: p_wip_entity_id IN NUMBER,
113: );
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: x_return_status := fnd_api.g_ret_sts_error;
118: l_error_message := substrb(sqlerrm,1,512);
119: x_msg_data := l_error_message;
120:
121: END Update_Firm_Planned_Flag;
125:
126: PROCEDURE Move_WO
127: (
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: p_work_object_id IN NUMBER,
126: PROCEDURE Move_WO
127: (
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: p_work_object_id IN NUMBER,
134: p_work_object_type_id IN NUMBER,
127: (
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: p_work_object_id IN NUMBER,
134: p_work_object_type_id IN NUMBER,
135: p_offset_days IN NUMBER := 1, -- 1 Day Default
203: x_msg_data := l_msg_data;
204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: x_return_status := fnd_api.g_ret_sts_error;
208: l_error_message := substrb(sqlerrm,1,512);
209: x_msg_data := l_error_message;
210:
211: END;
216:
217: PROCEDURE Validate_Structure
218: (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223:
224: p_work_object_id IN NUMBER,
217: PROCEDURE Validate_Structure
218: (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223:
224: p_work_object_id IN NUMBER,
225: p_work_object_type_id IN NUMBER,
218: (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223:
224: p_work_object_id IN NUMBER,
225: p_work_object_type_id IN NUMBER,
226: p_exception_logging IN VARCHAR2 := 'N',
283: x_msg_data := l_msg_data;
284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: x_return_status := fnd_api.g_ret_sts_error;
288: l_error_message := substrb(sqlerrm,1,512);
289: x_msg_data := l_error_message;
290:
291: END;
295:
296: PROCEDURE Snap_Right
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302:
303: p_work_object_id IN NUMBER,
296: PROCEDURE Snap_Right
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302:
303: p_work_object_id IN NUMBER,
304: p_work_object_type_id IN NUMBER,
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302:
303: p_work_object_id IN NUMBER,
304: p_work_object_type_id IN NUMBER,
305:
353: x_msg_data := l_msg_data;
354:
355: EXCEPTION
356: WHEN OTHERS THEN
357: x_return_status := fnd_api.g_ret_sts_error;
358: l_error_message := substrb(sqlerrm,1,512);
359: x_msg_data := l_error_message;
360:
361: END;
365:
366: PROCEDURE Snap_Left
367: (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372:
373: p_work_object_id IN NUMBER,
366: PROCEDURE Snap_Left
367: (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372:
373: p_work_object_id IN NUMBER,
374: p_work_object_type_id IN NUMBER,
367: (
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
370: p_commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372:
373: p_work_object_id IN NUMBER,
374: p_work_object_type_id IN NUMBER,
375:
424: x_msg_data := l_msg_data;
425:
426: EXCEPTION
427: WHEN OTHERS THEN
428: x_return_status := fnd_api.g_ret_sts_error;
429: l_error_message := substrb(sqlerrm,1,512);
430: x_msg_data := l_error_message;
431:
432: END;