APPS.BOM_ROUTINGINTERFACE_PUB dependencies on BOM_OP_ROUTINGS_INTERFACE

Line 62: From bom_op_routings_interface

58: priority,
59: cfm_routing_flag,
60: total_product_cycle_time,
61: ctp_flag
62: From bom_op_routings_interface
63: Where process_flag = 1
64: And (g_AllOrgs = g_yes
65: or organization_id = g_OrgId
66: or organization_code = g_OrgCode

Line 516: Delete from bom_op_routings_interface

512: End if; -- insert, update and delete
513:
514: If l_return_status = Fnd_Api.G_RET_STS_SUCCESS then
515: If g_DeleteRows then
516: Delete from bom_op_routings_interface
517: Where rowid = l_interface_rec.rowid;
518: Else
519: Update bom_op_routings_interface
520: Set process_flag = 7,

Line 519: Update bom_op_routings_interface

515: If g_DeleteRows then
516: Delete from bom_op_routings_interface
517: Where rowid = l_interface_rec.rowid;
518: Else
519: Update bom_op_routings_interface
520: Set process_flag = 7,
521: transaction_id = mtl_system_items_interface_s.nextval,
522: request_id = nvl(request_id,g_RequestId),
523: program_id = nvl(program_id,g_ProgramId),

Line 552: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',

548: prog_id => g_ProgramId,
549: req_id => g_RequestId,
550: trans_id => l_transaction_rec.transaction_id,
551: error_text => l_msg_data,
552: tbl_name => 'BOM_OP_ROUTINGS_INTERFACE',
553: msg_name => l_msg_name,
554: err_text => l_msg_data);
555: If l_ret_code <> 0 then
556: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 558: Update bom_op_routings_interface

554: err_text => l_msg_data);
555: If l_ret_code <> 0 then
556: raise FND_API.G_EXC_UNEXPECTED_ERROR;
557: end if;
558: Update bom_op_routings_interface
559: Set process_flag = 3,
560: transaction_id = l_transaction_rec.transaction_id
561: Where rowid = l_interface_rec.rowid;
562: End loop; -- log error