APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 2539: insert into bom_op_sequences_interface

2535: */
2536:
2537: l_batch_id := bom_import_pub.get_batchid;
2538:
2539: insert into bom_op_sequences_interface
2540: (
2541: operation_seq_num,
2542: operation_type,
2543: routing_sequence_id,

Line 2572: insert into bom_op_sequences_interface

2568: and nvl(os1.operation_type,1 ) = 1 ))
2569: and ( os1.disable_date is null or
2570: (os1.disable_date is not null and os1.disable_date >= sysdate ));
2571:
2572: insert into bom_op_sequences_interface
2573: (
2574: operation_seq_num,
2575: operation_type,
2576: routing_sequence_id,

Line 2636: insert into bom_op_sequences_interface

2632: and os1.option_dependent_flag = 1
2633: and nvl(os1.operation_type,1) = 1;
2634:
2635:
2636: insert into bom_op_sequences_interface
2637: (
2638: operation_seq_num,
2639: operation_type,
2640: routing_sequence_id,

Line 2699: from bom_op_sequences_interface

2695: routing_sequence_id) In
2696: (select operation_seq_num,
2697: nvl(operation_type,1),
2698: routing_sequence_id
2699: from bom_op_sequences_interface
2700: where batch_id = l_batch_id)
2701: and implementation_date is not null
2702: and ( disable_date is null or
2703: (disable_date is not null and disable_date >= sysdate ))

Line 2708: delete from bom_op_sequences_interface where batch_id = l_batch_id;

2704: RETURNING routing_sequence_id BULK COLLECT INTO tModOpClassRtg;
2705:
2706: WriteToLog('Model Routing : Marked ' || sql%rowcount || ' records for insertion',4);--moved here for 4492875
2707:
2708: delete from bom_op_sequences_interface where batch_id = l_batch_id;
2709:
2710: if tModOpClassRtg.count > 0 then
2711: k := 1;
2712: tDistinctRtgSeq(k) := tModOpClassRtg(1);