APPS.M4R_7B1_WSM_IN dependencies on BOM_OPERATION_SEQUENCES

Line 291: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for fm_values';

287: cln_debug_pub.Add('p_hdr_id : ' || p_hdr_id, 2);
288: cln_debug_pub.Add('p_rout_seq_id : ' || p_rout_seq_id, 2);
289: END IF;
290:
291: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for fm_values';
292:
293: SELECT standard_operation_id,department_id,operation_Sequence_id
294: INTO x_fm_std_op_id,x_fm_dept_id,x_fm_op_seq_id
295: FROM BOM_OPERATION_SEQUENCES

Line 295: FROM BOM_OPERATION_SEQUENCES

291: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for fm_values';
292:
293: SELECT standard_operation_id,department_id,operation_Sequence_id
294: INTO x_fm_std_op_id,x_fm_dept_id,x_fm_op_seq_id
295: FROM BOM_OPERATION_SEQUENCES
296: WHERE routing_sequence_id = p_rout_seq_id
297: AND operation_seq_num = p_prev_op_seq_num;
298:
299: IF p_prev_op_seq_num = p_op_seq_num THEN

Line 306: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for to_ values';

302: x_to_std_op_id := x_fm_std_op_id;
303: x_to_op_seq_id := x_fm_op_seq_id;
304: ELSE
305:
306: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for to_ values';
307:
308: SELECT standard_operation_id,department_id,operation_Sequence_id
309: INTO x_to_std_op_id,x_to_dept_id,x_to_op_seq_id
310: FROM BOM_OPERATION_SEQUENCES

Line 310: FROM BOM_OPERATION_SEQUENCES

306: g_exception_tracking_msg := 'Querying BOM_OPERATION_SEQUENCES for to_ values';
307:
308: SELECT standard_operation_id,department_id,operation_Sequence_id
309: INTO x_to_std_op_id,x_to_dept_id,x_to_op_seq_id
310: FROM BOM_OPERATION_SEQUENCES
311: WHERE routing_sequence_id = p_rout_seq_id
312: AND operation_seq_num = p_op_seq_num;
313: END IF;
314: