APPS.BOM_ROUTINGINTERFACE_PUB dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 656: From bom_op_sequences_interface

652: total_time_user,
653: net_planning_percent,
654: include_in_rollup,
655: operation_yield_enabled
656: From bom_op_sequences_interface
657: Where process_flag = 1
658: And (g_AllOrgs = g_yes
659: or organization_id = g_OrgId
660: or organization_code = g_OrgCode

Line 1356: Delete from bom_op_sequences_interface

1352: End if; -- insert, update and delete
1353:
1354: If l_return_status = Fnd_Api.G_RET_STS_SUCCESS then
1355: If g_DeleteRows then
1356: Delete from bom_op_sequences_interface
1357: Where rowid = l_interface_rec.rowid;
1358: Else
1359: Update bom_op_sequences_interface
1360: Set process_flag = 7,

Line 1359: Update bom_op_sequences_interface

1355: If g_DeleteRows then
1356: Delete from bom_op_sequences_interface
1357: Where rowid = l_interface_rec.rowid;
1358: Else
1359: Update bom_op_sequences_interface
1360: Set process_flag = 7,
1361: transaction_id = mtl_system_items_interface_s.nextval,
1362: request_id = nvl(request_id,g_RequestId),
1363: program_id = nvl(program_id,g_ProgramId),

Line 1392: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1388: prog_id => g_ProgramId,
1389: req_id => g_RequestId,
1390: trans_id => l_transaction_rec.transaction_id,
1391: error_text => l_msg_data,
1392: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1393: msg_name => l_msg_name,
1394: err_text => l_msg_data);
1395: If l_ret_code <> 0 then
1396: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1398: Update bom_op_sequences_interface

1394: err_text => l_msg_data);
1395: If l_ret_code <> 0 then
1396: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1397: end if;
1398: Update bom_op_sequences_interface
1399: Set process_flag = 3,
1400: transaction_id = l_transaction_rec.transaction_id
1401: Where rowid = l_interface_rec.rowid;
1402: End loop; -- log error