[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:
1156: X_from_pk2_value => null,
1157: X_from_pk3_value => null,
1158: X_from_pk4_value => null,
1159: X_from_pk5_value => null,
1160: X_to_entity_name => 'BOM_OPERATION_SEQUENCES',
1161: X_to_pk1_value => to_char( p_operation_sequence_id ),
1162: X_to_pk2_value => null,
1163: X_to_pk3_value => null,
1164: X_to_pk4_value => null,
1416: * Common Operation unexposed column record
1417: * Parameters out: Return Status
1418: * Message Token Table
1419: * Purpose : This procedure will insert a record in the Operation Sequence
1420: * table; BOM_OPERATION_SEQUENCES.
1421: *
1422: *****************************************************************************/
1423: PROCEDURE Insert_Row
1424: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1472:
1473: l_eco_for_production := BOM_Rtg_Globals.Get_Eco_For_Production;
1474:
1475: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
1476: INSERT INTO BOM_OPERATION_SEQUENCES(
1477: operation_sequence_id ,
1478: routing_sequence_id ,
1479: operation_seq_num ,
1480: last_update_date ,
1738:
1739: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Performing update operation . . .') ;
1740: END IF ;
1741:
1742: UPDATE BOM_OPERATION_SEQUENCES
1743: SET operation_seq_num = DECODE(p_com_operation_rec.new_operation_sequence_number ,
1744: NULL , p_com_operation_rec.operation_sequence_number ,
1745: p_com_operation_rec.new_operation_sequence_number
1746: )
1882: * record for a ECO.
1883: * This procedure will not delete a record in production
1884: * which is already implemented.
1885: * For RTG BO, Procedure will perfrom an Delete from the
1886: * BOM_Operation_Sequences by creating a delete Group.
1887: *********************************************************************/
1888: PROCEDURE Delete_Row
1889: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1890: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1936:
1937: IF BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
1938: THEN
1939:
1940: DELETE FROM BOM_OPERATION_SEQUENCES
1941: WHERE OPERATION_SEQUENCE_ID = l_com_op_unexp_rec.operation_sequence_id ;
1942:
1943:
1944: DELETE FROM BOM_OPERATION_RESOURCES
2296: , REVISED_ITEM_SEQUENCE_ID
2297: , SYSDATE -- Cancellation Date
2298: , p_cancel_comments -- Cancel Comments
2299: , ORIGINAL_SYSTEM_REFERENCE
2300: FROM BOM_OPERATION_SEQUENCES
2301: WHERE operation_sequence_id = p_operation_sequence_id ;
2302:
2303:
2304: --
2303:
2304: --
2305: -- Delete Cancel Revisd Operation from operation table
2306: --
2307: DELETE FROM BOM_OPERATION_SEQUENCES
2308: WHERE operation_sequence_id = p_operation_sequence_id ;
2309:
2310: --
2311: -- Delete child Operation Resources