APPS.CTO_UPDATE_BOM_RTG_PK dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 2450: insert into bom_op_sequences_interface

2446: */
2447:
2448: l_batch_id := bom_import_pub.get_batchid;
2449:
2450: insert into bom_op_sequences_interface
2451: (
2452: operation_seq_num,
2453: operation_type,
2454: routing_sequence_id,

Line 2483: insert into bom_op_sequences_interface

2479: and nvl(os1.operation_type,1 ) = 1 ))
2480: and ( os1.disable_date is null or
2481: (os1.disable_date is not null and os1.disable_date >= sysdate ));
2482:
2483: insert into bom_op_sequences_interface
2484: (
2485: operation_seq_num,
2486: operation_type,
2487: routing_sequence_id,

Line 2547: insert into bom_op_sequences_interface

2543: and os1.option_dependent_flag = 1
2544: and nvl(os1.operation_type,1) = 1;
2545:
2546:
2547: insert into bom_op_sequences_interface
2548: (
2549: operation_seq_num,
2550: operation_type,
2551: routing_sequence_id,

Line 2610: from bom_op_sequences_interface

2606: routing_sequence_id) In
2607: (select operation_seq_num,
2608: nvl(operation_type,1),
2609: routing_sequence_id
2610: from bom_op_sequences_interface
2611: where batch_id = l_batch_id)
2612: and implementation_date is not null
2613: and ( disable_date is null or
2614: (disable_date is not null and disable_date >= sysdate ))

Line 2619: delete from bom_op_sequences_interface where batch_id = l_batch_id;

2615: RETURNING routing_sequence_id BULK COLLECT INTO tModOpClassRtg;
2616:
2617: WriteToLog('Model Routing : Marked ' || sql%rowcount || ' records for insertion',4);--moved here for 4492875
2618:
2619: delete from bom_op_sequences_interface where batch_id = l_batch_id;
2620:
2621: if tModOpClassRtg.count > 0 then
2622: k := 1;
2623: tDistinctRtgSeq(k) := tModOpClassRtg(1);