APPS.BOM_RTG_APPLET_PKG dependencies on BOM_OPERATION_SEQUENCES

Line 15: UPDATE BOM_OPERATION_SEQUENCES

11: x_error_msg OUT NOCOPY VARCHAR
12: ) IS
13: BEGIN
14: IF (x_operation_type = 2) THEN
15: UPDATE BOM_OPERATION_SEQUENCES
16: SET
17: process_op_seq_id = x_new_parent_op_seq_id,
18: last_updated_by = x_last_updated_by,
19: last_update_date = NVL(x_last_update_date, SYSDATE)

Line 22: UPDATE BOM_OPERATION_SEQUENCES

18: last_updated_by = x_last_updated_by,
19: last_update_date = NVL(x_last_update_date, SYSDATE)
20: WHERE operation_sequence_id = x_event_op_seq_id;
21: ELSIF (x_operation_type = 3) THEN
22: UPDATE BOM_OPERATION_SEQUENCES
23: SET
24: line_op_seq_id = x_new_parent_op_seq_id,
25: last_updated_by = x_last_updated_by,
26: last_update_date = NVL(x_last_update_date, SYSDATE)

Line 289: FROM bom_operation_sequences

285: IF (primary_exists = 1) THEN
286:
287: SELECT operation_type, operation_seq_num
288: INTO op_type, from_op_seq_num
289: FROM bom_operation_sequences
290: WHERE operation_sequence_id = x_from_op_seq_id;
291:
292: FND_MESSAGE.SET_NAME('BOM','BOM_CHECK_UNIQUE_PRIMARY');
293: IF (op_type = 2) THEN

Line 307: FROM bom_operation_sequences

303: ELSIF (link_exists = 1) THEN
304:
305: SELECT operation_seq_num
306: INTO from_op_seq_num
307: FROM bom_operation_sequences
308: WHERE operation_sequence_id = x_from_op_seq_id;
309:
310: SELECT operation_seq_num
311: INTO to_op_seq_num

Line 312: FROM bom_operation_sequences

308: WHERE operation_sequence_id = x_from_op_seq_id;
309:
310: SELECT operation_seq_num
311: INTO to_op_seq_num
312: FROM bom_operation_sequences
313: WHERE operation_sequence_id = x_to_op_seq_id;
314:
315: FND_MESSAGE.SET_NAME('BOM','BOM_LINK_ALREADY_EXISTS');
316: FND_MESSAGE.SET_TOKEN('FROM_OP_SEQ_ID',to_char(from_op_seq_num), FALSE);

Line 327: FROM bom_operation_sequences

323: OR (x_transition_type = 3 and (nvl(sum_planning_pct,0) > 100)) THEN
324:
325: SELECT operation_type, operation_seq_num
326: INTO op_type, from_op_seq_num
327: FROM bom_operation_sequences
328: WHERE operation_sequence_id = x_from_op_seq_id;
329:
330: FND_MESSAGE.SET_NAME('BOM','BOM_CHECK_PLANNING_PERCENT');
331: IF (op_type = 2) THEN

Line 364: UPDATE BOM_OPERATION_SEQUENCES

360: x_return_code OUT NOCOPY VARCHAR2,
361: x_error_msg OUT NOCOPY VARCHAR2
362: ) IS
363: BEGIN
364: UPDATE BOM_OPERATION_SEQUENCES
365: SET
366: x_coordinate = x_x_coordinate,
367: y_coordinate = x_y_coordinate,
368: last_updated_by = x_last_updated_by,