APPS.BOM_COMP_OPERATION_UTIL dependencies on BOM_COMPONENT_OPERATIONS

Line 58: UPDATE BOM_COMPONENT_OPERATIONS

54:
55: l_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
58: UPDATE BOM_COMPONENT_OPERATIONS
59: SET OPERATION_SEQ_NUM
60: = decode( p_bom_comp_ops_rec.new_additional_op_seq_num,
61: NULL,
62: p_bom_comp_ops_rec.additional_operation_seq_num,

Line 102: FROM BOM_COMPONENT_OPERATIONS

98: WHERE COMP_OPERATION_SEQ_ID = p_bom_comp_ops_unexp_rec.comp_operation_seq_id ;
99:
100: SELECT component_sequence_id
101: INTO l_comp_seq_id
102: FROM BOM_COMPONENT_OPERATIONS
103: WHERE COMP_OPERATION_SEQ_ID = p_bom_comp_ops_unexp_rec.comp_operation_seq_id ;
104:
105: IF SQL%NOTFOUND THEN
106:

Line 187: * Bom_Component_Operations table.

183: * Parameters OUT: Component Operations Record
184: * Return_Status - Indicating success or faliure
185: * Mesg_Token_Tbl - Filled with any errors or warnings
186: * Purpose : Will Insert a new component operatins record in
187: * Bom_Component_Operations table.
188: *
189: ********************************************************************/
190: PROCEDURE Insert_Row
191: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type

Line 209: INSERT INTO BOM_COMPONENT_OPERATIONS

205: );
206: END IF;
207: --Bug 7712832 changes end
208:
209: INSERT INTO BOM_COMPONENT_OPERATIONS
210: ( COMP_OPERATION_SEQ_ID
211: , OPERATION_SEQ_NUM
212: , OPERATION_SEQUENCE_ID
213: , BILL_SEQUENCE_ID

Line 243: ( BOM_COMPONENT_OPERATIONS_S.NEXTVAL

239: , PROGRAM_UPDATE_DATE
240: , Common_Component_Sequence_Id --added for bug 7713832
241: )
242: VALUES
243: ( BOM_COMPONENT_OPERATIONS_S.NEXTVAL
244: , p_bom_comp_ops_rec.additional_operation_seq_num
245: , p_bom_comp_ops_unexp_rec.additional_operation_seq_id
246: , p_bom_comp_ops_unexp_rec.bill_sequence_id
247: , SYSDATE

Line 332: FROM BOM_COMPONENT_OPERATIONS

328: l_return_status := FND_API.G_RET_STS_SUCCESS;
329:
330: SELECT component_sequence_id, operation_seq_num
331: INTO l_comp_seq_id, l_op_seq_num
332: FROM BOM_COMPONENT_OPERATIONS
333: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
334:
335: DELETE FROM BOM_COMPONENT_OPERATIONS
336: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;

Line 335: DELETE FROM BOM_COMPONENT_OPERATIONS

331: INTO l_comp_seq_id, l_op_seq_num
332: FROM BOM_COMPONENT_OPERATIONS
333: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
334:
335: DELETE FROM BOM_COMPONENT_OPERATIONS
336: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
337:
338: IF SQL%NOTFOUND THEN
339:

Line 451: FROM BOM_COMPONENT_OPERATIONS

447: , l_bom_comp_ops_rec.attribute12
448: , l_bom_comp_ops_rec.attribute13
449: , l_bom_comp_ops_rec.attribute14
450: , l_bom_comp_ops_rec.attribute15
451: FROM BOM_COMPONENT_OPERATIONS
452: WHERE COMPONENT_SEQUENCE_ID = p_component_sequence_id AND
453: OPERATION_SEQ_NUM = p_additional_operation_seq_num ;
454:
455: x_bom_comp_ops_Rec := l_bom_comp_ops_rec;