[Home] [Help]
188: , l_bo_id VARCHAR2
189: )
190: IS
191:
192: SELECT * FROM BOM_OPERATION_SEQUENCES
193: WHERE (( l_bo_id = BOM_Rtg_Globals.G_ECO_BO )
194: -- AND implementation_date IS NULL )
195: OR (l_bo_id = BOM_Rtg_Globals.G_RTG_BO
196: AND implementation_date IS NOT NULL )
206: AND OPERATION_SEQ_NUM = p_operation_sequence_number
207: AND routing_sequence_id = p_routing_sequence_id
208: ;
209:
210: op_seq_rec BOM_OPERATION_SEQUENCES%ROWTYPE ;
211:
212:
213: BEGIN
214:
1159: X_from_pk2_value => null,
1160: X_from_pk3_value => null,
1161: X_from_pk4_value => null,
1162: X_from_pk5_value => null,
1163: X_to_entity_name => 'BOM_OPERATION_SEQUENCES',
1164: X_to_pk1_value => to_char( p_operation_sequence_id ),
1165: X_to_pk2_value => null,
1166: X_to_pk3_value => null,
1167: X_to_pk4_value => null,
1419: * Common Operation unexposed column record
1420: * Parameters out: Return Status
1421: * Message Token Table
1422: * Purpose : This procedure will insert a record in the Operation Sequence
1423: * table; BOM_OPERATION_SEQUENCES.
1424: *
1425: *****************************************************************************/
1426: PROCEDURE Insert_Row
1427: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1475:
1476: l_eco_for_production := BOM_Rtg_Globals.Get_Eco_For_Production;
1477:
1478: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
1479: INSERT INTO BOM_OPERATION_SEQUENCES(
1480: operation_sequence_id ,
1481: routing_sequence_id ,
1482: operation_seq_num ,
1483: last_update_date ,
1741:
1742: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
1743: END IF ;
1744:
1745: UPDATE BOM_OPERATION_SEQUENCES
1746: SET operation_seq_num = DECODE(p_com_operation_rec.new_operation_sequence_number ,
1747: NULL , p_com_operation_rec.operation_sequence_number ,
1748: p_com_operation_rec.new_operation_sequence_number
1749: )
1885: * record for a ECO.
1886: * This procedure will not delete a record in production
1887: * which is already implemented.
1888: * For RTG BO, Procedure will perfrom an Delete from the
1889: * BOM_Operation_Sequences by creating a delete Group.
1890: *********************************************************************/
1891: PROCEDURE Delete_Row
1892: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1893: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1939:
1940: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
1941: THEN
1942:
1943: DELETE FROM BOM_OPERATION_SEQUENCES
1944: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1945:
1946:
1947: DELETE FROM BOM_OPERATION_RESOURCES
2299: , REVISED_ITEM_SEQUENCE_ID
2300: , SYSDATE -- Cancellation Date
2301: , p_cancel_comments -- Cancel Comments
2302: , ORIGINAL_SYSTEM_REFERENCE
2303: FROM BOM_OPERATION_SEQUENCES
2304: WHERE operation_sequence_id = p_operation_sequence_id ;
2305:
2306:
2307: --
2306:
2307: --
2308: -- Delete Cancel Revisd Operation from operation table
2309: --
2310: DELETE FROM BOM_OPERATION_SEQUENCES
2311: WHERE operation_sequence_id = p_operation_sequence_id ;
2312:
2313: --
2314: -- Delete child Operation Resources