88: , ATTRIBUTE13 = p_bom_comp_ops_rec.attribute13
89: , ATTRIBUTE14 = p_bom_comp_ops_rec.attribute14
90: , ATTRIBUTE15 = p_bom_comp_ops_rec.attribute15
91: , LAST_UPDATE_DATE = SYSDATE
92: , LAST_UPDATED_BY = BOM_Globals.Get_User_Id
93: , LAST_UPDATE_LOGIN = BOM_Globals.Get_Login_Id
94: , REQUEST_ID = Fnd_Global.Conc_Request_Id
95: , PROGRAM_ID = Fnd_Global.Conc_Program_Id
96: , PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id
89: , ATTRIBUTE14 = p_bom_comp_ops_rec.attribute14
90: , ATTRIBUTE15 = p_bom_comp_ops_rec.attribute15
91: , LAST_UPDATE_DATE = SYSDATE
92: , LAST_UPDATED_BY = BOM_Globals.Get_User_Id
93: , LAST_UPDATE_LOGIN = BOM_Globals.Get_Login_Id
94: , REQUEST_ID = Fnd_Global.Conc_Request_Id
95: , PROGRAM_ID = Fnd_Global.Conc_Program_Id
96: , PROGRAM_APPLICATION_ID = Fnd_Global.Prog_Appl_Id
97: , PROGRAM_UPDATE_DATE = SYSDATE
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
215: , Bom_globals.Get_User_Id
216: , SYSDATE
217: , Bom_Globals.Get_User_Id
218: , Bom_Globals.Get_User_Id
219: , p_bom_comp_ops_unexp_rec.component_sequence_id
213: , p_bom_comp_ops_unexp_rec.bill_sequence_id
214: , SYSDATE
215: , Bom_globals.Get_User_Id
216: , SYSDATE
217: , Bom_Globals.Get_User_Id
218: , Bom_Globals.Get_User_Id
219: , p_bom_comp_ops_unexp_rec.component_sequence_id
220: , p_bom_comp_ops_rec.attribute_category
221: , p_bom_comp_ops_rec.attribute1
214: , SYSDATE
215: , Bom_globals.Get_User_Id
216: , SYSDATE
217: , Bom_Globals.Get_User_Id
218: , Bom_Globals.Get_User_Id
219: , p_bom_comp_ops_unexp_rec.component_sequence_id
220: , p_bom_comp_ops_rec.attribute_category
221: , p_bom_comp_ops_rec.attribute1
222: , p_bom_comp_ops_rec.attribute2
417: OPERATION_SEQ_NUM = p_additional_operation_seq_num ;
418:
419: x_bom_comp_ops_Rec := l_bom_comp_ops_rec;
420: x_bom_comp_ops_unexp_Rec := l_bom_comp_ops_unexp_rec;
421: x_return_status := Bom_Globals.G_RECORD_FOUND;
422:
423: EXCEPTION
424:
425: WHEN OTHERS THEN
424:
425: WHEN OTHERS THEN
426: x_bom_comp_ops_Rec := l_bom_comp_ops_rec;
427: x_bom_comp_ops_unexp_Rec := l_bom_comp_ops_unexp_rec;
428: x_return_status := Bom_Globals.G_RECORD_NOT_FOUND;
429:
430: END Query_Row;
431:
432: PROCEDURE Perform_Writes
443: BEGIN
444: l_bom_comp_ops_rec := p_bom_comp_ops_rec;
445: l_bom_comp_ops_unexp_rec := p_bom_comp_ops_unexp_rec;
446:
447: IF l_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_CREATE
448: THEN
449: Insert_Row( p_bom_comp_ops_rec => l_bom_comp_ops_rec
450: , p_bom_comp_ops_Unexp_Rec => l_bom_comp_ops_unexp_rec
451: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
450: , p_bom_comp_ops_Unexp_Rec => l_bom_comp_ops_unexp_rec
451: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
452: , x_return_status => l_return_status
453: );
454: ELSIF l_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
455: THEN
456: Update_Row( p_bom_comp_ops_rec => l_bom_comp_ops_rec
457: , p_bom_comp_ops_Unexp_Rec => l_bom_comp_ops_unexp_rec
458: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
458: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
459: , x_return_status => l_return_status
460: );
461:
462: ELSIF l_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_DELETE
463: THEN
464: Delete_Row
465: ( p_comp_operation_seq_id => l_bom_comp_ops_unexp_rec.comp_operation_seq_id
466: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl