DBA Data[Home] [Help]

APPS.BOM_OP_NETWORK_UTIL dependencies on BOM_OPERATION_NETWORKS

Line 101: FROM bom_operation_networks

97: , l_op_network_rec.attribute12
98: , l_op_network_rec.attribute13
99: , l_op_network_rec.attribute14
100: , l_op_network_rec.attribute15
101: FROM bom_operation_networks
102: WHERE from_op_seq_id = p_from_op_seq_id
103: AND to_op_seq_id = p_to_op_seq_id;
104:
105: x_return_status := BOM_Rtg_Globals.G_RECORD_FOUND;

Line 148: INSERT INTO bom_operation_networks

144: || p_op_network_rec.assembly_item_name);
145: END IF;
146:
147: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
148: INSERT INTO bom_operation_networks
149: ( from_op_seq_id
150: , to_op_seq_id
151: , transition_type
152: , planning_pct

Line 288: UPDATE bom_operation_networks

284: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
285: Error_Handler.Write_Debug('Updating operation network ');
286: END IF;
287:
288: UPDATE bom_operation_networks
289: SET
290: from_op_seq_id = DECODE(p_op_network_unexp_rec.new_from_op_seq_id,
291: NULL , p_op_network_unexp_rec.from_op_seq_id,
292: p_op_network_unexp_rec.new_from_op_seq_id

Line 390: DELETE FROM bom_operation_networks

386: Error_Handler.Write_Debug('Delete operation network.'
387: );
388: END IF;
389:
390: DELETE FROM bom_operation_networks
391: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
392: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
393:
394: EXCEPTION

Line 792: BOM_OPERATION_NETWORKS bon_from,

788: bos.IMPLEMENTATION_DATE IS NOT NULL
789: AND bos.OPERATION_SEQ_NUM IN
790: ( SELECT bos_first.OPERATION_SEQ_NUM
791: FROM
792: BOM_OPERATION_NETWORKS bon_from,
793: BOM_OPERATION_NETWORKS bon_to,
794: BOM_OPERATION_SEQUENCES bos_first
795: WHERE
796: bon_from.FROM_OP_SEQ_ID = bos_first.OPERATION_SEQUENCE_ID

Line 793: BOM_OPERATION_NETWORKS bon_to,

789: AND bos.OPERATION_SEQ_NUM IN
790: ( SELECT bos_first.OPERATION_SEQ_NUM
791: FROM
792: BOM_OPERATION_NETWORKS bon_from,
793: BOM_OPERATION_NETWORKS bon_to,
794: BOM_OPERATION_SEQUENCES bos_first
795: WHERE
796: bon_from.FROM_OP_SEQ_ID = bos_first.OPERATION_SEQUENCE_ID
797: AND bon_from.TO_OP_SEQ_ID = bon_to.FROM_OP_SEQ_ID

Line 813: BOM_OPERATION_NETWORKS bon_from,

809: bos.IMPLEMENTATION_DATE IS NOT NULL
810: AND bos.OPERATION_SEQ_NUM IN
811: ( SELECT bos_last.OPERATION_SEQ_NUM
812: FROM
813: BOM_OPERATION_NETWORKS bon_from,
814: BOM_OPERATION_NETWORKS bon_to,
815: BOM_OPERATION_SEQUENCES bos_last
816: WHERE
817: bon_to.TO_OP_SEQ_ID = bos_last.OPERATION_SEQUENCE_ID

Line 814: BOM_OPERATION_NETWORKS bon_to,

810: AND bos.OPERATION_SEQ_NUM IN
811: ( SELECT bos_last.OPERATION_SEQ_NUM
812: FROM
813: BOM_OPERATION_NETWORKS bon_from,
814: BOM_OPERATION_NETWORKS bon_to,
815: BOM_OPERATION_SEQUENCES bos_last
816: WHERE
817: bon_to.TO_OP_SEQ_ID = bos_last.OPERATION_SEQUENCE_ID
818: AND bon_from.TO_OP_SEQ_ID = bon_to.FROM_OP_SEQ_ID