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 161: * Bom_Component_Operations table.

157: * Parameters OUT: Component Operations Record
158: * Return_Status - Indicating success or faliure
159: * Mesg_Token_Tbl - Filled with any errors or warnings
160: * Purpose : Will Insert a new component operatins record in
161: * Bom_Component_Operations table.
162: *
163: ********************************************************************/
164: PROCEDURE Insert_Row
165: ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type

Line 177: INSERT INTO BOM_COMPONENT_OPERATIONS

173: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
174: BEGIN
175:
176:
177: INSERT INTO BOM_COMPONENT_OPERATIONS
178: ( COMP_OPERATION_SEQ_ID
179: , OPERATION_SEQ_NUM
180: , OPERATION_SEQUENCE_ID
181: , BILL_SEQUENCE_ID

Line 210: ( BOM_COMPONENT_OPERATIONS_S.NEXTVAL

206: , PROGRAM_APPLICATION_ID
207: , PROGRAM_UPDATE_DATE
208: )
209: VALUES
210: ( BOM_COMPONENT_OPERATIONS_S.NEXTVAL
211: , p_bom_comp_ops_rec.additional_operation_seq_num
212: , p_bom_comp_ops_unexp_rec.additional_operation_seq_id
213: , p_bom_comp_ops_unexp_rec.bill_sequence_id
214: , SYSDATE

Line 296: FROM BOM_COMPONENT_OPERATIONS

292: l_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: SELECT component_sequence_id, operation_seq_num
295: INTO l_comp_seq_id, l_op_seq_num
296: FROM BOM_COMPONENT_OPERATIONS
297: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
298:
299: DELETE FROM BOM_COMPONENT_OPERATIONS
300: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;

Line 299: DELETE FROM BOM_COMPONENT_OPERATIONS

295: INTO l_comp_seq_id, l_op_seq_num
296: FROM BOM_COMPONENT_OPERATIONS
297: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
298:
299: DELETE FROM BOM_COMPONENT_OPERATIONS
300: WHERE COMP_OPERATION_SEQ_ID = p_comp_operation_seq_id;
301:
302: IF SQL%NOTFOUND THEN
303:

Line 415: FROM BOM_COMPONENT_OPERATIONS

411: , l_bom_comp_ops_rec.attribute12
412: , l_bom_comp_ops_rec.attribute13
413: , l_bom_comp_ops_rec.attribute14
414: , l_bom_comp_ops_rec.attribute15
415: FROM BOM_COMPONENT_OPERATIONS
416: WHERE COMPONENT_SEQUENCE_ID = p_component_sequence_id AND
417: OPERATION_SEQ_NUM = p_additional_operation_seq_num ;
418:
419: x_bom_comp_ops_Rec := l_bom_comp_ops_rec;